eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.JL_ZZ_AR_TX_CATEGRY_V

Source

View Text - Preformatted


SELECT tax.rowid , tax.tax_category_id , tax.tax_category , substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tax.tax_category, 'JLZZ_AR_TX_CATEGRY'),1,80), tax.end_date_active , tax.last_update_date , tax.last_updated_by , tax.threshold_check_level , substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tax.threshold_check_level, 'JLZZ_AR_TX_THRESH_CHECK_, LEVEL'),1,80), decode(tax.threshold_check_grp_by, 'LINE', 'LINE', 'DOCUMENT','DOCUMENT', 'TRANSACTION') threshold_check_grp_by_nb , substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(decode(tax.threshold_check_grp_by, 'LINE','LINE', 'DOCUMENT','DOCUMENT','TRANSACTION'),'JLZZ_AR_TX_THRESH_GRP_BY'),1,80), tax.threshold_check_grp_by , substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tax.threshold_check_grp_by, 'TRANSACTION_ATTRIBUTE'),1,80), tax.min_amount , tax.min_taxable_basis , tax.min_percentage , tax.tax_inclusive , tax.org_tax_attribute , substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tax.org_tax_attribute, 'ORGANIZATION_ATTRIBUTE'),1,80), tax.cus_tax_attribute , substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tax.cus_tax_attribute, 'CONTRIBUTOR_ATTRIBUTE'),1,80), tax.txn_tax_attribute , substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tax.txn_tax_attribute, 'TRANSACTION_ATTRIBUTE'),1,80), tax.tributary_substitution , tax.used_to_reduce , tax.tax_categ_to_reduce_id , cat.tax_category tax_categ_to_reduce_desc , tax.mandatory_in_class , tax.tax_code , art.description , art.tax_rate , tax.tax_authority_code , substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tax.tax_authority_code, 'JLAR_AP_DGI_TAX_TYPE'),1,80), tax.print_flag , tax.tax_rule_set , tax.start_date_active , tax.org_id, tax.tax_regime, substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tax.tax_regime, 'JLZZ_AR_TAX_REGIME'),1,80), tax.last_update_login , tax.creation_date , tax.created_by , tax.attribute_category , tax.attribute1 , tax.attribute2 , tax.attribute3 , tax.attribute4 , tax.attribute5 , tax.attribute6 , tax.attribute7 , tax.attribute8 , tax.attribute9 , tax.attribute10 , tax.attribute11 , tax.attribute12 , tax.attribute13 , tax.attribute14 , tax.attribute15 FROM jl_zz_ar_tx_categ tax , jl_zz_ar_tx_categ_all cat , ar_vat_tax_all_b art , ar_system_parameters_all sys WHERE tax.tax_categ_to_reduce_id = cat.tax_category_id (+) and tax.tax_code is not null AND tax.tax_code = art.tax_code AND NVL(art.tax_type, 'VAT') = 'VAT' AND NVL(art.tax_class, 'O') = 'O' AND NVL(art.enabled_flag, 'Y') = 'Y' AND tax.tax_category_id = decode(ltrim(art.global_attribute1,'0123456789 '), null, to_number(art.global_attribute1), null) AND tax.start_date_active <= NVL(art.end_date, to_date('4712/12/31', 'YYYY/MM/DD')) AND tax.end_date_active >= art.start_date AND art.set_of_books_id = sys.set_of_books_id /*AND NVL(tax.org_id,-99) = NVL(cat.org_id,-99)*/ AND NVL(tax.org_id,-99) = NVL(art.org_id,-99) AND NVL(tax.org_id,-99) = NVL(sys.org_id,-99) AND NOT EXISTS(select 1 from ar_vat_tax art1 where art1.tax_code = art.tax_code AND art1.set_of_books_id = art.set_of_books_id AND NVL(art1.tax_type, 'VAT') = 'VAT' AND NVL(art1.tax_class, 'O') = 'O' AND NVL(art1.enabled_flag, 'Y') = 'Y' AND art1.global_attribute1 = art.global_attribute1 AND art1.start_date > art.start_date AND art1.start_date <= tax.end_date_active) AND NVL(CAT.TAX_RULE_SET, SYS.GLOBAL_ATTRIBUTE13) = SYS.GLOBAL_ATTRIBUTE13 AND tax.tax_rule_set = SYS.GLOBAL_ATTRIBUTE13 UNION SELECT tax.rowid , tax.tax_category_id , tax.tax_category , substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tax.tax_category, 'JLZZ_AR_TX_CATEGRY'),1,80), tax.end_date_active , tax.last_update_date , tax.last_updated_by , tax.threshold_check_level , substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tax.threshold_check_level, 'JLZZ_AR_TX_THRESH_CHECK_LEVEL'),1,80), decode(tax.threshold_check_grp_by, 'LINE', 'LINE', 'DOCUMENT','DOCUMENT', 'TRANSACTION') threshold_check_grp_by_nb , substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(decode(tax.threshold_check_grp_by, 'LINE','LINE', 'DOCUMENT','DOCUMENT','TRANSACTION'),'JLZZ_AR_TX_THRESH_GRP_BY'),1,80), tax.threshold_check_grp_by , substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tax.threshold_check_grp_by, 'TRANSACTION_ATTRIBUTE'),1,80), tax.min_amount , tax.min_taxable_basis , tax.min_percentage , tax.tax_inclusive , tax.org_tax_attribute , substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tax.org_tax_attribute, 'ORGANIZATION_ATTRIBUTE'),1,80), tax.cus_tax_attribute , substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tax.cus_tax_attribute, 'CONTRIBUTOR_ATTRIBUTE'),1,80), tax.txn_tax_attribute , substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tax.txn_tax_attribute, 'TRANSACTION_ATTRIBUTE'),1,80), tax.tributary_substitution , tax.used_to_reduce , tax.tax_categ_to_reduce_id , cat.tax_category , tax.mandatory_in_class , tax.tax_code , to_char(null) description , to_number(null) tax_rate , tax.tax_authority_code , substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tax.tax_authority_code, 'JLAR_AP_DGI_TAX_TYPE'),1,80), tax.print_flag , tax.tax_rule_set , tax.start_date_active , tax.org_id, tax.tax_regime, substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tax.tax_regime, 'JLZZ_AR_TAX_REGIME'),1,80), tax.last_update_login , tax.creation_date , tax.created_by , tax.attribute_category , tax.attribute1 , tax.attribute2 , tax.attribute3 , tax.attribute4 , tax.attribute5 , tax.attribute6 , tax.attribute7 , tax.attribute8 , tax.attribute9 , tax.attribute10 , tax.attribute11 , tax.attribute12 , tax.attribute13 , tax.attribute14 , tax.attribute15 FROM jl_zz_ar_tx_categ tax , jl_zz_ar_tx_categ_all cat , ar_system_parameters_all sys WHERE tax.tax_categ_to_reduce_id = cat.tax_category_id(+) AND tax.tax_code is null AND NVL(CAT.TAX_RULE_SET, SYS.GLOBAL_ATTRIBUTE13) = SYS.GLOBAL_ATTRIBUTE13 AND TAX.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13 /*AND NVL(tax.org_id,-99) = NVL(cat.org_id,-99)*/ AND NVL(tax.org_id,-99) = NVL(sys.org_id,-99)

