SETIDCNTRCT_ID_CHILDLANGUAGE_CDCS_CTCHIREL_LVW(SQL View) |
Index Back |
|---|---|
Contract Search for PO's Lang11/15/2015 tbg PO0025 - Master contract BIND MAPS |
| SELECT A.SETID , A.CNTRCT_ID , SL.LANGUAGE_CD , SL.CNTRCT_STYLE_NAME , VL.NAME1 FROM PS_CNTRCT_HDR A , PS_VENDOR B , PS_CNTRCT_STYLE S , PS_CNTRCT_STL_LNG SL , PS_VENDOR_LANG VL WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.CNTRCT_STYLE = S.CNTRCT_STYLE AND A.VERSION_STATUS = 'C' AND B.SETID = VL.SETID AND B.VENDOR_ID = VL.VENDOR_ID AND S.CNTRCT_STYLE = SL.CNTRCT_STYLE AND VL.LANGUAGE_CD = SL.LANGUAGE_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CNTRCT_ID_CHILD |
Character(25) | VARCHAR2(25) NOT NULL | Contract ID To |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | CNTRCT_STYLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Contract Style |
| 5 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |