VIEW: APPS.POS_SUPP_AGREEMENTS_V

Source

View Text - Preformatted

SELECT poh.comments, POH.GLOBAL_AGREEMENT_FLAG, POH.ACCEPTANCE_DUE_DATE , TO_CHAR(NULL) , POH.APPROVED_DATE , POH.START_DATE, POH.END_DATE, DECODE(POH.CANCEL_FLAG, 'Y', 'CANCELLED', NVL(POH.CLOSED_CODE, 'OPEN')) , TO_CHAR(NULL) , TO_CHAR(NULL) , POH.REVISED_DATE , POH.REVISION_NUM , POH.AGENT_ID , POH.PO_HEADER_ID , POH.VENDOR_CONTACT_ID , POH.VENDOR_ID , POH.VENDOR_SITE_ID , NVL(POH.CLOSED_CODE, 'OPEN') , POH.CURRENCY_CODE , POH.TYPE_LOOKUP_CODE , POH.ACCEPTANCE_REQUIRED_FLAG , POH.APPROVED_FLAG , DECODE(POH.CANCEL_FLAG, 'I', NULL, POH.CANCEL_FLAG) , POH.CREATED_BY , POH.APPROVED_DATE , POH.LAST_UPDATED_BY , POH.LAST_UPDATE_DATE , POH.LAST_UPDATE_LOGIN , POH.SEGMENT1 , POH.ATTRIBUTE_CATEGORY , POH.ATTRIBUTE1 , POH.ATTRIBUTE2 , POH.ATTRIBUTE3 , POH.ATTRIBUTE4 , POH.ATTRIBUTE5 , POH.ATTRIBUTE6 , POH.ATTRIBUTE7 , POH.ATTRIBUTE8 , POH.ATTRIBUTE9 , POH.ATTRIBUTE10 , POH.ATTRIBUTE11 , POH.ATTRIBUTE12 , POH.ATTRIBUTE13 , POH.ATTRIBUTE14 , POH.ATTRIBUTE15 , to_char(NULL) , V.VENDOR_NAME , V.SEGMENT1 VENDOR_NUMBER, VS.VENDOR_SITE_CODE , POLC.displayed_field, TO_CHAR(NULL) , POH.ORG_ID, HOU.name FROM PO_VENDORS V, PO_VENDOR_SITES_ALL VS, PO_HEADERS_ARCHIVE_ALL POH, HR_ALL_ORGANIZATION_UNITS_TL hou, PO_LOOKUP_CODES POLC WHERE V.VENDOR_ID = POH.VENDOR_ID AND VS.VENDOR_SITE_ID = POH.VENDOR_SITE_ID AND POH.TYPE_LOOKUP_CODE = 'BLANKET' AND POLC.LOOKUP_CODE = DECODE(POH.CANCEL_FLAG, 'Y', 'CANCELLED', NVL(POH.CLOSED_CODE, 'OPEN')) AND POLC.LOOKUP_TYPE = 'DOCUMENT STATE' AND POH.LATEST_EXTERNAL_FLAG = 'Y' AND HOU.ORGANIZATION_ID (+) = POH.ORG_ID AND HOU.LANGUAGE (+) = USERENV('LANG')

View Text - HTML Formatted

SELECT POH.COMMENTS
, POH.GLOBAL_AGREEMENT_FLAG
, POH.ACCEPTANCE_DUE_DATE
, TO_CHAR(NULL)
, POH.APPROVED_DATE
, POH.START_DATE
, POH.END_DATE
, DECODE(POH.CANCEL_FLAG
, 'Y'
, 'CANCELLED'
, NVL(POH.CLOSED_CODE
, 'OPEN'))
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, POH.REVISED_DATE
, POH.REVISION_NUM
, POH.AGENT_ID
, POH.PO_HEADER_ID
, POH.VENDOR_CONTACT_ID
, POH.VENDOR_ID
, POH.VENDOR_SITE_ID
, NVL(POH.CLOSED_CODE
, 'OPEN')
, POH.CURRENCY_CODE
, POH.TYPE_LOOKUP_CODE
, POH.ACCEPTANCE_REQUIRED_FLAG
, POH.APPROVED_FLAG
, DECODE(POH.CANCEL_FLAG
, 'I'
, NULL
, POH.CANCEL_FLAG)
, POH.CREATED_BY
, POH.APPROVED_DATE
, POH.LAST_UPDATED_BY
, POH.LAST_UPDATE_DATE
, POH.LAST_UPDATE_LOGIN
, POH.SEGMENT1
, POH.ATTRIBUTE_CATEGORY
, POH.ATTRIBUTE1
, POH.ATTRIBUTE2
, POH.ATTRIBUTE3
, POH.ATTRIBUTE4
, POH.ATTRIBUTE5
, POH.ATTRIBUTE6
, POH.ATTRIBUTE7
, POH.ATTRIBUTE8
, POH.ATTRIBUTE9
, POH.ATTRIBUTE10
, POH.ATTRIBUTE11
, POH.ATTRIBUTE12
, POH.ATTRIBUTE13
, POH.ATTRIBUTE14
, POH.ATTRIBUTE15
, TO_CHAR(NULL)
, V.VENDOR_NAME
, V.SEGMENT1 VENDOR_NUMBER
, VS.VENDOR_SITE_CODE
, POLC.DISPLAYED_FIELD
, TO_CHAR(NULL)
, POH.ORG_ID
, HOU.NAME
FROM PO_VENDORS V
, PO_VENDOR_SITES_ALL VS
, PO_HEADERS_ARCHIVE_ALL POH
, HR_ALL_ORGANIZATION_UNITS_TL HOU
, PO_LOOKUP_CODES POLC
WHERE V.VENDOR_ID = POH.VENDOR_ID
AND VS.VENDOR_SITE_ID = POH.VENDOR_SITE_ID
AND POH.TYPE_LOOKUP_CODE = 'BLANKET'
AND POLC.LOOKUP_CODE = DECODE(POH.CANCEL_FLAG
, 'Y'
, 'CANCELLED'
, NVL(POH.CLOSED_CODE
, 'OPEN'))
AND POLC.LOOKUP_TYPE = 'DOCUMENT STATE'
AND POH.LATEST_EXTERNAL_FLAG = 'Y'
AND HOU.ORGANIZATION_ID (+) = POH.ORG_ID
AND HOU.LANGUAGE (+) = USERENV('LANG')