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_EXTRACT_PKG dependencies on ZX_REPORTING_CODES_VL

Line 4127: zx_reporting_codes_vl rep_codes,

4123: ORDER BY v.tax_line_id, v.order_num) AS row_num
4124: FROM (
4125: SELECT DISTINCT rep_codes.reporting_code_name, zxl.trx_line_id, zxl.tax_line_id,1 order_num
4126: FROM zx_reporting_types_b rep_types,
4127: zx_reporting_codes_vl rep_codes,
4128: zx_lines zxl
4129: WHERE zxl.application_id = 222
4130: AND zxl.entity_code = 'TRANSACTIONS'
4131: AND zxl.event_class_code IN ('INVOICE','DEBIT_MEMO','CREDIT_MEMO')

Line 4140: zx_reporting_codes_vl rep_codes,

4136: UNION
4137: SELECT DISTINCT rep_codes.reporting_code_name, zxl.trx_line_id,zxl.tax_line_id, 2 order_num
4138: FROM zx_report_codes_assoc rep_assoc,
4139: zx_reporting_types_b rep_types,
4140: zx_reporting_codes_vl rep_codes,
4141: zx_lines zxl
4142: WHERE zxl.application_id = 222
4143: AND zxl.entity_code = 'TRANSACTIONS'
4144: AND zxl.event_class_code IN ('INVOICE','DEBIT_MEMO','CREDIT_MEMO')

Line 4157: zx_reporting_codes_vl rep_codes,

4153: AND rep_types.legal_message_flag = 'Y'
4154: UNION
4155: SELECT DISTINCT rep_codes.reporting_code_name, zxl.trx_line_id,zxl.tax_line_id, 3 order_num
4156: FROM zx_reporting_types_b rep_types,
4157: zx_reporting_codes_vl rep_codes,
4158: zx_lines zxl
4159: WHERE zxl.application_id = 222
4160: AND zxl.entity_code = 'TRANSACTIONS'
4161: AND zxl.event_class_code IN ('INVOICE','DEBIT_MEMO','CREDIT_MEMO')

Line 4182: zx_reporting_codes_vl rep_codes,

4178: v.order_num
4179: FROM (
4180: SELECT DISTINCT rep_codes.reporting_code_name, zxl.tax_line_id,1 order_num
4181: FROM zx_reporting_types_b rep_types,
4182: zx_reporting_codes_vl rep_codes,
4183: zx_lines zxl
4184: WHERE zxl.application_id = 222
4185: AND zxl.entity_code = 'TRANSACTIONS'
4186: AND zxl.event_class_code IN ('INVOICE','DEBIT_MEMO','CREDIT_MEMO')

Line 4196: zx_reporting_codes_vl rep_codes,

4192: UNION
4193: SELECT DISTINCT rep_codes.reporting_code_name, zxl.tax_line_id, 2 order_num
4194: FROM zx_report_codes_assoc rep_assoc,
4195: zx_reporting_types_b rep_types,
4196: zx_reporting_codes_vl rep_codes,
4197: zx_lines zxl
4198: WHERE zxl.application_id = 222
4199: AND zxl.entity_code = 'TRANSACTIONS'
4200: AND zxl.event_class_code IN ('INVOICE','DEBIT_MEMO','CREDIT_MEMO')

Line 4214: zx_reporting_codes_vl rep_codes,

4210: AND rep_types.legal_message_flag = 'Y'
4211: UNION
4212: SELECT DISTINCT rep_codes.reporting_code_name, zxl.tax_line_id, 3 order_num
4213: FROM zx_reporting_types_b rep_types,
4214: zx_reporting_codes_vl rep_codes,
4215: zx_lines zxl
4216: WHERE zxl.application_id = 222
4217: AND zxl.entity_code = 'TRANSACTIONS'
4218: AND zxl.event_class_code IN ('INVOICE','DEBIT_MEMO','CREDIT_MEMO')

Line 4307: zx_reporting_codes_vl rep_codes,

4303: FROM (
4304: SELECT rep_codes.reporting_code_name, rep_codes.reporting_code_char_value, 1 order_num
4305: FROM zx_report_codes_assoc rep_assoc,
4306: zx_reporting_types_b rep_types,
4307: zx_reporting_codes_vl rep_codes,
4308: zx_lines zxl
4309: WHERE zxl.tax_line_id = p_tax_line_id
4310: AND rep_types.reporting_type_id = p_esl_eu_trx_type
4311: AND rep_types.reporting_type_id = rep_assoc.reporting_type_id

Line 4329: zx_reporting_codes_vl rep_codes,

4325: UNION
4326: SELECT rep_codes.reporting_code_name, rep_codes.reporting_code_char_value, 2 order_num
4327: FROM zx_report_codes_assoc rep_assoc,
4328: zx_reporting_types_b rep_types,
4329: zx_reporting_codes_vl rep_codes,
4330: zx_lines zxl
4331: WHERE zxl.tax_line_id = p_tax_line_id
4332: AND rep_types.reporting_type_id = p_esl_eu_trx_type
4333: AND rep_types.reporting_type_id = rep_assoc.reporting_type_id

Line 4351: zx_reporting_codes_vl rep_codes,

4347: UNION
4348: SELECT rep_codes.reporting_code_name, rep_codes.reporting_code_char_value, 3 order_num
4349: FROM zx_report_codes_assoc rep_assoc,
4350: zx_reporting_types_b rep_types,
4351: zx_reporting_codes_vl rep_codes,
4352: zx_lines zxl
4353: WHERE zxl.tax_line_id = p_tax_line_id
4354: AND rep_types.reporting_type_id = p_esl_eu_trx_type
4355: AND rep_types.reporting_type_id = rep_assoc.reporting_type_id