DBA Data[Home] [Help]

APPS.XLA_TB_AP_REPORT_PVT dependencies on GL_BALANCES

Line 74: ,gl_balances gb

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
78: AND tbg.source_application_id = app.application_id

Line 343: ,gl_balances gb

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
347: AND tbg.code_combination_id = gcck.code_combination_id

Line 519: ,gl_balances gb

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
523: $gl_balance_join$

Line 677: ,gl_balances gb

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''
681: AND tb.source_entity_id = -1

Line 1354: FROM gl_balances gb

1350: AND NVL(TRUNC(l_as_of_date),TRUNC(sysdate)) BETWEEN gp.start_date AND gp.end_date
1351: AND NVL(gp.adjustment_period_flag,'N')='N'
1352: AND EXISTS
1353: ( SELECT 1
1354: FROM gl_balances gb
1355: WHERE gb.ledger_id = gl.ledger_id
1356: AND gb.period_name = gp.period_name
1357: )
1358: ;

Line 1496: -- Build columns to return GL Balances

1492: END IF;
1493:
1494: --
1495: --
1496: -- Build columns to return GL Balances
1497: --
1498: --
1499: --IF p_account_balance_code = 'YEAR_TO_DATE' THEN
1500: -- commented from TB phase4 7600550 GL Balance will be calculated

Line 1540: -- Build where clauses for GL Balances

1536: END IF; */
1537:
1538: --
1539: --
1540: -- Build where clauses for GL Balances
1541: --
1542: --
1543:
1544: --