VIEW: APPS.POS_ORDER_SUMMARY_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')