View: INL_ADJ_TAX_LINES_V

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

View Text

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 CONNECT_BY_ISLEAF = 1 START WITH PARENT_TAX_LINE_ID IS NULL CONNECT BY PRIOR TAX_LINE_ID = PARENT_TAX_LINE_ID

Columns