View Text - HTML Formatted

SELECT TAX.ROWID
, TAX.TAX_CATEGORY_ID
, TAX.TAX_CATEGORY
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.TAX_CATEGORY
, 'JLZZ_AR_TX_CATEGRY')
, 1
, 80)
, TAX.END_DATE_ACTIVE
, TAX.LAST_UPDATE_DATE
, TAX.LAST_UPDATED_BY
, TAX.THRESHOLD_CHECK_LEVEL
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.THRESHOLD_CHECK_LEVEL
, 'JLZZ_AR_TX_THRESH_CHECK_
, LEVEL')
, 1
, 80)
, DECODE(TAX.THRESHOLD_CHECK_GRP_BY
, 'LINE'
, 'LINE'
, 'DOCUMENT'
, 'DOCUMENT'
, 'TRANSACTION') THRESHOLD_CHECK_GRP_BY_NB
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(DECODE(TAX.THRESHOLD_CHECK_GRP_BY
, 'LINE'
, 'LINE'
, 'DOCUMENT'
, 'DOCUMENT'
, 'TRANSACTION')
, 'JLZZ_AR_TX_THRESH_GRP_BY')
, 1
, 80)
, TAX.THRESHOLD_CHECK_GRP_BY
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.THRESHOLD_CHECK_GRP_BY
, 'TRANSACTION_ATTRIBUTE')
, 1
, 80)
, TAX.MIN_AMOUNT
, TAX.MIN_TAXABLE_BASIS
, TAX.MIN_PERCENTAGE
, TAX.TAX_INCLUSIVE
, TAX.ORG_TAX_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.ORG_TAX_ATTRIBUTE
, 'ORGANIZATION_ATTRIBUTE')
, 1
, 80)
, TAX.CUS_TAX_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.CUS_TAX_ATTRIBUTE
, 'CONTRIBUTOR_ATTRIBUTE')
, 1
, 80)
, TAX.TXN_TAX_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.TXN_TAX_ATTRIBUTE
, 'TRANSACTION_ATTRIBUTE')
, 1
, 80)
, TAX.TRIBUTARY_SUBSTITUTION
, TAX.USED_TO_REDUCE
, TAX.TAX_CATEG_TO_REDUCE_ID
, CAT.TAX_CATEGORY TAX_CATEG_TO_REDUCE_DESC
, TAX.MANDATORY_IN_CLASS
, TAX.TAX_CODE
, ART.DESCRIPTION
, ART.TAX_RATE
, TAX.TAX_AUTHORITY_CODE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.TAX_AUTHORITY_CODE
, 'JLAR_AP_DGI_TAX_TYPE')
, 1
, 80)
, TAX.PRINT_FLAG
, TAX.TAX_RULE_SET
, TAX.START_DATE_ACTIVE
, TAX.ORG_ID
, TAX.TAX_REGIME
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.TAX_REGIME
, 'JLZZ_AR_TAX_REGIME')
, 1
, 80)
, TAX.LAST_UPDATE_LOGIN
, TAX.CREATION_DATE
, TAX.CREATED_BY
, TAX.ATTRIBUTE_CATEGORY
, TAX.ATTRIBUTE1
, TAX.ATTRIBUTE2
, TAX.ATTRIBUTE3
, TAX.ATTRIBUTE4
, TAX.ATTRIBUTE5
, TAX.ATTRIBUTE6
, TAX.ATTRIBUTE7
, TAX.ATTRIBUTE8
, TAX.ATTRIBUTE9
, TAX.ATTRIBUTE10
, TAX.ATTRIBUTE11
, TAX.ATTRIBUTE12
, TAX.ATTRIBUTE13
, TAX.ATTRIBUTE14
, TAX.ATTRIBUTE15
FROM JL_ZZ_AR_TX_CATEG TAX
, JL_ZZ_AR_TX_CATEG_ALL CAT
, AR_VAT_TAX_ALL_B ART
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE TAX.TAX_CATEG_TO_REDUCE_ID = CAT.TAX_CATEGORY_ID (+)
AND TAX.TAX_CODE IS NOT NULL
AND TAX.TAX_CODE = ART.TAX_CODE
AND NVL(ART.TAX_TYPE
, 'VAT') = 'VAT'
AND NVL(ART.TAX_CLASS
, 'O') = 'O'
AND NVL(ART.ENABLED_FLAG
, 'Y') = 'Y'
AND TAX.TAX_CATEGORY_ID = DECODE(LTRIM(ART.GLOBAL_ATTRIBUTE1
, '0123456789 ')
, NULL
, TO_NUMBER(ART.GLOBAL_ATTRIBUTE1)
, NULL)
AND TAX.START_DATE_ACTIVE <= NVL(ART.END_DATE
, TO_DATE('4712/12/31'
, 'YYYY/MM/DD'))
AND TAX.END_DATE_ACTIVE >= ART.START_DATE
AND ART.SET_OF_BOOKS_ID = SYS.SET_OF_BOOKS_ID /*AND NVL(TAX.ORG_ID
, -99) = NVL(CAT.ORG_ID
, -99)*/
AND NVL(TAX.ORG_ID
, -99) = NVL(ART.ORG_ID
, -99)
AND NVL(TAX.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)
AND NOT EXISTS(SELECT 1
FROM AR_VAT_TAX ART1
WHERE ART1.TAX_CODE = ART.TAX_CODE
AND ART1.SET_OF_BOOKS_ID = ART.SET_OF_BOOKS_ID
AND NVL(ART1.TAX_TYPE
, 'VAT') = 'VAT'
AND NVL(ART1.TAX_CLASS
, 'O') = 'O'
AND NVL(ART1.ENABLED_FLAG
, 'Y') = 'Y'
AND ART1.GLOBAL_ATTRIBUTE1 = ART.GLOBAL_ATTRIBUTE1
AND ART1.START_DATE > ART.START_DATE
AND ART1.START_DATE <= TAX.END_DATE_ACTIVE)
AND NVL(CAT.TAX_RULE_SET
, SYS.GLOBAL_ATTRIBUTE13) = SYS.GLOBAL_ATTRIBUTE13
AND TAX.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13 UNION SELECT TAX.ROWID
, TAX.TAX_CATEGORY_ID
, TAX.TAX_CATEGORY
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.TAX_CATEGORY
, 'JLZZ_AR_TX_CATEGRY')
, 1
, 80)
, TAX.END_DATE_ACTIVE
, TAX.LAST_UPDATE_DATE
, TAX.LAST_UPDATED_BY
, TAX.THRESHOLD_CHECK_LEVEL
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.THRESHOLD_CHECK_LEVEL
, 'JLZZ_AR_TX_THRESH_CHECK_LEVEL')
, 1
, 80)
, DECODE(TAX.THRESHOLD_CHECK_GRP_BY
, 'LINE'
, 'LINE'
, 'DOCUMENT'
, 'DOCUMENT'
, 'TRANSACTION') THRESHOLD_CHECK_GRP_BY_NB
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(DECODE(TAX.THRESHOLD_CHECK_GRP_BY
, 'LINE'
, 'LINE'
, 'DOCUMENT'
, 'DOCUMENT'
, 'TRANSACTION')
, 'JLZZ_AR_TX_THRESH_GRP_BY')
, 1
, 80)
, TAX.THRESHOLD_CHECK_GRP_BY
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.THRESHOLD_CHECK_GRP_BY
, 'TRANSACTION_ATTRIBUTE')
, 1
, 80)
, TAX.MIN_AMOUNT
, TAX.MIN_TAXABLE_BASIS
, TAX.MIN_PERCENTAGE
, TAX.TAX_INCLUSIVE
, TAX.ORG_TAX_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.ORG_TAX_ATTRIBUTE
, 'ORGANIZATION_ATTRIBUTE')
, 1
, 80)
, TAX.CUS_TAX_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.CUS_TAX_ATTRIBUTE
, 'CONTRIBUTOR_ATTRIBUTE')
, 1
, 80)
, TAX.TXN_TAX_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.TXN_TAX_ATTRIBUTE
, 'TRANSACTION_ATTRIBUTE')
, 1
, 80)
, TAX.TRIBUTARY_SUBSTITUTION
, TAX.USED_TO_REDUCE
, TAX.TAX_CATEG_TO_REDUCE_ID
, CAT.TAX_CATEGORY
, TAX.MANDATORY_IN_CLASS
, TAX.TAX_CODE
, TO_CHAR(NULL) DESCRIPTION
, TO_NUMBER(NULL) TAX_RATE
, TAX.TAX_AUTHORITY_CODE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.TAX_AUTHORITY_CODE
, 'JLAR_AP_DGI_TAX_TYPE')
, 1
, 80)
, TAX.PRINT_FLAG
, TAX.TAX_RULE_SET
, TAX.START_DATE_ACTIVE
, TAX.ORG_ID
, TAX.TAX_REGIME
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.TAX_REGIME
, 'JLZZ_AR_TAX_REGIME')
, 1
, 80)
, TAX.LAST_UPDATE_LOGIN
, TAX.CREATION_DATE
, TAX.CREATED_BY
, TAX.ATTRIBUTE_CATEGORY
, TAX.ATTRIBUTE1
, TAX.ATTRIBUTE2
, TAX.ATTRIBUTE3
, TAX.ATTRIBUTE4
, TAX.ATTRIBUTE5
, TAX.ATTRIBUTE6
, TAX.ATTRIBUTE7
, TAX.ATTRIBUTE8
, TAX.ATTRIBUTE9
, TAX.ATTRIBUTE10
, TAX.ATTRIBUTE11
, TAX.ATTRIBUTE12
, TAX.ATTRIBUTE13
, TAX.ATTRIBUTE14
, TAX.ATTRIBUTE15
FROM JL_ZZ_AR_TX_CATEG TAX
, JL_ZZ_AR_TX_CATEG_ALL CAT
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE TAX.TAX_CATEG_TO_REDUCE_ID = CAT.TAX_CATEGORY_ID(+)
AND TAX.TAX_CODE IS NULL
AND NVL(CAT.TAX_RULE_SET
, SYS.GLOBAL_ATTRIBUTE13) = SYS.GLOBAL_ATTRIBUTE13
AND TAX.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13 /*AND NVL(TAX.ORG_ID
, -99) = NVL(CAT.ORG_ID
, -99)*/
AND NVL(TAX.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)