[Home] [Help]
View: PO_BY_BUYER_V
Product: | PO - Purchasing |
Description: | Purchase order information by buyer |
Implementation/DBA Data: |
APPS.PO_BY_BUYER_V
|
View Text
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
Columns
Name |
PO_NO |
PO_TYPE |
PO_DATE |
BUYER_NAME |
VENDOR_NAME |
PO_AMOUNT |
CURRENCY |
ORG_ID |