PO_RFQVNDLN_VW

(SQL View)
Index Back

SELECT A.BUSINESS_UNIT , A.RFQ_ID , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , B.LINE_NBR , B.INV_ITEM_ID , B.ITM_SETID FROM PS_RFQ_DISP_HDR A , PS_RFQ_LINE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RFQ_ID = B.RFQ_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RFQ_ID Character(10) VARCHAR2(10) NOT NULL RFQ ID
3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID