View: INL_PO_CHARGES_V

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

View Text

SELECT ICL.CHARGE_LINE_ID CHARGE_ID
, RSL.SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID
, DECODE(IAS.TO_PARENT_TABLE_NAME
, 'INL_SHIP_LINE_GROUPS'
, TO_NUMBER(NULL)
, 'INL_SHIP_HEADERS'
, TO_NUMBER(NULL)
, RSL.SHIPMENT_LINE_ID) SHIPMENT_LINE_ID
, NULL INTERFACE_CHARGE_ID
, ICL.CREATION_DATE CREATION_DATE
, ICL.CREATED_BY CREATED_BY
, ICL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ICL.LAST_UPDATED_BY LAST_UPDATED_BY
, ICL.CHARGE_LINE_TYPE_ID COST_FACTOR_ID
, ICL.CURRENCY_CODE CURRENCY_CODE
, ICL.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, ICL.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, ICL.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, IAS.ALLOCATION_BASIS ALLOCATION_METHOD
, IAS.ALLOCATION_UOM_CODE UNIT_OF_MEASURE
, SUM(IAL.ALLOCATION_AMT) ESTIMATED_AMT
, SUM((INL_SHIPMENT_PVT.GET_MATCHEDAMT(IAS.SHIP_HEADER_ID
, RSL.LCM_SHIPMENT_LINE_ID
, ICL.CHARGE_LINE_TYPE_ID
, NULL
, 'INL_CHARGE_LINES'
, 'N'))) ACTUAL_AMOUNT
, ICL.LANDED_COST_FLAG INCLUDE_IN_ACQUISITION_COST
, PH.VENDOR_ID VENDOR_ID
, PH.VENDOR_SITE_ID VENDOR_SITE_ID
, 0 ESTIMATED_TAX
, 0 ACTUAL_TAX
, PCF.COST_COMPONENT_CLASS_ID COST_COMPONENT_CLASS_ID
, PCF.COST_ANALYSIS_CODE COST_ANALYSIS_CODE
FROM INL_CHARGE_LINES ICL
, INL_ASSOCIATIONS IAS
, INL_ALLOCATIONS IAL
, RCV_SHIPMENT_LINES RSL
, PON_COST_FACTORS_VL PCF
, PO_HEADERS_ALL PH
WHERE ICL.CHARGE_LINE_TYPE_ID = PCF.PRICE_ELEMENT_TYPE_ID
AND IAS.FROM_PARENT_TABLE_NAME = 'INL_CHARGE_LINES'
AND IAS.FROM_PARENT_TABLE_ID = ICL.CHARGE_LINE_ID
AND PH.PO_HEADER_ID = RSL.PO_HEADER_ID
AND RSL.LCM_SHIPMENT_LINE_ID = IAL.SHIP_LINE_ID
AND IAL.FROM_PARENT_TABLE_NAME = IAS.FROM_PARENT_TABLE_NAME
AND IAL.FROM_PARENT_TABLE_ID = IAS.FROM_PARENT_TABLE_ID
AND IAL.SHIP_LINE_ID = RSL.LCM_SHIPMENT_LINE_ID
AND IAL.LANDED_COST_FLAG = 'Y'
AND IAL.ADJUSTMENT_NUM = 0 GROUP BY ICL.CHARGE_LINE_ID
, RSL.SHIPMENT_HEADER_ID
, DECODE(IAS.TO_PARENT_TABLE_NAME
, 'INL_SHIP_LINE_GROUPS'
, TO_NUMBER(NULL)
, 'INL_SHIP_HEADERS'
, TO_NUMBER(NULL)
, RSL.SHIPMENT_LINE_ID)
, ICL.CREATION_DATE
, ICL.CREATED_BY
, ICL.LAST_UPDATE_DATE
, ICL.LAST_UPDATED_BY
, ICL.CHARGE_LINE_TYPE_ID
, ICL.CURRENCY_CODE
, ICL.CURRENCY_CONVERSION_TYPE
, ICL.CURRENCY_CONVERSION_RATE
, ICL.CURRENCY_CONVERSION_DATE
, IAS.ALLOCATION_BASIS
, IAS.ALLOCATION_UOM_CODE
, IAS.SHIP_HEADER_ID
, ICL.CHARGE_LINE_TYPE_ID
, ICL.LANDED_COST_FLAG
, PH.VENDOR_ID
, PH.VENDOR_SITE_ID
, PCF.COST_COMPONENT_CLASS_ID
, PCF.COST_ANALYSIS_CODE UNION ALL SELECT CHARGE_ID CHARGE_ID
, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID SHIPMENT_LINE_ID
, INTERFACE_CHARGE_ID INTERFACE_CHARGE_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, COST_FACTOR_ID COST_FACTOR_ID
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, ALLOCATION_METHOD ALLOCATION_METHOD
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, ESTIMATED_AMOUNT ESTIMATED_AMT
, ACTUAL_AMOUNT ACTUAL_AMOUNT
, INCLUDE_IN_ACQUISITION_COST INCLUDE_IN_ACQUISITION_COST
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, ESTIMATED_TAX ESTIMATED_TAX
, ACTUAL_TAX ACTUAL_TAX
, COST_COMPONENT_CLASS_ID COST_COMPONENT_CLASS_ID
, COST_ANALYSIS_CODE COST_ANALYSIS_CODE
FROM PO_RCV_CHARGES

Columns