APPS.XLA_TB_AP_REPORT_PVT dependencies on GL_CODE_COMBINATIONS

Line 73: ,gl_code_combinations_kfv gcck

69: $seg_desc_cols$
70: FROM xla_trial_balances_gt tbg
71: ,fnd_application_vl app
72: ,xla_entity_types_vl ett
73: ,gl_code_combinations_kfv gcck
74: ,gl_balances gb
75: $seg_desc_from$
76: WHERE tbg.source_entity_code = ett.entity_code
77: AND tbg.source_application_id = ett.application_id

Line 112: ,gl_code_combinations_kfv gcck

108: l.code_combination_id,
109: sum(nvl(l.accounted_cr, 0))- sum(nvl(l.accounted_dr,0)) NONAP_AMOUNT
110: FROM gl_je_headers h
111: ,gl_je_lines l
112: ,gl_code_combinations_kfv gcck
113: ,xtd
114: WHERE l.code_combination_id = gcck.code_combination_id
115: AND l.code_combination_id = xtd.code_combination_id
116: AND l.ledger_id = xtd.ledger_id

Line 156: gl_code_combinations_kfv gcck

152: FROM xe,
153: xla_ae_headers h,
154: xla_ae_lines l,
155: xtd ,
156: gl_code_combinations_kfv gcck
157: WHERE gcck.code_combination_id = l.code_combination_id
158: AND h.application_id = 200
159: AND gcck.code_combination_id = xtd.code_combination_id
160: AND l.application_id = h.application_id

Line 187: gl_code_combinations_kfv gcck

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
190: $gcck_join$
191: AND EXISTS

Line 236: gl_code_combinations_kfv gcck

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
239: $gcck_join$
240: AND EXISTS

Line 342: ,gl_code_combinations_kfv gcck

338: ,tbg.MANUAL_SLA_AMOUNT MANUAL_SLA_AMOUNT
339: $seg_desc_cols$
340: FROM xla_trial_balances_gt tbg
341: ,fnd_application_vl app
342: ,gl_code_combinations_kfv gcck
343: ,gl_balances gb
344: $seg_desc_from$
345: WHERE tbg.record_type_code = ''SOURCE''
346: AND tbg.source_application_id = app.application_id

Line 518: ,gl_code_combinations_kfv gcck

514: ,tbg.MANUAL_SLA_AMOUNT MANUAL_SLA_AMOUNT
515: $seg_desc_cols$
516: FROM xla_trial_balances_gt tbg
517: ,fnd_application_vl app
518: ,gl_code_combinations_kfv gcck
519: ,gl_balances gb
520: $seg_desc_from$
521: WHERE tbg.source_application_id = app.application_id
522: AND tbg.code_combination_id = gcck.code_combination_id

Line 676: ,gl_code_combinations_kfv gcck

672: ,NULL MANUAL_SLA_AMOUNT
673: $seg_desc_cols$
674: FROM xla_trial_balances tb
675: ,fnd_application_vl app
676: ,gl_code_combinations_kfv gcck
677: ,gl_balances gb
678: $seg_desc_from$
679: WHERE tb.definition_code = ''$definition_code$''
680: AND tb.record_type_code = ''SOURCE''

Line 2309: ,' ,gl_code_combinations cc ');

2305: l_flex_range_where);
2306:
2307: l_insert_gt_sql := REPLACE(l_insert_gt_sql
2308: ,'$account_tab$'
2309: ,' ,gl_code_combinations cc ');
2310:
2311: ELSE
2312:
2313: l_insert_gt_sql := REPLACE(l_insert_gt_sql, '$account_range$', '');

Line 2791: l_code_combination_id gl_code_combinations.code_combination_id%TYPE;

2787: SELECT code_combination_id
2788: FROM xla_tb_defn_details
2789: WHERE definition_code = p_definition_code;
2790:
2791: l_code_combination_id gl_code_combinations.code_combination_id%TYPE;
2792:
2793: BEGIN
2794:
2795: IF g_log_enabled THEN