CA_RNW_VW

(SQL View)
 Index Back

SELECT Contract_num ,Business_Unit , CUST.NAME1 FROM PS_CA_CONTR_HDR HDR ,PS_CUST_SLD_VW CUST WHERE HDR.SOLD_TO_CUST_ID = CUST.CUST_ID AND HDR.CA_PROC_STATUS = 'A' AND EXISTS ( SELECT 1 FROM PS_CA_DETAIL WHERE CONTRACT_NUM = HDR.CONTRACT_NUM AND RENEWABLE = 'Y' AND CHG_STATUS <> 'P' AND CA_LINE_STATUS IN ('A','P'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TARGET_CONTRACT Character(25) VARCHAR2(25) NOT NULL PSIRS-KK
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name