APPS.XLA_TB_AP_REPORT_PVT dependencies on XLA_TB_DEFINITIONS_VL

Line 94: xla_tb_definitions_vl vl,

90: DISTINCT p.ledger_id, d.code_combination_id,
91: p.period_name,
92: rpad(''x'',500) pad
93: FROM xla_tb_defn_details d,
94: xla_tb_definitions_vl vl,
95: gl_period_statuses p
96: WHERE d.definition_code = ''$p_definition_code$''
97: AND vl.definition_code = d.definition_code
98: AND p.application_id =200

Line 136: xla_tb_definitions_vl vl

132: (
133: SELECT /*+ materialize */ DISTINCT ledger_id, code_combination_id,
134: rpad(''x'',500) pad
135: FROM xla_tb_defn_details d,
136: xla_tb_definitions_vl vl
137: WHERE d.definition_code = ''$p_definition_code$''
138: AND vl.definition_code = d.definition_code
139: ) ,
140: xe AS

Line 185: xla_tb_definitions_vl vl,

181: SELECT /*+ materialize */
182: DISTINCT gcck.code_combination_id, vl.ledger_id,
183: rpad(''x'',500) pad
184: FROM
185: xla_tb_definitions_vl vl,
186: xla_tb_def_seg_ranges xsr, -- added for bug#9926320
187: gl_code_combinations_kfv gcck
188: WHERE vl.definition_code = ''$p_definition_code$''
189: AND vl.definition_code = xsr.definition_code -- added for bug#9926320

Line 234: xla_tb_definitions_vl vl,

230: SELECT /*+ materialize */
231: DISTINCT gcck.code_combination_id, vl.ledger_id,
232: rpad(''x'',500) pad
233: FROM
234: xla_tb_definitions_vl vl,
235: xla_tb_def_seg_ranges xsr, -- added for bug#9926320
236: gl_code_combinations_kfv gcck
237: WHERE vl.definition_code = ''$p_definition_code$''
238: AND vl.definition_code = xsr.definition_code -- added for bug#9926320

Line 1930: FROM xla_tb_definitions_vl

1926: IF p_definition_code IS NOT NULL THEN
1927:
1928: SELECT NAME
1929: INTO p_report_definition_dsp
1930: FROM xla_tb_definitions_vl
1931: WHERE definition_code = p_definition_code;
1932:
1933: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1934: