View: OKL_CS_ASTLOC_TAX_SUM_UV

Product:	OKL - Lease and Finance Management
Description:	This view displays Asset Location Change Transaction Tax Summary
Implementation/DBA Data:	APPS.OKL_CS_ASTLOC_TAX_SUM_UV

View Text

SELECT HZ.ACCOUNT_NAME ||'(' || HZ.ACCOUNT_NUMBER ||')' BILL_TO_CUSTOMER
, LNTYP.MEANING LINE_TYPE
, TAXS.LINE_NAME
, STY.MEANING STREAM_TYPE
, OKL_LLA_UTIL_PVT.GET_ASSET_LOCATION(TAXS.KLE_ID
, TAXS.KHR_ID) ASSET_LOCATION
, TAXS.TRX_DATE TAX_DATE
, TAXS.ASSESSABLE_VALUE TAX_AMOUNT
, TAXS.TOTAL_TAX
, TBC.CLASSIFICATION_NAME TRX_BUSINESS_CATEGORY
, PC.CLASSIFICATION_NAME PRODUCT_CATEGORY
, UFC.CLASSIFICATION_NAME USER_DEFINED_FISC_CLASS
, IU.CLASSIFICATION_NAME LINE_INTENDED_USE
, TAXS.KLE_ID
, TAXS.KHR_ID
, TAXS.TRX_ID
, TAXS.TRX_LINE_ID
, TAXS.ENTITY_CODE
, TAXS.EVENT_CLASS_CODE
, TAXS.APPLICATION_ID
, TAXS.TRX_LEVEL_TYPE
, TAXS.TAX_CALL_TYPE_CODE
, TAXS.TAX_LINE_STATUS_CODE
, TAXS.TRY_ID
, TAXS.TRX_CURRENCY_CODE
, TAXS.LEGAL_ENTITY_ID
, TAXS.ORG_ID
, TAXS.ID
, TAXS.PRODUCT_CATEGORY
, TAXS.USER_DEFINED_FISC_CLASS
, TAXS.LINE_INTENDED_USE
, TAXS.TRX_BUSINESS_CATEGORY
, TAXS.DEFAULT_TAXATION_COUNTRY
, TAXS.TRX_DATE
, TRA.REQ_ASSET_ID
FROM OKL_TAX_SOURCES TAXS
, OKC_K_LINES_B OKCL
, OKC_LINE_STYLES_B OKLS
, OKL_STRM_TYPE_B STRMT
, HZ_CUST_ACCOUNTS HZ
, FND_LOOKUPS LNTYP
, FND_LOOKUPS STY
, ZX_FC_CODES_DENORM_B TBC
, ZX_FC_PRODUCT_CATEGORIES_V PC
, ZX_FC_USER_DEFINED_V UFC
, ZX_FC_INTENDED_USE_V IU
, OKL_TRX_ASSETS TRA
WHERE TAXS.KLE_ID = OKCL.ID (+)
AND OKCL.LSE_ID = OKLS.ID (+)
AND TAXS.STY_ID = STRMT.ID (+)
AND TAXS.TAX_CALL_TYPE_CODE = 'UPFRONT_TAX'
AND TAXS.ENTITY_CODE = 'ASSETS'
AND TAXS.EVENT_CLASS_CODE = 'ASSET_RELOCATION'
AND TAXS.TRX_LEVEL_TYPE = 'LINE'
AND TAXS.APPLICATION_ID = 540
AND HZ.CUST_ACCOUNT_ID = TAXS.BILL_TO_CUST_ACCT_ID
AND LNTYP.LOOKUP_TYPE(+) = 'OKC_LINE_TYPE'
AND LNTYP.LOOKUP_CODE(+) = OKLS.LTY_CODE
AND STY.LOOKUP_TYPE(+) = 'OKL_STREAM_TYPE_PURPOSE'
AND STY.LOOKUP_CODE(+) = STRMT.STREAM_TYPE_PURPOSE
AND TAXS.TRX_BUSINESS_CATEGORY = TBC.CONCAT_CLASSIF_CODE(+)
AND TBC.CLASSIFICATION_TYPE_CODE(+) = 'TRX_BUSINESS_CATEGORY'
AND TBC.LANGUAGE (+) = USERENV('LANG')
AND TAXS.PRODUCT_CATEGORY = PC.CLASSIFICATION_CODE(+)
AND TAXS.USER_DEFINED_FISC_CLASS = UFC.CLASSIFICATION_CODE(+)
AND TAXS.LINE_INTENDED_USE = IU.CLASSIFICATION_CODE(+)
AND TRA.ID(+) = TAXS.TRX_ID

Columns