SETIDCNTRCT_IDBUSINESS_UNITCNTRCT_DFLBU_VW(SQL View) |
Index Back |
|---|---|
Contract Defaults BUsContract Defaults BUs |
| SELECT a.setid , a.cntrct_id , a.business_unit , b.descr , a.vndr_loc , a.buyer_id FROM PS_CNTRCT_DEFAULTS a , ps_bus_unit_tbl_fs b WHERE a.business_unit = b.business_unit AND EXISTS ( SELECT 'X' FROM ps_cntrct_hdr c WHERE c.setid = a.setid AND c.cntrct_id = a.cntrct_id AND c.version_status = 'C') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CNTRCT_ID |
Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 6 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |