VIEW: APPS.OE_RELATED_PO_NUMBERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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