View: INL_ADJ_CHARGE_LINES_V

Product:	INL - Oracle Landed Cost Management
Description:	This view shows adjusted information on Charge Lines.
Implementation/DBA Data:	APPS.INL_ADJ_CHARGE_LINES_V

View Text

SELECT CL1.CHARGE_LINE_ID
, CL1.CHARGE_LINE_NUM
, CL1.CHARGE_LINE_TYPE_ID
, CL1.LANDED_COST_FLAG
, CL1.UPDATE_ALLOWED
, CL1.SOURCE_CODE
, CL1.PARENT_CHARGE_LINE_ID
, CL1.ADJUSTMENT_NUM
, CL1.MATCH_ID
, CL1.MATCH_AMOUNT_ID
, CL1.CHARGE_AMT
, CL1.CURRENCY_CODE
, CL1.CURRENCY_CONVERSION_TYPE
, CL1.CURRENCY_CONVERSION_DATE
, CL1.CURRENCY_CONVERSION_RATE
, CL1.PARTY_ID
, CL1.PARTY_SITE_ID
, CL1.TRX_BUSINESS_CATEGORY
, CL1.INTENDED_USE
, CL1.PRODUCT_FISCAL_CLASS
, CL1.PRODUCT_CATEGORY
, CL1.PRODUCT_TYPE
, CL1.USER_DEF_FISCAL_CLASS
, CL1.TAX_CLASSIFICATION_CODE
, CL1.ASSESSABLE_VALUE
, CL1.TAX_ALREADY_CALCULATED_FLAG
, CL1.SHIP_FROM_PARTY_ID
, CL1.SHIP_FROM_PARTY_SITE_ID
, CL1.SHIP_TO_ORGANIZATION_ID
, CL1.SHIP_TO_LOCATION_ID
, CL1.BILL_FROM_PARTY_ID
, CL1.BILL_FROM_PARTY_SITE_ID
, CL1.BILL_TO_ORGANIZATION_ID
, CL1.BILL_TO_LOCATION_ID
, CL1.POA_PARTY_ID
, CL1.POA_PARTY_SITE_ID
, CL1.POO_ORGANIZATION_ID
, CL1.POO_LOCATION_ID
, CL1.NEW_CHARGE_AMT
, CL1.NEW_CURRENCY_CONVERSION_TYPE
, CL1.NEW_CURRENCY_CONVERSION_DATE
, CL1.NEW_CURRENCY_CONVERSION_RATE
, CL1.ADJUSTMENT_TYPE_FLAG
FROM INL_CHARGE_LINES CL1
WHERE NOT EXISTS (SELECT 1
FROM INL_CHARGE_LINES CL2
WHERE CL2.PARENT_CHARGE_LINE_ID = CL1.CHARGE_LINE_ID)

Columns