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 537: FROM jl_zz_ar_tx_categ_all catg,

533: /* DELETE from ZX_REP_TRX_DETAIL_T DET
534: WHERE DET.REQUEST_ID = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID and
535: NOT EXISTS
536: (SELECT 1
537: FROM jl_zz_ar_tx_categ_all catg,
538: jl_zz_ar_tx_att_cls_all attcls,
539: jl_zz_ar_tx_att_val_all val
540: WHERE attcls.tax_attribute_value = val.tax_attribute_value
541: AND attcls.tax_category_id = val.tax_category_id

Line 3046: jl_zz_ar_tx_categ categ

3042: l_tax_rate_id_tbl,
3043: l_tax_regime_code_tbl,
3044: l_document_sub_type_tbl
3045: FROM zx_rep_trx_detail_t itf1,
3046: jl_zz_ar_tx_categ categ
3047: WHERE itf1.request_id = P_REQUEST_ID
3048: -- AND itf1.tax_regime_code
3049: AND itf1.tax = categ.tax_category
3050: AND categ.tax_regime in (P_PROV_TAX_REGIME,

Line 3492: FROM JL_ZZ_AR_TX_CATEGRY jtc

3488:
3489: BEGIN
3490: SELECT jtc.description
3491: INTO l_tax_catg_desc
3492: FROM JL_ZZ_AR_TX_CATEGRY jtc
3493: WHERE jtc.tax_category = P_TRL_GLOBAL_VARIABLES_REC.VAT_TAX;
3494: EXCEPTION
3495: WHEN OTHERS THEN
3496: l_tax_catg_desc := null;

Line 6569: jl_zz_ar_tx_categ categ

6565:
6566: SELECT sum(nvl(itf.tax_amt,0))
6567: INTO l_provincial_perc_amt_tbl(p_trx_id_tbl(i))
6568: FROM zx_rep_trx_detail_t itf,
6569: jl_zz_ar_tx_categ categ
6570: WHERE itf.request_id = p_request_id
6571: AND itf.trx_id = p_trx_id_tbl(i)
6572: -- AND itf.tax_regime_code = p_prov_tax_regime
6573: AND nvl(itf.tax_type_code,'VAT') = 'VAT'

Line 6776: jl_zz_ar_tx_categ categ

6772:
6773: SELECT sum(nvl(itf.tax_amt,0))
6774: INTO l_municipal_perc_amt_tbl(p_trx_id_tbl(i))
6775: FROM zx_rep_trx_detail_t itf,
6776: jl_zz_ar_tx_categ categ
6777: WHERE itf.request_id = p_request_id
6778: AND itf.trx_id = p_trx_id_tbl(i)
6779: -- AND itf.tax_regime_code = p_mun_tax_regime
6780: AND nvl(itf.tax_type_code,'VAT') = 'VAT'

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

7316: | Type : Private |
7317: | Pre-req : None |
7318: | Function : |
7319: | This function returns the Tax Authority Code |
7320: | from jl_zz_ar_tx_categ table to meet the requirement in the flat file |
7321: | |
7322: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
7323: | |
7324: | Parameters : |

Line 7355: FROM jl_zz_ar_tx_categ

7351: END IF;
7352:
7353: SELECT tax_authority_code
7354: INTO l_tax_authority_code
7355: FROM jl_zz_ar_tx_categ
7356: WHERE tax_category = p_vat_tax
7357: AND org_id = p_org_id;
7358:
7359:

Line 7595: JL_ZZ_AR_TX_CATEG_ALL categ,

7591:
7592: SELECT VAL.TAX_ATTR_VALUE_CODE
7593: INTO l_cust_condition_code_tbl(p_trx_id_tbl(i))
7594: FROM JL_ZZ_AR_TX_CUS_CLS_ALL cust,
7595: JL_ZZ_AR_TX_CATEG_ALL categ,
7596: JL_ZZ_AR_TX_ATT_VAL_ALL val
7597: WHERE CUST.TAX_ATTRIBUTE_VALUE = VAL.TAX_ATTRIBUTE_VALUE and
7598: CUST.TAX_CATEGORY_ID = VAL.TAX_CATEGORY_ID and
7599: CUST.TAX_CATEGORY_ID = CATEG.TAX_CATEGORY_ID and

Line 7619: JL_ZZ_AR_TX_CATEG_ALL categ,

7615:
7616: SELECT VAL.TAX_ATTR_VALUE_CODE
7617: INTO l_cust_condition_code_tbl(p_trx_id_tbl(i))
7618: FROM JL_ZZ_AR_TX_ATT_CLS_ALL cust,
7619: JL_ZZ_AR_TX_CATEG_ALL categ,
7620: JL_ZZ_AR_TX_ATT_VAL val
7621: WHERE CUST.TAX_ATTRIBUTE_VALUE = VAL.TAX_ATTRIBUTE_VALUE and
7622: CUST.TAX_CATEGORY_ID = VAL.TAX_CATEGORY_ID and
7623: CUST.TAX_CATEGORY_ID = CATEG.TAX_CATEGORY_ID and

Line 7731: jl_zz_ar_tx_categ_all catg,

7727: BEGIN
7728: SELECT val.tax_attr_value_code
7729: INTO l_dgi_tax_regime_code_tbl(p_trx_line_id_tbl(i))
7730: FROM zx_lines lines,
7731: jl_zz_ar_tx_categ_all catg,
7732: jl_zz_ar_tx_att_cls_all attcls,
7733: jl_zz_ar_tx_att_val_all val
7734: WHERE catg.tax_category = P_VAT_PERCEP_TAX
7735: ANd catg.tax_category = lines.tax

Line 7793: | from fnd_lookups, jl_zz_ar_tx_cus_cls and jl_zz_ar_tx_categry table to |

7789: | Type : Private |
7790: | Pre-req : None |
7791: | Function : |
7792: | This function returns the Customer VAT Registration Status Code |
7793: | from fnd_lookups, jl_zz_ar_tx_cus_cls and jl_zz_ar_tx_categry table to |
7794: | meet the requirement in the flat file |
7795: | |
7796: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
7797: | |

Line 7909: jl_zz_ar_tx_categ_all catg,

7905:
7906: SELECT lkp.meaning
7907: INTO l_vat_reg_stat_code_tbl(p_trx_id_tbl(i))
7908: FROM jl_zz_ar_tx_cus_cls_all cls,
7909: jl_zz_ar_tx_categ_all catg,
7910: fnd_lookups lkp
7911: WHERE cls.tax_attr_class_code = l_class_code
7912: AND cls.tax_attribute_name = 'VAT CONT STATUS'
7913: AND cls.tax_category_id = catg.tax_category_id

Line 7927: jl_zz_ar_tx_categ_all catg,

7923:
7924: SELECT lkp.meaning
7925: INTO l_vat_reg_stat_code_tbl(p_trx_id_tbl(i))
7926: FROM jl_zz_ar_tx_att_cls_all cls,
7927: jl_zz_ar_tx_categ_all catg,
7928: fnd_lookups lkp
7929: WHERE cls.tax_attr_class_type = 'CONTRIBUTOR_CLASS'
7930: AND cls.tax_attr_class_code = l_class_code
7931: AND cls.tax_attribute_name = 'VAT CONT STATUS'

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

7991: | Type : Private |
7992: | Pre-req : None |
7993: | Function : |
7994: | This function returns the Tax Authority Code |
7995: | from jl_zz_ar_tx_categ table to meet the requirement in the flat file |
7996: | |
7997: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
7998: | |
7999: | Parameters : |

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

8196: | Type : Private |
8197: | Pre-req : None |
8198: | Function : |
8199: | This function returns the Tax Authority Code |
8200: | from jl_zz_ar_tx_categ table to meet the requirement in the flat file |
8201: | |
8202: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
8203: | |
8204: | Parameters : |

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

8294: | Type : Private |
8295: | Pre-req : None |
8296: | Function : |
8297: | This function returns the Tax Authority Code |
8298: | from jl_zz_ar_tx_categ table to meet the requirement in the flat file |
8299: | |
8300: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
8301: | |
8302: | Parameters : |

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

9409: | Type : Private |
9410: | Pre-req : None |
9411: | Function : |
9412: | This function returns the Tax Authority Code |
9413: | from jl_zz_ar_tx_categ table to meet the requirement in the flat file |
9414: | |
9415: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
9416: | |
9417: | Parameters : |