[Home] [Help]
View: PO_AP_RETROACTIVE_DIST_V
Product: | PO - Purchasing |
Description: | PO_AP_RETROACTIVE_DIST_V view captures the distributions to be invoice adjusted.. |
Implementation/DBA Data: |
APPS.PO_AP_RETROACTIVE_DIST_V
|
View Text
SELECT DECODE ( POLL.SHIPMENT_TYPE
, 'BLANKET'
, POD.PO_HEADER_ID
, NVL (POL.FROM_HEADER_ID
, POD.PO_HEADER_ID) ) PO_HEADER_ID
, POD.PO_LINE_ID
, POD.LINE_LOCATION_ID
, POD.PO_DISTRIBUTION_ID
, POH.VENDOR_ID
, POD.INVOICE_ADJUSTMENT_FLAG
, POL.UNIT_PRICE
, POLL.PRICE_OVERRIDE
, POLL.RETROACTIVE_DATE
, POD.ORG_ID
FROM PO_HEADERS_ALL POH
, PO_LINES_ALL POL
, PO_LINE_LOCATIONS_ALL POLL
, PO_DISTRIBUTIONS POD
WHERE POH.PO_HEADER_ID = POL.PO_HEADER_ID
AND POL.PO_LINE_ID = POLL.PO_LINE_ID
AND POLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID
AND POD.INVOICE_ADJUSTMENT_FLAG IN ('R'
, 'E')
Columns
Name |
PO_HEADER_ID |
PO_LINE_ID |
LINE_LOCATION_ID |
PO_DISTRIBUTION_ID |
VENDOR_ID |
INVOICE_ADJUSTMENT_FLAG |
UNIT_PRICE |
PRICE_OVERRIDE |
RETROACTIVE_DATE |
ORG_ID |