View: PJM_PROJECT_BLANKET_PO_V

Product:	PJM - Project Manufacturing
Description:	Project related blanket purchase releases for Web Inquiry.
Implementation/DBA Data:	APPS.PJM_PROJECT_BLANKET_PO_V

View Text

SELECT DISTINCT DIST.PROJECT_ID
, DIST.TASK_ID
, POR.PO_HEADER_ID
, POH.SEGMENT1
, PDT.TYPE_NAME
, POR.PO_RELEASE_ID
, POR.RELEASE_NUM
, POR.REVISION_NUM
, POR.REVISED_DATE
, POR.RELEASE_DATE
, POR.PRINTED_DATE
, POLC.DISPLAYED_FIELD
, POLC4.DISPLAYED_FIELD
, POH.VENDOR_ID
, V.VENDOR_NAME
, POH.VENDOR_CONTACT_ID
, DECODE(VC.LAST_NAME
, NULL
, NULL
, VC.LAST_NAME||'
, '||VC.FIRST_NAME)
, POH.VENDOR_SITE_ID
, VS.VENDOR_SITE_CODE
, POH.SHIP_TO_LOCATION_ID
, HRL1.LOCATION_CODE
, POH.SHIP_VIA_LOOKUP_CODE
, POLC3.DISPLAYED_FIELD
, POLC2.DISPLAYED_FIELD
, POR.AGENT_ID
, PO_INQ_SV.GET_PERSON_NAME(POR.AGENT_ID)
, POH.BILL_TO_LOCATION_ID
, HRL2.LOCATION_CODE
, POH.TERMS_ID
, AT.NAME
, POH.CURRENCY_CODE
, TO_CHAR( PO_TOTALS_PO_SV.GET_RELEASE_TOTAL( POR.PO_RELEASE_ID )
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( POH.CURRENCY_CODE
, 40 ) )
, MSI.CONCATENATED_SEGMENTS
, POL.ITEM_DESCRIPTION
, DIST.END_ITEM_UNIT_NUMBER
FROM PO_DOCUMENT_TYPES PDT
, PO_LOOKUP_CODES POLC
, PO_LOOKUP_CODES POLC2
, PO_LOOKUP_CODES POLC3
, PO_LOOKUP_CODES POLC4
, PO_VENDORS V
, PO_VENDOR_SITES VS
, PO_VENDOR_CONTACTS VC
, AP_TERMS AT
, HR_LOCATIONS HRL1
, HR_LOCATIONS HRL2
, PO_RELEASES POR
, PO_HEADERS POH
, PO_LINES POL
, PO_DISTRIBUTIONS DIST
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE POH.PO_HEADER_ID = POR.PO_HEADER_ID
AND PDT.DOCUMENT_TYPE_CODE = 'RELEASE'
AND PDT.DOCUMENT_SUBTYPE = POR.RELEASE_TYPE
AND V.VENDOR_ID (+) = POH.VENDOR_ID
AND VS.VENDOR_SITE_ID (+) = POH.VENDOR_SITE_ID
AND VC.VENDOR_CONTACT_ID (+) = POH.VENDOR_CONTACT_ID
AND AT.TERM_ID (+) = POH.TERMS_ID
AND HRL1.LOCATION_ID (+) = POH.SHIP_TO_LOCATION_ID
AND HRL2.LOCATION_ID (+) = POH.BILL_TO_LOCATION_ID
AND POLC.LOOKUP_CODE = NVL(POR.AUTHORIZATION_STATUS
, 'INCOMPLETE')
AND POLC.LOOKUP_TYPE = 'AUTHORIZATION STATUS'
AND POLC2.LOOKUP_CODE (+) = POH.FOB_LOOKUP_CODE
AND POLC2.LOOKUP_TYPE (+) = 'FOB'
AND POLC3.LOOKUP_CODE (+) = POH.FREIGHT_TERMS_LOOKUP_CODE
AND POLC3.LOOKUP_TYPE (+) = 'FREIGHT TERMS'
AND POLC4.LOOKUP_CODE = NVL(POR.CLOSED_CODE
, 'OPEN')
AND POLC4.LOOKUP_TYPE = 'DOCUMENT STATE'
AND POH.TYPE_LOOKUP_CODE = 'BLANKET'
AND POR.APPROVED_FLAG IN ( 'Y'
, 'R' )
AND DIST.PO_HEADER_ID = POH.PO_HEADER_ID
AND DIST.PO_RELEASE_ID = POR.PO_RELEASE_ID
AND DIST.PO_LINE_ID = POL.PO_LINE_ID
AND MSI.ORGANIZATION_ID = DIST.DESTINATION_ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = POL.ITEM_ID

Columns