Product: | POS - iSupplier Portal |
---|---|
Description: | |
Implementation/DBA Data: | APPS.POS_ORDER_SUMMARY_V |
SELECT POR.APPROVED_DATE
, NVL(POR.AUTHORIZATION_STATUS
, 'INCOMPLETE')
, POH.COMMENTS
, POR.REVISED_DATE
, POR.REVISION_NUM
, POR.AGENT_ID
, POH.FROM_HEADER_ID
, POR.PO_HEADER_ID
, POH.SHIP_TO_LOCATION_ID
, POH.VENDOR_CONTACT_ID
, POH.VENDOR_ID
, POH.VENDOR_SITE_ID
, POH.CURRENCY_CODE
, POH.TYPE_LOOKUP_CODE
, POR.CREATED_BY
, POR.RELEASE_DATE
, POR.LAST_UPDATED_BY
, POR.LAST_UPDATE_DATE
, POR.LAST_UPDATE_LOGIN
, POH.SEGMENT1 || '-' || POR.RELEASE_NUM
, POR.ATTRIBUTE_CATEGORY
, POR.ATTRIBUTE1
, POR.ATTRIBUTE2
, POR.ATTRIBUTE3
, POR.ATTRIBUTE4
, POR.ATTRIBUTE5
, POR.ATTRIBUTE6
, POR.ATTRIBUTE7
, POR.ATTRIBUTE8
, POR.ATTRIBUTE9
, POR.ATTRIBUTE10
, POR.ATTRIBUTE11
, POR.ATTRIBUTE12
, POR.ATTRIBUTE13
, POR.ATTRIBUTE14
, POR.ATTRIBUTE15
, POS_GET.GET_PERSON_NAME(POR.AGENT_ID)
, V.VENDOR_NAME
, VS.VENDOR_SITE_CODE
, POLC.DISPLAYED_FIELD
, POR.RELEASE_NUM
, POR.RELEASE_TYPE
, POR.PO_RELEASE_ID
, TO_CHAR( POS_TOTALS_PO_SV.GET_RELEASE_ARCHIVE_TOTAL(POR.PO_RELEASE_ID
, POR.REVISION_NUM)
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(POH.CURRENCY_CODE
, 30))
, V.ATTRIBUTE14
, POH.GLOBAL_AGREEMENT_FLAG
, POR.ORG_ID
, PDTA.SECURITY_LEVEL_CODE
, PDTA.ACCESS_LEVEL_CODE
FROM PO_LOOKUP_CODES POLC
, PO_VENDORS V
, PO_VENDOR_SITES_ALL VS
, PO_RELEASES_ARCHIVE_ALL POR
, PO_HEADERS_ARCHIVE_ALL POH
, PO_DOCUMENT_TYPES_ALL_B PDTA
WHERE POH.PO_HEADER_ID = POR.PO_HEADER_ID
AND V.VENDOR_ID = POH.VENDOR_ID
AND VS.VENDOR_SITE_ID = POH.VENDOR_SITE_ID
AND POLC.LOOKUP_CODE = NVL(POH.AUTHORIZATION_STATUS
, 'INCOMPLETE')
AND POLC.LOOKUP_TYPE = 'AUTHORIZATION STATUS'
AND POH.TYPE_LOOKUP_CODE IN ('BLANKET'
, 'PLANNED')
AND POH.LATEST_EXTERNAL_FLAG ='Y'
AND POR.LATEST_EXTERNAL_FLAG='Y'
AND PDTA.ORG_ID=POH.ORG_ID
AND PDTA.DOCUMENT_SUBTYPE = POH.TYPE_LOOKUP_CODE
AND PDTA.DOCUMENT_TYPE_CODE IN ('PO'
, 'PA')