CONTRACT_NUMPrompt Table: CUST_SLD_VW
Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT
Prompt Table: CA_BUS_UNIT_VW
CA_CONTRACT_VW2(SQL View) |
Index Back |
|---|---|
Contract Header Search ViewThis is the Self-Service iClient version of the Contract Header Search View. |
| SELECT DISTINCT CONTRACT_NUM ,HDR.SOLD_TO_CUST_ID ,CUST.NAME1 ,BUSINESS_UNIT ,CA_STATUS FROM PS_CA_CONTR_HDR HDR ,PS_CUST_SLD_VW 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' AND EXISTS( SELECT 'X' FROM PS_CA_OPRID_CONTR WHERE CONTRACT_NUM = HDR.CONTRACT_NUM) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 3 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL |
Name 1
Prompt Table: CUST_SLD_VW |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT Prompt Table: CA_BUS_UNIT_VW |
| 5 | CA_STATUS | Character(24) | VARCHAR2(24) NOT NULL | Contract Status |