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

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 3096: jl_zz_ar_tx_categ categ

3092: l_tax_rate_id_tbl,
3093: l_tax_regime_code_tbl,
3094: l_document_sub_type_tbl
3095: FROM zx_rep_trx_detail_t itf1,
3096: jl_zz_ar_tx_categ categ
3097: WHERE itf1.request_id = P_REQUEST_ID
3098: -- AND itf1.tax_regime_code
3099: AND itf1.tax = categ.tax_category
3100: AND categ.tax_regime in (P_PROV_TAX_REGIME,

Line 3576: FROM JL_ZZ_AR_TX_CATEGRY jtc

3572:
3573: BEGIN
3574: SELECT jtc.description
3575: INTO l_tax_catg_desc
3576: FROM JL_ZZ_AR_TX_CATEGRY jtc
3577: WHERE jtc.tax_category = P_TRL_GLOBAL_VARIABLES_REC.VAT_TAX;
3578: EXCEPTION
3579: WHEN OTHERS THEN
3580: l_tax_catg_desc := null;

Line 6822: jl_zz_ar_tx_categ categ

6818:
6819: SELECT sum(nvl(itf.tax_amt,0))
6820: INTO l_provincial_perc_amt_tbl(p_trx_id_tbl(i))
6821: FROM zx_rep_trx_detail_t itf,
6822: jl_zz_ar_tx_categ categ
6823: WHERE itf.request_id = p_request_id
6824: AND itf.trx_id = p_trx_id_tbl(i)
6825: -- AND itf.tax_regime_code = p_prov_tax_regime
6826: AND nvl(itf.tax_type_code,'VAT') = 'VAT'

Line 7040: jl_zz_ar_tx_categ categ

7036:
7037: SELECT sum(nvl(itf.tax_amt,0))
7038: INTO l_municipal_perc_amt_tbl(p_trx_id_tbl(i))
7039: FROM zx_rep_trx_detail_t itf,
7040: jl_zz_ar_tx_categ categ
7041: WHERE itf.request_id = p_request_id
7042: AND itf.trx_id = p_trx_id_tbl(i)
7043: -- AND itf.tax_regime_code = p_mun_tax_regime
7044: AND nvl(itf.tax_type_code,'VAT') = 'VAT'

Line 7712: | from jl_zz_ar_tx_categ table to meet the requirement in the flat file |

7708: | Type : Private |
7709: | Pre-req : None |
7710: | Function : |
7711: | This function returns the Tax Authority Code |
7712: | from jl_zz_ar_tx_categ table to meet the requirement in the flat file |
7713: | |
7714: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
7715: | |
7716: | Parameters : |

Line 7747: FROM jl_zz_ar_tx_categ

7743: END IF;
7744:
7745: SELECT tax_authority_code
7746: INTO l_tax_authority_code
7747: FROM jl_zz_ar_tx_categ
7748: WHERE tax_category = p_vat_tax
7749: AND TAX_RULE_SET = 'ARGENTINA'
7750: AND org_id = p_org_id;
7751:

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 8269: | from fnd_lookups, jl_zz_ar_tx_cus_cls and jl_zz_ar_tx_categry table to |

8265: | Type : Private |
8266: | Pre-req : None |
8267: | Function : |
8268: | This function returns the Customer VAT Registration Status Code |
8269: | from fnd_lookups, jl_zz_ar_tx_cus_cls and jl_zz_ar_tx_categry table to |
8270: | meet the requirement in the flat file |
8271: | |
8272: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
8273: | |

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'

Line 8471: | from jl_zz_ar_tx_categ table to meet the requirement in the flat file |

8467: | Type : Private |
8468: | Pre-req : None |
8469: | Function : |
8470: | This function returns the Tax Authority Code |
8471: | from jl_zz_ar_tx_categ table to meet the requirement in the flat file |
8472: | |
8473: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
8474: | |
8475: | Parameters : |

Line 8676: | from jl_zz_ar_tx_categ table to meet the requirement in the flat file |

8672: | Type : Private |
8673: | Pre-req : None |
8674: | Function : |
8675: | This function returns the Tax Authority Code |
8676: | from jl_zz_ar_tx_categ table to meet the requirement in the flat file |
8677: | |
8678: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
8679: | |
8680: | Parameters : |

Line 8774: | from jl_zz_ar_tx_categ table to meet the requirement in the flat file |

8770: | Type : Private |
8771: | Pre-req : None |
8772: | Function : |
8773: | This function returns the Tax Authority Code |
8774: | from jl_zz_ar_tx_categ table to meet the requirement in the flat file |
8775: | |
8776: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
8777: | |
8778: | Parameters : |

Line 9923: | from jl_zz_ar_tx_categ table to meet the requirement in the flat file |

9919: | Type : Private |
9920: | Pre-req : None |
9921: | Function : |
9922: | This function returns the Tax Authority Code |
9923: | from jl_zz_ar_tx_categ table to meet the requirement in the flat file |
9924: | |
9925: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
9926: | |
9927: | Parameters : |