RFQ_HDR_SRCH(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT , A.RFQ_ID , A.RFQ_STATUS , A.ORIGIN , A.BUYER_ID FROM PS_RFQ_HDR A WHERE EXISTS ( SELECT 'X' FROM PS_RFQ_RESP_LINE X WHERE X.BUSINESS_UNIT = A.BUSINESS_UNIT AND X.RFQ_ID = A.RFQ_ID AND X.RESPONSE_FLAG = 'Y') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_PM_NONVW |
| 2 | RFQ_ID |
Character(10) | VARCHAR2(10) NOT NULL |
RFQ ID
Default Value: NEXT |
| 3 | RFQ_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
RFQ Status
A=Approved C=Closed H=On Hold O=Open X=Canceled Default Value: OPR_DEF_TBL_PM.RFQ_STATUS |
| 4 | ORIGIN | Character(3) | VARCHAR2(3) NOT NULL |
Origin
Default Value: OPR_DEF_TBL_PM.ORIGIN Prompt Table: ORIGIN_PO |
| 5 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL |
Buyer
Prompt Table: BUYER_ACTIVE_VW |