RFQ_RESP_SRCH(SQL View) |
Index Back |
---|
SELECT A.BUSINESS_UNIT , A.RFQ_ID , A.VENDOR_ID , A.VNDR_LOC , V.VENDOR_NAME_SHORT FROM PS_RFQ_DISP_HDR A , PS_VENDOR V , PS_RFQ_HDR H WHERE A.VENDOR_SETID = V.SETID AND A.VENDOR_ID = V.VENDOR_ID AND A.BUSINESS_UNIT = H.BUSINESS_UNIT AND A.RFQ_ID = H.RFQ_ID AND RFQ_STATUS = 'A' |
# | 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
Prompt Table: RFQ_HDR |
3 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_VW |
4 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table: VENDOR_LOC_VW |
5 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL |
Short Vendor Name
Prompt Table: VENDOR_NAME_VW |