APPS.ZX_EXTRACT_PKG dependencies on ZX_REPORT_CODES_ASSOC

Line 4138: FROM zx_report_codes_assoc rep_assoc,

4134: AND rep_codes.reporting_type_id = rep_types.reporting_type_id
4135: AND rep_types.legal_message_flag = 'Y'
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

Line 4194: FROM zx_report_codes_assoc rep_assoc,

4190: AND rep_codes.reporting_type_id = rep_types.reporting_type_id
4191: AND rep_types.legal_message_flag = 'Y'
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

Line 4305: FROM zx_report_codes_assoc rep_assoc,

4301: FROM
4302: (SELECT v.reporting_code_name, v.reporting_code_char_value
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

Line 4327: FROM zx_report_codes_assoc rep_assoc,

4323: (p_esl_eu_addl_code2 IS NOT NULL
4324: AND rep_codes.reporting_code_id = p_esl_eu_addl_code2))
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

Line 4349: FROM zx_report_codes_assoc rep_assoc,

4345: (p_esl_eu_addl_code2 IS NOT NULL
4346: AND rep_codes.reporting_code_id = p_esl_eu_addl_code2))
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