CNTRCT_RLS_VW

(SQL View)
 Index Back

Contract Release HDR View - PO


SELECT DISTINCT A.SETID , A.CNTRCT_ID FROM PS_CNTRCT_RLS_HDR A WHERE A.RELEASE_TYPE = 'P' AND A.RELEASE_STATUS = 'O' AND A.BUYER_ID <> ' ' AND NOT EXISTS ( SELECT 'X' FROM PS_CNTRCT_RLS_DTL D WHERE %Join(COMMON_KEYS, CNTRCT_RLS_HDR A, CNTRCT_RLS_LN D) AND (D.LOCATION = ' ' OR D.SHIPTO_ID = ' '))

# 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 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID