VIEW: APPS.OKL_CS_TAXSCH_TAX_SUM_UV

Source

View Text - Preformatted

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.CONCAT_CLASSIF_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.PRODUCT_CATEGORY, TAXS.USER_DEFINED_FISC_CLASS, TAXS.LINE_INTENDED_USE, TAXS.TRX_BUSINESS_CATEGORY, TAXS.DEFAULT_TAXATION_COUNTRY 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 WHERE TAXS.KLE_ID = OKCL.ID (+) AND OKCL.LSE_ID = OKLS.ID (+) AND TAXS.STY_ID = STRMT.ID (+) AND TAXS.TAX_LINE_STATUS_CODE = 'ACTIVE' AND TAXS.TAX_CALL_TYPE_CODE = 'TAX_SCHEDULE' AND TAXS.ENTITY_CODE = 'TAX_SCHEDULE_REQUESTS' AND TAXS.APPLICATION_ID = 540 AND TAXS.EVENT_CLASS_CODE = 'TAX_SCHEDULE' AND TAXS.TRX_LEVEL_TYPE = 'LINE' 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(+)

View Text - HTML Formatted

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.CONCAT_CLASSIF_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.PRODUCT_CATEGORY
, TAXS.USER_DEFINED_FISC_CLASS
, TAXS.LINE_INTENDED_USE
, TAXS.TRX_BUSINESS_CATEGORY
, TAXS.DEFAULT_TAXATION_COUNTRY
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
WHERE TAXS.KLE_ID = OKCL.ID (+)
AND OKCL.LSE_ID = OKLS.ID (+)
AND TAXS.STY_ID = STRMT.ID (+)
AND TAXS.TAX_LINE_STATUS_CODE = 'ACTIVE'
AND TAXS.TAX_CALL_TYPE_CODE = 'TAX_SCHEDULE'
AND TAXS.ENTITY_CODE = 'TAX_SCHEDULE_REQUESTS'
AND TAXS.APPLICATION_ID = 540
AND TAXS.EVENT_CLASS_CODE = 'TAX_SCHEDULE'
AND TAXS.TRX_LEVEL_TYPE = 'LINE'
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(+)