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 68: zx_reporting_types_b rep_types,

64: (SELECT v.reporting_code_name, v.reporting_code_char_value
65: FROM (
66: SELECT rep_codes.reporting_code_name, rep_codes.reporting_code_char_value, 1 order_num
67: FROM zx_report_codes_assoc rep_assoc,
68: zx_reporting_types_b rep_types,
69: zx_reporting_codes_vl rep_codes,
70: zx_lines zxl
71: WHERE zxl.tax_line_id = p_tax_line_id
72: AND rep_types.reporting_type_code = 'INTRA_EU_VAT_TRANSACTION_TYPE'

Line 83: zx_reporting_types_b rep_types,

79: AND ROWNUM=1
80: UNION
81: SELECT rep_codes.reporting_code_name, rep_codes.reporting_code_char_value, 2 order_num
82: FROM zx_report_codes_assoc rep_assoc,
83: zx_reporting_types_b rep_types,
84: zx_reporting_codes_vl rep_codes,
85: zx_lines zxl
86: WHERE zxl.tax_line_id = p_tax_line_id
87: AND rep_types.reporting_type_code = 'INTRA_EU_VAT_TRANSACTION_TYPE'

Line 98: zx_reporting_types_b rep_types,

94: AND ROWNUM = 1
95: UNION
96: SELECT rep_codes.reporting_code_name, rep_codes.reporting_code_char_value, 3 order_num
97: FROM zx_report_codes_assoc rep_assoc,
98: zx_reporting_types_b rep_types,
99: zx_reporting_codes_vl rep_codes,
100: zx_lines zxl
101: WHERE zxl.tax_line_id = p_tax_line_id
102: AND rep_types.reporting_type_code = 'INTRA_EU_VAT_TRANSACTION_TYPE'

Line 266: FROM zx_reporting_types_b rep_type,

262: itf1.trx_business_category,
263: itf1.document_sub_type,
264: itf1.TAX_RATE_ID,
265: (SELECT assoc.reporting_code_char_value
266: FROM zx_reporting_types_b rep_type,
267: zx_report_codes_assoc assoc
268: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
269: AND itf1.TAX_RATE_ID = assoc.entity_id
270: AND assoc.entity_code = 'ZX_RATES'

Line 288: FROM zx_reporting_types_b rep_type,

284: )
285: AND rep_type.reporting_type_code IN ('CZ_TAX_ORIGIN','HU_TAX_ORIGIN','PL_TAX_ORIGIN','CH_VAT_REGIME')
286: ),
287: (SELECT assoc.reporting_code_char_value
288: FROM zx_reporting_types_b rep_type,
289: zx_report_codes_assoc assoc
290: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
291: AND itf1.TAX_RATE_ID = assoc.entity_id
292: AND assoc.entity_code = 'ZX_RATES'

Line 331: p_reporting_type zx_reporting_types_b.reporting_type_code%TYPE ) IS

327:
328: --Bug 5636632
329: CURSOR get_reporting_code_value(
330: p_entity_id zx_report_codes_assoc.entity_id%TYPE ,
331: p_reporting_type zx_reporting_types_b.reporting_type_code%TYPE ) IS
332: SELECT assoc.reporting_code_char_value
333: FROM zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
334: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
335: AND assoc.entity_id = p_entity_id

Line 333: FROM zx_reporting_types_b rep_type,zx_report_codes_assoc assoc

329: CURSOR get_reporting_code_value(
330: p_entity_id zx_report_codes_assoc.entity_id%TYPE ,
331: p_reporting_type zx_reporting_types_b.reporting_type_code%TYPE ) IS
332: SELECT assoc.reporting_code_char_value
333: FROM zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
334: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
335: AND assoc.entity_id = p_entity_id
336: AND assoc.entity_code = 'ZX_RATES'
337: AND rep_type.reporting_type_code = p_reporting_type ;

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

739: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
740: TYPE ATTRIBUTE7_TBL is TABLE OF
741: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
742: TYPE REPORTING_TYPE_ID_TBL is TABLE OF
743: ZX_REPORTING_TYPES_B.REPORTING_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
744: TYPE ATTRIBUTE8_TBL is TABLE OF
745: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
746: TYPE ATTRIBUTE10_TBL is TABLE OF
747: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;

Line 860: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc

856: decode ( hr_loc.global_attribute_category,
857: 'JE.ES.PERWSLOC.PRL_YES', hr_loc.global_attribute5,
858: NULL ),
859: (SELECT assoc.reporting_code_char_value FROM
860: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
861: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
862: AND itf1.TAX_RATE_ID = assoc.entity_id
863: AND assoc.entity_code = 'ZX_RATES'
864: AND (assoc.EFFECTIVE_TO is null

Line 879: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc

875: )
876: AND rep_type.reporting_type_code IN ('CZ_TAX_ORIGIN','HU_TAX_ORIGIN','PL_TAX_ORIGIN','CH_VAT_REGIME')
877: ),
878: (SELECT assoc.reporting_code_char_value FROM
879: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
880: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
881: AND itf1.TAX_RATE_ID = assoc.entity_id
882: AND assoc.entity_code = 'ZX_RATES'
883: AND NVL2(P_TRL_GLOBAL_VARIABLES_REC.TAX_INVOICE_DATE_HIGH,

Line 921: p_reporting_type zx_reporting_types_b.reporting_type_code%TYPE ) IS

917:
918: --Bug 5636632
919: CURSOR get_reporting_code_value(
920: p_entity_id zx_report_codes_assoc.entity_id%TYPE ,
921: p_reporting_type zx_reporting_types_b.reporting_type_code%TYPE ) IS
922: SELECT assoc.reporting_code_char_value
923: FROM zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
924: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
925: AND assoc.entity_id = p_entity_id

Line 923: FROM zx_reporting_types_b rep_type,zx_report_codes_assoc assoc

919: CURSOR get_reporting_code_value(
920: p_entity_id zx_report_codes_assoc.entity_id%TYPE ,
921: p_reporting_type zx_reporting_types_b.reporting_type_code%TYPE ) IS
922: SELECT assoc.reporting_code_char_value
923: FROM zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
924: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
925: AND assoc.entity_id = p_entity_id
926: AND assoc.entity_code = 'ZX_RATES'
927: AND rep_type.reporting_type_code = p_reporting_type ;

Line 1323: p_reporting_type zx_reporting_types_b.reporting_type_code%TYPE ) IS

1319: C_LINES_PER_COMMIT Number:=1000;
1320:
1321: CURSOR get_reporting_code_value(
1322: p_entity_id zx_report_codes_assoc.entity_id%TYPE ,
1323: p_reporting_type zx_reporting_types_b.reporting_type_code%TYPE ) IS
1324: SELECT assoc.reporting_code_char_value
1325: FROM zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
1326: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
1327: AND assoc.entity_id = p_entity_id

Line 1325: FROM zx_reporting_types_b rep_type,zx_report_codes_assoc assoc

1321: CURSOR get_reporting_code_value(
1322: p_entity_id zx_report_codes_assoc.entity_id%TYPE ,
1323: p_reporting_type zx_reporting_types_b.reporting_type_code%TYPE ) IS
1324: SELECT assoc.reporting_code_char_value
1325: FROM zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
1326: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
1327: AND assoc.entity_id = p_entity_id
1328: AND assoc.entity_code = 'ZX_RATES'
1329: AND rep_type.reporting_type_code = p_reporting_type ;

Line 1338: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc

1334: itf1.trx_business_category,
1335: itf1.document_sub_type,
1336: itf1.TAX_RATE_ID,
1337: (SELECT assoc.reporting_code_char_value FROM
1338: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
1339: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
1340: AND itf1.TAX_RATE_ID = assoc.entity_id
1341: AND assoc.entity_code = 'ZX_RATES'
1342: AND (assoc.EFFECTIVE_TO is null

Line 1357: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc

1353: )
1354: AND rep_type.reporting_type_code IN ('CZ_TAX_ORIGIN','HU_TAX_ORIGIN','PL_TAX_ORIGIN','CH_VAT_REGIME')
1355: ) ,
1356: (SELECT assoc.reporting_code_char_value FROM
1357: zx_reporting_types_b rep_type,zx_report_codes_assoc assoc
1358: WHERE rep_type.reporting_type_id = assoc.reporting_type_id
1359: AND itf1.TAX_RATE_ID = assoc.entity_id
1360: AND assoc.entity_code = 'ZX_RATES'
1361: AND NVL2(P_TRL_GLOBAL_VARIABLES_REC.TAX_INVOICE_DATE_HIGH,