VIEW: APPS.INL_ADJ_CHARGE_LINES_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)