FND Design Data [Home] [Help]

View: PO_PURCHASE_ORDER_V

Product: PO - Purchasing
Description: Purchase order
Implementation/DBA Data: ViewAPPS.PO_PURCHASE_ORDER_V
View Text

SELECT POH.SEGMENT1
, TO_NUMBER('')
, POH.CREATION_DATE
, PPF.FULL_NAME
, POV.VENDOR_NAME
, POH.REVISION_NUM
, POH.TYPE_LOOKUP_CODE
, POH.CURRENCY_CODE
, POL.LINE_NUM
, POL.ITEM_DESCRIPTION
, POL.UNIT_MEAS_LOOKUP_CODE
, PLL.PRICE_OVERRIDE
, PLL.QUANTITY
, PLL.QUANTITY_CANCELLED
, PLL.QUANTITY_RECEIVED
, PLL.QUANTITY_BILLED
, HR.LOCATION_CODE
, POD.QUANTITY_ORDERED
, POD.QUANTITY_CANCELLED
, POH.ORG_ID
FROM PO_VENDORS POV
, PO_DISTRIBUTIONS_ALL POD
, PO_LINE_LOCATIONS_ALL PLL
, PO_LINES_ALL POL
, PO_RELEASES_ALL POR
, PO_HEADERS POH
, HR_LOCATIONS HR
, PER_PEOPLE_F PPF
WHERE NVL(POH.APPROVED_FLAG
, 'N') = 'Y'
AND POH.PO_HEADER_ID = POL.PO_HEADER_ID
AND POH.AGENT_ID = PPF.PERSON_ID
AND POV.VENDOR_ID = POH.VENDOR_ID
AND POH.TYPE_LOOKUP_CODE = 'STANDARD'
AND POL.PO_LINE_ID = PLL.PO_LINE_ID
AND PLL.SHIP_TO_LOCATION_ID = HR.LOCATION_ID
AND PLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID UNION SELECT POH.SEGMENT1
, POR.RELEASE_NUM
, POR.CREATION_DATE
, PPF.FULL_NAME
, POV.VENDOR_NAME
, POR.REVISION_NUM
, 'RELEASE'
, POH.CURRENCY_CODE
, POL.LINE_NUM
, POL.ITEM_DESCRIPTION
, POL.UNIT_MEAS_LOOKUP_CODE
, PLL.PRICE_OVERRIDE
, PLL.QUANTITY
, PLL.QUANTITY_CANCELLED
, PLL.QUANTITY_RECEIVED
, PLL.QUANTITY_BILLED
, HR.LOCATION_CODE
, POD.QUANTITY_ORDERED
, POD.QUANTITY_CANCELLED
, POR.ORG_ID
FROM PER_PEOPLE_F PPF
, PO_VENDORS POV
, HR_LOCATIONS HR
, PO_DISTRIBUTIONS_ALL POD
, PO_LINE_LOCATIONS_ALL PLL
, PO_LINES_ALL POL
, PO_RELEASES POR
, PO_HEADERS_ALL POH
WHERE NVL(POR.APPROVED_FLAG
, 'N') = 'Y'
AND POH.PO_HEADER_ID = POL.PO_HEADER_ID
AND POR.PO_HEADER_ID = POH.PO_HEADER_ID
AND PLL.PO_RELEASE_ID = POR.PO_RELEASE_ID
AND POR.AGENT_ID = PPF.PERSON_ID
AND POV.VENDOR_ID = POH.VENDOR_ID
AND POH.TYPE_LOOKUP_CODE = 'BLANKET'
AND POL.PO_LINE_ID = PLL.PO_LINE_ID
AND PLL.SHIP_TO_LOCATION_ID = HR.LOCATION_ID
AND PLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID

Columns

Name
PO_NO
RELEASE_NO
PO_DATE
BUYER_NAME
VENDOR_NAME
REVISION_NO
PO_TYPE
CURRENCY
LINE_NO
ITEM_DESCRIPTION
UNIT_OF_MEASURE
UNIT_PRICE
QUANTITY
QTY_CANCELLED
QTY_RECEIVED
QTY_BILLED
SHIP_TO_LOCATION
DIST_QTY_ORDERED
DIST_QTY_CANCELLED
ORG_ID