Product: | INL - Oracle Landed Cost Management |
---|---|
Description: | This view shows adjusted information on Tax Lines. |
Implementation/DBA Data: | APPS.INL_ADJ_TAX_LINES_V |
SELECT TL1.TAX_LINE_ID
, TL1.TAX_LINE_NUM
, TL1.TAX_CODE
, TL1.SHIP_HEADER_ID
, TL1.PARENT_TAX_LINE_ID
, TL1.ADJUSTMENT_NUM
, TL1.MATCH_ID
, TL1.MATCH_AMOUNT_ID
, TL1.SOURCE_PARENT_TABLE_NAME
, TL1.SOURCE_PARENT_TABLE_ID
, TL1.TAX_AMT
, TL1.NREC_TAX_AMT
, TL1.CURRENCY_CODE
, TL1.CURRENCY_CONVERSION_TYPE
, TL1.CURRENCY_CONVERSION_DATE
, TL1.CURRENCY_CONVERSION_RATE
, TL1.TAX_AMT_INCLUDED_FLAG
, TL1.CREATED_BY
, TL1.CREATION_DATE
, TL1.LAST_UPDATED_BY
, TL1.LAST_UPDATE_DATE
, TL1.LAST_UPDATE_LOGIN
FROM INL_TAX_LINES TL1
WHERE NOT EXISTS (SELECT 1
FROM INL_TAX_LINES TL2
WHERE TL2.PARENT_TAX_LINE_ID = TL1.TAX_LINE_ID)