VIEW: APPS.PO_BY_BUYER_V

Source

View Text - Preformatted

SELECT poh.segment1, poh.type_lookup_code, poh.creation_date, ppf.full_name, rtrim(pov.vendor_name), round(sum(pll.price_override*(pll.quantity - pll.quantity_cancelled)), 2), poh.currency_code, poh.org_id from po_headers poh ,po_vendors pov ,po_line_locations_all pll ,per_people_f ppf where poh.po_header_id = pll.po_header_id and poh.vendor_id = pov.vendor_id and nvl(poh.approved_flag,'N') = 'Y' and poh.agent_id = ppf.person_id group by poh.segment1, poh.type_lookup_code, poh.creation_date, pov.vendor_name, poh.currency_code, ppf.full_name, poh.org_id

View Text - HTML Formatted

SELECT POH.SEGMENT1
, POH.TYPE_LOOKUP_CODE
, POH.CREATION_DATE
, PPF.FULL_NAME
, RTRIM(POV.VENDOR_NAME)
, ROUND(SUM(PLL.PRICE_OVERRIDE*(PLL.QUANTITY - PLL.QUANTITY_CANCELLED))
, 2)
, POH.CURRENCY_CODE
, POH.ORG_ID
FROM PO_HEADERS POH
, PO_VENDORS POV
, PO_LINE_LOCATIONS_ALL PLL
, PER_PEOPLE_F PPF
WHERE POH.PO_HEADER_ID = PLL.PO_HEADER_ID
AND POH.VENDOR_ID = POV.VENDOR_ID
AND NVL(POH.APPROVED_FLAG
, 'N') = 'Y'
AND POH.AGENT_ID = PPF.PERSON_ID GROUP BY POH.SEGMENT1
, POH.TYPE_LOOKUP_CODE
, POH.CREATION_DATE
, POV.VENDOR_NAME
, POH.CURRENCY_CODE
, PPF.FULL_NAME
, POH.ORG_ID