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_JE_EXTRACT_PKG dependencies on ZX_REPORTING_TYPES_B

Line 152: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc

148: itf1.trx_business_category,
149: itf1.document_sub_type,
150: itf1.TAX_RATE_ID,
151: (SELECT assoc.reporting_code_char_value FROM
152: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
153: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
154: AND itf1.TAX_RATE_ID = assoc.entity_id
155: AND assoc.entity_code = 'ZX_RATES'
156: AND (assoc.EFFECTIVE_TO is null or assoc.EFFECTIVE_TO > sysdate)

Line 161: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc

157: AND rep_type.reporting_type_code
158: IN ('CZ_TAX_ORIGIN','HU_TAX_ORIGIN','PL_TAX_ORIGIN','CH_VAT_REGIME')
159: ),
160: (SELECT assoc.reporting_code_char_value FROM
161: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
162: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
163: AND itf1.TAX_RATE_ID = assoc.entity_id
164: AND assoc.entity_code = 'ZX_RATES'
165: AND (assoc.EFFECTIVE_TO is null or assoc.EFFECTIVE_TO > sysdate)

Line 175: p_reporting_type zx_reporting_types_b.reporting_type_code%TYPE ) IS

171:
172: --Bug 5636632
173: CURSOR get_reporting_code_value(
174: p_entity_id zx_report_codes_assoc.entity_id%TYPE ,
175: p_reporting_type zx_reporting_types_b.reporting_type_code%TYPE ) IS
176: SELECT assoc.reporting_code_char_value
177: FROM zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
178: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
179: AND assoc.entity_id = p_entity_id

Line 177: FROM zx_reporting_types_b rep_type,zx_report_codes_assoc assoc

173: CURSOR get_reporting_code_value(
174: p_entity_id zx_report_codes_assoc.entity_id%TYPE ,
175: p_reporting_type zx_reporting_types_b.reporting_type_code%TYPE ) IS
176: SELECT assoc.reporting_code_char_value
177: FROM zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
178: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
179: AND assoc.entity_id = p_entity_id
180: AND assoc.entity_code = 'ZX_RATES'
181: AND rep_type.reporting_type_code = p_reporting_type ;

Line 493: ZX_REPORTING_TYPES_B.REPORTING_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

489: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
490: TYPE ATTRIBUTE7_TBL is TABLE OF
491: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
492: TYPE REPORTING_TYPE_ID_TBL is TABLE OF
493: ZX_REPORTING_TYPES_B.REPORTING_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
494: TYPE ATTRIBUTE8_TBL is TABLE OF
495: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
496: TYPE ATTRIBUTE10_TBL is TABLE OF
497: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;

Line 607: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc

603: decode ( hr_loc.global_attribute_category,
604: 'JE.ES.PERWSLOC.PRL_YES', hr_loc.global_attribute5,
605: NULL ),
606: (SELECT assoc.reporting_code_char_value FROM
607: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
608: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
609: AND itf1.TAX_RATE_ID = assoc.entity_id
610: AND assoc.entity_code = 'ZX_RATES'
611: AND (assoc.EFFECTIVE_TO is null or assoc.EFFECTIVE_TO > sysdate)

Line 616: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc

612: AND rep_type.reporting_type_code
613: IN ('CZ_TAX_ORIGIN','HU_TAX_ORIGIN','PL_TAX_ORIGIN','CH_VAT_REGIME')
614: ),
615: (SELECT assoc.reporting_code_char_value FROM
616: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
617: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
618: AND itf1.TAX_RATE_ID = assoc.entity_id
619: AND assoc.entity_code = 'ZX_RATES'
620: AND (assoc.EFFECTIVE_TO is null or assoc.EFFECTIVE_TO > sysdate)

Line 635: p_reporting_type zx_reporting_types_b.reporting_type_code%TYPE ) IS

631:
632: --Bug 5636632
633: CURSOR get_reporting_code_value(
634: p_entity_id zx_report_codes_assoc.entity_id%TYPE ,
635: p_reporting_type zx_reporting_types_b.reporting_type_code%TYPE ) IS
636: SELECT assoc.reporting_code_char_value
637: FROM zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
638: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
639: AND assoc.entity_id = p_entity_id

Line 637: FROM zx_reporting_types_b rep_type,zx_report_codes_assoc assoc

633: CURSOR get_reporting_code_value(
634: p_entity_id zx_report_codes_assoc.entity_id%TYPE ,
635: p_reporting_type zx_reporting_types_b.reporting_type_code%TYPE ) IS
636: SELECT assoc.reporting_code_char_value
637: FROM zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
638: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
639: AND assoc.entity_id = p_entity_id
640: AND assoc.entity_code = 'ZX_RATES'
641: AND rep_type.reporting_type_code = p_reporting_type ;

Line 1032: p_reporting_type zx_reporting_types_b.reporting_type_code%TYPE ) IS

1028: C_LINES_PER_COMMIT Number:=1000;
1029:
1030: CURSOR get_reporting_code_value(
1031: p_entity_id zx_report_codes_assoc.entity_id%TYPE ,
1032: p_reporting_type zx_reporting_types_b.reporting_type_code%TYPE ) IS
1033: SELECT assoc.reporting_code_char_value
1034: FROM zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
1035: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
1036: AND assoc.entity_id = p_entity_id

Line 1034: FROM zx_reporting_types_b rep_type,zx_report_codes_assoc assoc

1030: CURSOR get_reporting_code_value(
1031: p_entity_id zx_report_codes_assoc.entity_id%TYPE ,
1032: p_reporting_type zx_reporting_types_b.reporting_type_code%TYPE ) IS
1033: SELECT assoc.reporting_code_char_value
1034: FROM zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
1035: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
1036: AND assoc.entity_id = p_entity_id
1037: AND assoc.entity_code = 'ZX_RATES'
1038: AND rep_type.reporting_type_code = p_reporting_type ;

Line 1047: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc

1043: itf1.trx_business_category,
1044: itf1.document_sub_type,
1045: itf1.TAX_RATE_ID,
1046: (SELECT assoc.reporting_code_char_value FROM
1047: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
1048: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
1049: AND itf1.TAX_RATE_ID = assoc.entity_id
1050: AND assoc.entity_code = 'ZX_RATES'
1051: AND (assoc.EFFECTIVE_TO is null or assoc.EFFECTIVE_TO > sysdate)

Line 1056: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc

1052: AND rep_type.reporting_type_code
1053: IN ('CZ_TAX_ORIGIN','HU_TAX_ORIGIN','PL_TAX_ORIGIN','CH_VAT_REGIME')
1054: ) ,
1055: (SELECT assoc.reporting_code_char_value FROM
1056: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
1057: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
1058: AND itf1.TAX_RATE_ID = assoc.entity_id
1059: AND assoc.entity_code = 'ZX_RATES'
1060: AND (assoc.EFFECTIVE_TO is null or assoc.EFFECTIVE_TO > sysdate)