C360_RECCTR1_VW

(SQL View)
 Index Back

Contract Header View

Contract Header View- Filter View

SELECT CUST.SETID ,HDR.CONTRACT_NUM FROM PS_CA_CONTR_HDR HDR , PS_CUSTOMER CUST , PS_SET_CNTRL_GROUP D WHERE HDR.SOLD_TO_CUST_ID = CUST.CUST_ID AND D.REC_GROUP_ID = ( SELECT REC_GROUP_ID FROM PS_REC_GROUP_REC WHERE RECNAME = 'CUSTOMER') AND CUST.SETID = D.SETID AND HDR.BUSINESS_UNIT = D.SETCNTRLVALUE AND CUST.CUST_STATUS = 'A' AND CUST.EXP_PENDING = 'N' AND CUST.SOLD_TO_FLG = 'Y' AND HDR.CA_RQST_SRC <> 'OND'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

Prompt Table: CA_CONTR_HDR