VIEW: APPS.FV_PO_MASTER_V

Source

View Text - Preformatted

SELECT ph.org_id,ph.po_header_id,pl.po_line_id,pll.line_location_id,ph.vendor_id,ph.vendor_site_id, pr.po_release_id,ph.segment1,ph.creation_date,pr.release_num,ph.agent_id, po_headers_sv3.get_po_status(ph.po_header_id), pll.cancel_flag,pl.line_num,pll.shipment_num,pll.quantity,pll.quantity_received, pll.quantity_billed ,pl.item_id,pl.category_id, pl.unit_price,pl.unit_meas_lookup_code,pl.item_description FROM po_headers ph,po_line_locations pll,po_releases pr,po_lines pl WHERE ph.po_header_id = pl.po_header_id AND pll.po_line_id(+) = pl.po_line_id AND pll.po_release_id = pr.po_release_id(+) AND type_lookup_code NOT IN ('CONTRACT')

View Text - HTML Formatted

SELECT PH.ORG_ID
, PH.PO_HEADER_ID
, PL.PO_LINE_ID
, PLL.LINE_LOCATION_ID
, PH.VENDOR_ID
, PH.VENDOR_SITE_ID
, PR.PO_RELEASE_ID
, PH.SEGMENT1
, PH.CREATION_DATE
, PR.RELEASE_NUM
, PH.AGENT_ID
, PO_HEADERS_SV3.GET_PO_STATUS(PH.PO_HEADER_ID)
, PLL.CANCEL_FLAG
, PL.LINE_NUM
, PLL.SHIPMENT_NUM
, PLL.QUANTITY
, PLL.QUANTITY_RECEIVED
, PLL.QUANTITY_BILLED
, PL.ITEM_ID
, PL.CATEGORY_ID
, PL.UNIT_PRICE
, PL.UNIT_MEAS_LOOKUP_CODE
, PL.ITEM_DESCRIPTION
FROM PO_HEADERS PH
, PO_LINE_LOCATIONS PLL
, PO_RELEASES PR
, PO_LINES PL
WHERE PH.PO_HEADER_ID = PL.PO_HEADER_ID
AND PLL.PO_LINE_ID(+) = PL.PO_LINE_ID
AND PLL.PO_RELEASE_ID = PR.PO_RELEASE_ID(+)
AND TYPE_LOOKUP_CODE NOT IN ('CONTRACT')