APPS.ZX_JE_EXTRACT_PKG dependencies on ZX_REPORTING_CODES_VL

Line 69: zx_reporting_codes_vl rep_codes,

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'
73: AND rep_types.reporting_type_id = rep_assoc.reporting_type_id

Line 84: zx_reporting_codes_vl rep_codes,

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'
88: AND rep_types.reporting_type_id = rep_assoc.reporting_type_id

Line 99: zx_reporting_codes_vl rep_codes,

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'
103: AND rep_types.reporting_type_id = rep_assoc.reporting_type_id