Product: | POS - iSupplier Portal |
---|---|
Description: | |
Implementation/DBA Data: | APPS.POS_SUPP_AGREEMENTS_V |
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')