View: PO_NOTIFICATION_DETAILS_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.PO_NOTIFICATION_DETAILS_V

View Text

SELECT POH.PO_HEADER_ID
, POH.ORG_ID
, POH.SEGMENT1 PO_NUM
, POH.TYPE_LOOKUP_CODE
, PDTL.TYPE_NAME PO_TYPE_NAME
, POH.APPROVED_DATE
, POH.VENDOR_ID
, VN.VENDOR_NAME
, POH.AGENT_ID
, HRE.FULL_NAME AGENT_NAME
, POH.APPROVED_FLAG
, NVL(PLC.DISPLAYED_FIELD
, 'INCOMPLETE') STATUS
, POH.SHIP_TO_LOCATION_ID
, LOC1.LOCATION_CODE SHIP_TO_LOCATION_CODE
, POH.BILL_TO_LOCATION_ID
, LOC2.LOCATION_CODE BILL_TO_LOCATION_CODE
, POH.CURRENCY_CODE
, FCC.NAME CURRENCY
, POH.COMMENTS
FROM PO_HEADERS_ALL POH
, PO_DOCUMENT_TYPES_VL PDTL
, HR_EMPLOYEES_CURRENT_V HRE
, PO_LOOKUP_CODES PLC
, PO_VENDORS VN
, FND_CURRENCIES_TL FCC
, HR_LOCATIONS_ALL_TL LOC1
, HR_LOCATIONS_ALL_TL LOC2
WHERE POH.TYPE_LOOKUP_CODE = PDTL.DOCUMENT_SUBTYPE
AND PDTL.DOCUMENT_TYPE_CODE IN ('PO'
, 'PA')
AND POH.VENDOR_ID = VN.VENDOR_ID(+)
AND POH.AGENT_ID = HRE.EMPLOYEE_ID(+)
AND POH.AUTHORIZATION_STATUS = PLC.LOOKUP_CODE(+)
AND PLC.LOOKUP_TYPE(+) = 'AUTHORIZATION STATUS'
AND POH.CURRENCY_CODE = FCC.CURRENCY_CODE(+)
AND FCC.LANGUAGE(+) = USERENV('LANG')
AND POH.SHIP_TO_LOCATION_ID = LOC1.LOCATION_ID(+)
AND LOC1.LANGUAGE(+) = USERENV('LANG')
AND POH.BILL_TO_LOCATION_ID = LOC2.LOCATION_ID(+)
AND LOC2.LANGUAGE(+) = USERENV('LANG')

Columns