CA_CONTR_LG_VW(SQL View) |
Index Back |
---|---|
Contract Header Search ViewThis is the Self-Service iClient version of the Contract Header Search View. |
SELECT DISTINCT CONTRACT_NUM ,CUST.LANGUAGE_CD FROM PS_CA_CONTR_HDR HDR ,PS_CUST_VW_LNG CUST ,PS_SET_CNTRL_REC REC WHERE HDR.SOLD_TO_CUST_ID = CUST.CUST_ID AND REC.SETCNTRLVALUE = HDR.BUSINESS_UNIT AND REC.SETID = CUST.SETID AND REC.RECNAME = 'CUST_SLD_VW' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |