AR_CA_HDR_VW

(SQL View)
 Index Back

Contract Header VW Active Only

View to list the valid contracts for the contract business unit

SELECT DISTINCT B.BUSINESS_UNIT , B.CONTRACT_NUM , B.SOLD_TO_CUST_ID FROM PS_BUS_UNIT_TBL_CA A , PS_CA_CONTR_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.CA_PROC_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_CA Character(5) VARCHAR2(5) NOT NULL Contracts Business Unit
2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
3 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer