BUSINESS_UNITRFQ_IDSETIDRFQ_VNDR_GROUPRFQ_DISP_JOIN(SQL View) |
Index Back |
|---|---|
Join RFQ HDR and Supplier grou |
| SELECT a.business_unit, a.rfq_id, b.setid, b.rfq_vndr_group, b.vendor_setid, b.vendor_id, b.vndr_loc FROM PS_RFQ_HDR a, ps_rfq_vndr_tbl b |
| # | 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 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | RFQ_VNDR_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Quote Group ID |
| 5 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 6 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 7 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |