VIEW: APPS.INL_PO_CHARGES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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