View: INL_PO_CHARGE_ALLOCATIONS_V

Product:	INL - Oracle Landed Cost Management
Description:	This view shows INL charge allocations in the View Acquisition Costs page
Implementation/DBA Data:	APPS.INL_PO_CHARGE_ALLOCATIONS_V

View Text

SELECT IAL.ALLOCATION_ID CHARGE_ALLOCATION_ID
, ICL.CHARGE_LINE_ID CHARGE_ID
, RSL.SHIPMENT_LINE_ID SHIPMENT_LINE_ID
, IAL.CREATION_DATE CREATION_DATE
, IAL.CREATED_BY CREATED_BY
, IAL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IAL.LAST_UPDATED_BY LAST_UPDATED_BY
, IAL.ALLOCATION_AMT ESTIMATED_AMOUNT
, (INL_SHIPMENT_PVT.GET_MATCHEDAMT(IAL.SHIP_HEADER_ID
, RSL.LCM_SHIPMENT_LINE_ID
, ICL.CHARGE_LINE_TYPE_ID
, NULL
, 'INL_CHARGE_LINES'
, 'N')) ACTUAL_AMOUNT
, PLL.PRICE_OVERRIDE ORIGINAL_UNIT_PRICE
, 0 ORIGINAL_UNIT_NR_TAX
, 0 EST_RECOVERABLE_TAX
, 0 EST_NON_RECOVERABLE_TAX
, 0 ACT_RECOVERABLE_TAX
, (INL_SHIPMENT_PVT.GET_MATCHEDAMT(IAL.SHIP_HEADER_ID
, RSL.LCM_SHIPMENT_LINE_ID
, ICL.CHARGE_LINE_TYPE_ID
, NULL
, 'INL_TAX_LINES'
, 'N')) ACT_NON_RECOVERABLE_TAX
FROM INL_ALLOCATIONS IAL
, INL_CHARGE_LINES ICL
, PO_LINE_LOCATIONS_ALL PLL
, RCV_SHIPMENT_LINES RSL
WHERE IAL.FROM_PARENT_TABLE_NAME = 'INL_CHARGE_LINES'
AND IAL.FROM_PARENT_TABLE_ID = ICL.CHARGE_LINE_ID
AND IAL.SHIP_LINE_ID = RSL.LCM_SHIPMENT_LINE_ID
AND IAL.LANDED_COST_FLAG = 'Y'
AND IAL.ADJUSTMENT_NUM = 0
AND RSL.PO_LINE_LOCATION_ID = PLL.LINE_LOCATION_ID UNION ALL SELECT CHARGE_ALLOCATION_ID CHARGE_ALLOCATION_ID
, CHARGE_ID CHARGE_ID
, SHIPMENT_LINE_ID SHIPMENT_LINE_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, ACTUAL_AMOUNT ACTUAL_AMOUNT
, ORIGINAL_UNIT_PRICE ORIGINAL_UNIT_PRICE
, ORIGINAL_UNIT_NR_TAX ORIGINAL_UNIT_NR_TAX
, EST_RECOVERABLE_TAX EST_RECOVERABLE_TAX
, EST_NON_RECOVERABLE_TAX EST_NON_RECOVERABLE_TAX
, ACT_RECOVERABLE_TAX ACT_RECOVERABLE_TAX
, ACT_NON_RECOVERABLE_TAX ACT_NON_RECOVERABLE_TAX
FROM PO_RCV_CHARGE_ALLOCATIONS

Columns