|
SELECT DISTINCT A.SETID , A.CNTRCT_ID , SL.LANGUAGE_CD , SL.CNTRCT_STYLE_NAME , VL.NAME1 FROM PS_CNTRCT_HDR A , PS_VENDOR B , PS_CNTRCT_STYLE S , PS_CNTRCT_STL_LNG SL , PS_VENDOR_LANG VL WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.CNTRCT_STYLE = S.CNTRCT_STYLE AND B.SETID = VL.SETID AND B.VENDOR_ID = VL.VENDOR_ID AND S.CNTRCT_STYLE = SL.CNTRCT_STYLE AND VL.LANGUAGE_CD = SL.LANGUAGE_CD AND A.CNTRCT_STATUS = 'A' AND A.VERSION_STATUS = 'C' AND A.CNTRCT_CF_LOCK = 'N' AND ( (A.CNTRCT_TYPE = 'PO' OR A.CNTRCT_TYPE = 'GN') AND (A.CNTRCT_EXPIRE_DT IS NULL OR (A.CNTRCT_EXPIRE_DT IS NOT NULL AND A.CNTRCT_EXPIRE_DT >= %CurrentDateIn)) AND NOT EXISTS( SELECT 'X' FROM %Table(CS_CNTRCT_HD_SN) CS WHERE A.SETID = CS.SETID AND A.CNTRCT_ID = CS.CNTRCT_ID) AND ( (A.ALLOW_OPEN_ITEM = 'Y') OR EXISTS ( SELECT 'X' FROM PS_CNTRCT_LINE_UOM C , PS_CNTRCT_LN_SHIP D , PS_CNTRCT_LINE E WHERE E.SETID = A.SETID AND E.CNTRCT_ID = A.CNTRCT_ID AND E.VERSION_NBR = A.VERSION_NBR AND C.SETID = E.SETID AND C.CNTRCT_ID = E.CNTRCT_ID AND C.VERSION_NBR = E.VERSION_NBR AND C.CNTRCT_LINE_NBR = E.CNTRCT_LINE_NBR AND D.SETID = E.SETID AND D.CNTRCT_ID = E.CNTRCT_ID AND D.VERSION_NBR = E.VERSION_NBR AND D.CNTRCT_LINE_NBR = E.CNTRCT_LINE_NBR AND E.DESCR254_MIXED <> ' ' AND E.CATEGORY_ID <> ' ' AND E.UNIT_OF_MEASURE <> ' ' AND C.VNDR_LOC <> ' ' AND C.PRICE_CNTRCT_BASE <> 0 AND D.QTY_SCHED <> 0) OR EXISTS ( SELECT 'X' FROM PS_CNTRCT_CATEGORY C WHERE C.SETID = A.SETID AND C.CNTRCT_ID = A.CNTRCT_ID AND C.VERSION_NBR = A.VERSION_NBR AND C.CATEGORY_ID <> ' ') )) AND NOT EXISTS ( SELECT 'X' FROM PS_CNTRCT_BPO_XREF F WHERE A.SETID = F.SETID AND A.CNTRCT_ID = F.CNTRCT_ID) AND NOT EXISTS ( SELECT 'X' FROM PS_CNTRCT_RPO_XREF X WHERE A.SETID = X.SETID AND A.CNTRCT_ID = X.CNTRCT_ID)
|
SETID