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.

APPS.ZX_JL_EXTRACT_PKG dependencies on JL_ZZ_AR_TX_CATEG_ALL

Line 567: FROM jl_zz_ar_tx_categ_all catg,

563: /* DELETE from ZX_REP_TRX_DETAIL_T DET
564: WHERE DET.REQUEST_ID = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID and
565: NOT EXISTS
566: (SELECT 1
567: FROM jl_zz_ar_tx_categ_all catg,
568: jl_zz_ar_tx_att_cls_all attcls,
569: jl_zz_ar_tx_att_val_all val
570: WHERE attcls.tax_attribute_value = val.tax_attribute_value
571: AND attcls.tax_category_id = val.tax_category_id

Line 8069: JL_ZZ_AR_TX_CATEG_ALL categ,

8065:
8066: SELECT VAL.TAX_ATTR_VALUE_CODE
8067: INTO l_cust_condition_code_tbl(p_trx_id_tbl(i))
8068: FROM JL_ZZ_AR_TX_CUS_CLS_ALL cust,
8069: JL_ZZ_AR_TX_CATEG_ALL categ,
8070: JL_ZZ_AR_TX_ATT_VAL_ALL val
8071: WHERE CUST.TAX_ATTRIBUTE_VALUE = VAL.TAX_ATTRIBUTE_VALUE and
8072: CUST.TAX_CATEGORY_ID = VAL.TAX_CATEGORY_ID and
8073: CUST.TAX_CATEGORY_ID = CATEG.TAX_CATEGORY_ID and

Line 8093: JL_ZZ_AR_TX_CATEG_ALL categ,

8089:
8090: SELECT VAL.TAX_ATTR_VALUE_CODE
8091: INTO l_cust_condition_code_tbl(p_trx_id_tbl(i))
8092: FROM JL_ZZ_AR_TX_ATT_CLS_ALL cust,
8093: JL_ZZ_AR_TX_CATEG_ALL categ,
8094: JL_ZZ_AR_TX_ATT_VAL val
8095: WHERE CUST.TAX_ATTRIBUTE_VALUE = VAL.TAX_ATTRIBUTE_VALUE and
8096: CUST.TAX_CATEGORY_ID = VAL.TAX_CATEGORY_ID and
8097: CUST.TAX_CATEGORY_ID = CATEG.TAX_CATEGORY_ID and

Line 8212: jl_zz_ar_tx_categ_all catg,

8208: BEGIN
8209: SELECT val.tax_attr_value_code
8210: INTO l_dgi_tax_regime_code_tbl(k)
8211: FROM zx_lines lines,
8212: jl_zz_ar_tx_categ_all catg,
8213: jl_zz_ar_tx_att_cls_all attcls,
8214: jl_zz_ar_tx_att_val_all val
8215: WHERE catg.tax_category = P_VAT_PERCEP_TAX
8216: ANd catg.tax_category = lines.tax

Line 8385: jl_zz_ar_tx_categ_all catg,

8381:
8382: SELECT lkp.meaning
8383: INTO l_vat_reg_stat_code_tbl(p_trx_id_tbl(i))
8384: FROM jl_zz_ar_tx_cus_cls_all cls,
8385: jl_zz_ar_tx_categ_all catg,
8386: fnd_lookups lkp
8387: WHERE cls.tax_attr_class_code = l_class_code
8388: AND cls.tax_attribute_name = 'VAT CONT STATUS'
8389: AND cls.tax_category_id = catg.tax_category_id

Line 8403: jl_zz_ar_tx_categ_all catg,

8399:
8400: SELECT lkp.meaning
8401: INTO l_vat_reg_stat_code_tbl(p_trx_id_tbl(i))
8402: FROM jl_zz_ar_tx_att_cls_all cls,
8403: jl_zz_ar_tx_categ_all catg,
8404: fnd_lookups lkp
8405: WHERE cls.tax_attr_class_type = 'CONTRIBUTOR_CLASS'
8406: AND cls.tax_attr_class_code = l_class_code
8407: AND cls.tax_attribute_name = 'VAT CONT STATUS'