CA_HDR_ACT_VW

(SQL View)
Index Back

Contract Header VW Active Only


SELECT CONTRACT_NUM , BUSINESS_UNIT , SOLD_TO_CUST_ID FROM PS_CA_CONTR_HDR WHERE CA_PROC_STATUS = 'A' AND CA_RQST_SRC <> 'OND'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

Prompt Table: CA_BU_SP_NONVW

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT

Prompt Table: SP_BU_CA_NONVW

3 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

Prompt Table: CUST_SLD_VW