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_REPORT_CODES_ASSOC

Line 67: FROM zx_report_codes_assoc rep_assoc,

63: FROM
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

Line 82: FROM zx_report_codes_assoc rep_assoc,

78: AND rep_assoc.reporting_code_id = rep_codes.reporting_code_id
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

Line 97: FROM zx_report_codes_assoc rep_assoc,

93: AND rep_assoc.reporting_code_id = rep_codes.reporting_code_id
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

Line 267: zx_report_codes_assoc assoc

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'
271: AND (assoc.EFFECTIVE_TO is null

Line 289: zx_report_codes_assoc assoc

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'
293: AND DECODE(itf1.EVENT_CLASS_CODE,'CREDIT_MEMO',itf1.TAX_DETERMINE_DATE,

Line 330: p_entity_id zx_report_codes_assoc.entity_id%TYPE ,

326: AND itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
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

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 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 920: p_entity_id zx_report_codes_assoc.entity_id%TYPE ,

916: AND itf1.ship_to_location_id = hr_loc.ship_to_location_id(+) ;
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

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 1322: p_entity_id zx_report_codes_assoc.entity_id%TYPE ,

1318: L_COUNT NUMBER ;
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

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,