View: OE_RELATED_PO_NUMBERS_V

Product:	ONT - Order Management
Description:	Internal
Implementation/DBA Data:	APPS.OE_RELATED_PO_NUMBERS_V

View Text

SELECT DISTINCT SEGMENT1
, REVISION_NUM
, VENDOR_NAME
, FULL_NAME
, PO_HEADER_ID
FROM ( SELECT MAX(PERP.EFFECTIVE_START_DATE) OVER (PARTITION BY PERP.PERSON_ID) AS MAX_EF_ST_DATE
, MAX(PERP.EFFECTIVE_END_DATE) OVER (PARTITION BY PERP.PERSON_ID) AS MAX_EF_END_DATE
, POH.SEGMENT1 AS SEGMENT1
, POH.REVISION_NUM AS REVISION_NUM
, POV.VENDOR_NAME AS VENDOR_NAME
, PERP.FULL_NAME AS FULL_NAME
, POH.PO_HEADER_ID AS PO_HEADER_ID
, PERP.EFFECTIVE_START_DATE AS EFFECTIVE_START_DATE
, PERP.EFFECTIVE_END_DATE AS EFFECTIVE_END_DATE
FROM PO_HEADERS POH
, PER_PEOPLE_F PERP
, PO_VENDORS POV
WHERE POV.VENDOR_ID (+) = POH.VENDOR_ID
AND POH.AGENT_ID = PERP.PERSON_ID
AND EXISTS (SELECT SO.PO_HEADER_ID
FROM OE_DROP_SHIP_SOURCES SO
WHERE SO.PO_HEADER_ID=POH.PO_HEADER_ID ) ORDER BY POH.SEGMENT1)
WHERE EFFECTIVE_START_DATE = MAX_EF_ST_DATE
AND EFFECTIVE_END_DATE = MAX_EF_END_DATE

Columns