View: PJM_PROJECT_PO_V

Product:	PJM - Project Manufacturing
Description:	Project related purchase order information for the Web Inquiry.
Implementation/DBA Data:	APPS.PJM_PROJECT_PO_V

View Text

SELECT DISTINCT DIST.PROJECT_ID
, DIST.TASK_ID
, POH.PO_HEADER_ID
, POH.SEGMENT1
, PDT.TYPE_NAME
, POH.REVISION_NUM
, POH.REVISED_DATE
, POH.CREATION_DATE
, POLC.DISPLAYED_FIELD
, POH.VENDOR_ID
, V.VENDOR_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
, POH.AGENT_ID
, EMP.FULL_NAME
, POH.BILL_TO_LOCATION_ID
, HRL2.LOCATION_CODE
, POH.TERMS_ID
, AT.NAME
, POH.CURRENCY_CODE
, TO_CHAR( PO_TOTALS_PO_SV.GET_PO_TOTAL( POH.PO_HEADER_ID )
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( POH.CURRENCY_CODE
, 40 ) )
, MIF.ITEM_NUMBER
, 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
, AP_TERMS AT
, HR_LOCATIONS HRL1
, HR_LOCATIONS HRL2
, PER_ALL_PEOPLE_F EMP
, PO_HEADERS POH
, PO_LINES POL
, PO_DISTRIBUTIONS DIST
, MTL_ITEM_FLEXFIELDS MIF
WHERE PDT.DOCUMENT_TYPE_CODE IN ('PO'
, 'PA')
AND PDT.DOCUMENT_SUBTYPE = POH.TYPE_LOOKUP_CODE
AND V.VENDOR_ID (+) = POH.VENDOR_ID
AND VS.VENDOR_ID (+) = POH.VENDOR_ID
AND VS.VENDOR_SITE_ID (+) = POH.VENDOR_SITE_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 EMP.PERSON_ID = POH.AGENT_ID
AND TRUNC(SYSDATE) BETWEEN EMP.EFFECTIVE_START_DATE
AND EMP.EFFECTIVE_END_DATE
AND POLC.LOOKUP_CODE = NVL(POH.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(POH.CLOSED_CODE
, 'OPEN')
AND POLC4.LOOKUP_TYPE = 'DOCUMENT STATE'
AND POH.TYPE_LOOKUP_CODE = 'STANDARD'
AND POH.APPROVED_FLAG IN ('Y')
AND POL.PO_LINE_ID = DIST.PO_LINE_ID
AND POH.PO_HEADER_ID = POL.PO_HEADER_ID
AND MIF.ORGANIZATION_ID (+) = POL.ORG_ID
AND MIF.INVENTORY_ITEM_ID (+) = POL.ITEM_ID

Columns