APPS.ZX_EXTRACT_PKG dependencies on ZX_REPORTING_TYPES_B

Line 4126: FROM zx_reporting_types_b rep_types,

4122: ROW_NUMBER() OVER (PARTITION BY v.trx_line_id
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'

Line 4139: zx_reporting_types_b rep_types,

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
4143: AND zxl.entity_code = 'TRANSACTIONS'

Line 4156: FROM zx_reporting_types_b rep_types,

4152: AND rep_codes.reporting_type_id = rep_types.reporting_type_id
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'

Line 4181: FROM zx_reporting_types_b rep_types,

4177: SELECT v.reporting_code_name,
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'

Line 4195: zx_reporting_types_b rep_types,

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
4199: AND zxl.entity_code = 'TRANSACTIONS'

Line 4213: FROM zx_reporting_types_b rep_types,

4209: AND rep_codes.reporting_type_id = rep_types.reporting_type_id
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'

Line 4306: zx_reporting_types_b rep_types,

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
4310: AND rep_types.reporting_type_id = p_esl_eu_trx_type

Line 4328: zx_reporting_types_b rep_types,

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
4332: AND rep_types.reporting_type_id = p_esl_eu_trx_type

Line 4350: zx_reporting_types_b rep_types,

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
4354: AND rep_types.reporting_type_id = p_esl_eu_trx_type