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 ZX_REPORTING_TYPES_B

Line 3204: -- zx_reporting_types_b reptypes,--Bug 5438742

3200: l_document_sub_type_tbl
3201: FROM zx_rep_trx_detail_t itf,
3202: zx_rates_b rates,
3203: -- zx_report_codes_assoc repc,
3204: -- zx_reporting_types_b reptypes,--Bug 5438742
3205: ra_customer_trx_all ratrx,
3206: ra_cust_trx_types_all types
3207: WHERE itf.request_id = P_REQUEST_ID
3208: AND itf.trx_id = ratrx.customer_trx_id

Line 8515: FROM zx_reporting_types_b rep_type,

8511: IF l_dgi_trx_code_tbl(p_tax_rate_id_tbl(i)) IS NULL THEN
8512: BEGIN
8513: SELECT rep_ass.reporting_code_char_value
8514: INTO l_dgi_trx_code_tbl(p_tax_rate_id_tbl(i))
8515: FROM zx_reporting_types_b rep_type,
8516: zx_report_codes_assoc rep_ass
8517: WHERE rep_type.reporting_type_code = 'AR_DGI_TRX_CODE'
8518: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
8519: AND rep_ass.entity_code = 'ZX_RATES'

Line 8611: FROM zx_reporting_types_b rep_type,

8607: IF l_tax_auth_categ_tbl(p_tax_rate_id_tbl(i)) IS NULL THEN
8608: BEGIN
8609: SELECT rep_ass.reporting_code_char_value
8610: INTO l_tax_auth_categ_tbl(p_tax_rate_id_tbl(i))
8611: FROM zx_reporting_types_b rep_type,
8612: zx_report_codes_assoc rep_ass
8613: WHERE rep_type.reporting_type_code = 'AR_TAX_AUTHORITY_CATEG'
8614: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
8615: AND rep_ass.entity_code = 'ZX_RATES'

Line 8708: FROM zx_reporting_types_b rep_type,

8704: IF l_prov_juris_code_tbl(p_tax_rate_id_tbl(i)) IS NULL THEN
8705: BEGIN
8706: /* SELECT rep_ass.reporting_code_char_value
8707: INTO l_prov_juris_code_tbl(p_tax_rate_id_tbl(i))
8708: FROM zx_reporting_types_b rep_type,
8709: zx_report_codes_assoc rep_ass
8710: WHERE rep_type.reporting_type_code = 'AR_TURN_OVER_JUR_CODE'
8711: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
8712: AND rep_ass.entity_code = 'ZX_RATES'

Line 8808: FROM zx_reporting_types_b rep_type,

8804: IF l_mun_juris_code_tbl(p_tax_rate_id_tbl(i)) IS NULL THEN
8805: BEGIN
8806: /* SELECT rep_ass.reporting_code_char_value
8807: INTO l_mun_juris_code_tbl(p_tax_rate_id_tbl(i))
8808: FROM zx_reporting_types_b rep_type,
8809: zx_report_codes_assoc rep_ass
8810: WHERE rep_type.reporting_type_code = 'AR_MUNICIPAL_JUR'
8811: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
8812: AND rep_ass.entity_code = 'ZX_RATES'

Line 8986: FROM zx_reporting_types_b rep_type,

8982: 'P_TAX_REGIME_CODE_TBL : '||P_TAX_REGIME_CODE_TBL(i));
8983: END IF;
8984: SELECT rep_ass.reporting_code_char_value
8985: INTO l_cai_num_tbl(p_trx_id_tbl(i))
8986: FROM zx_reporting_types_b rep_type,
8987: zx_report_codes_assoc rep_ass
8988: WHERE rep_type.reporting_type_code = 'CAI NUMBER'
8989: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
8990: AND rep_ass.entity_code = 'ZX_PARTY_TAX_PROFILE'

Line 9181: FROM zx_reporting_types_b rep_type,

9177: IF l_fiscal_printer_tbl(p_trx_id_tbl(i)) is null THEN
9178: BEGIN
9179: SELECT rep_ass.reporting_code_char_value
9180: INTO l_rep_fiscal_printer_tbl(i)
9181: FROM zx_reporting_types_b rep_type,
9182: zx_report_codes_assoc rep_ass
9183: WHERE rep_type.reporting_type_code = 'FISCAL PRINTER'
9184: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
9185: AND rep_ass.entity_code = 'ZX_PARTY_TAX_PROFILE'