APPS.XLA_TB_AP_REPORT_PVT dependencies on GL_LEDGERS

Line 479: gl_ledgers gl

475: tb.balancing_segment_value, tb.natural_account_segment_value,
476: tb.cost_center_segment_value, tb.intercompany_segment_value,
477: tb.management_segment_value
478: ) summary_dat ,
479: gl_ledgers gl
480: WHERE summary_dat.ledger_id=gl.ledger_id
481: ';
482:
483: -- Perf changes for TB Report Summary Template bug:8773522 --

Line 1029: gl_ledgers gl,

1025: TIV.DESCRIPTION USER_TRX_IDENTIFIER_VALUE_10
1026: FROM
1027: AP_SLA_INVOICES_TRANSACTION_V tiv,
1028: xla_transaction_entities xte,
1029: gl_ledgers gl,
1030: -- inline view
1031: ( SELECT /*+ parallel(xtb) leading(xtb) NO_MERGE */ --added hint bug#8409806 -- leading hint for bug:9165098
1032: /* added NO_MERGE for bug:9473043 */
1033: xtb.definition_code,

Line 1244: FROM gl_ledgers gl , gl_periods gp

1240:
1241: -- add TB phase4 bug#7600550 bug#8278138
1242: CURSOR c_latest_open_period IS
1243: SELECT latest_opened_period_name , gp.start_date
1244: FROM gl_ledgers gl , gl_periods gp
1245: where ledger_id = p_ledger_id
1246: AND gp.period_set_name = gl.period_set_name
1247: AND gp.period_type = gl.accounted_period_type
1248: AND NVL(gp.adjustment_period_flag,'N')='N'

Line 1318: FROM gl_ledgers gl

1314: --added bug 6684579 ,pick as_of_date period instead of sysdate period if as of date is provided
1315: /*
1316: SELECT gp.period_name
1317: INTO l_period_name
1318: FROM gl_ledgers gl
1319: ,gl_periods gp
1320: WHERE gl.ledger_id = p_ledger_id
1321: AND gp.period_set_name = gl.period_set_name
1322: AND gp.period_type = gl.accounted_period_type

Line 1345: FROM gl_ledgers gl

1341: */
1342:
1343: SELECT gp.period_name
1344: INTO l_period_name
1345: FROM gl_ledgers gl
1346: ,gl_periods gp
1347: WHERE gl.ledger_id = p_ledger_id
1348: AND gp.period_set_name = gl.period_set_name
1349: AND gp.period_type = gl.accounted_period_type

Line 2668: l_coa_id gl_ledgers.chart_of_accounts_id%TYPE;

2664: FUNCTION get_gcck_join
2665: (p_ledger_id IN NUMBER
2666: ) RETURN VARCHAR2 IS
2667:
2668: l_coa_id gl_ledgers.chart_of_accounts_id%TYPE;
2669: l_join_gcck VARCHAR2(32000) := ' ';
2670: --added for bug#9926320
2671: C_STRING CONSTANT VARCHAR2(240) :=
2672: ' AND NVL(gcck.$segment$,''0'') BETWEEN NVL(NVL(xsr.$segment$_from, gcck.$segment$),''0'')

Line 2687: FROM gl_ledgers

2683: BEGIN
2684:
2685: SELECT chart_of_accounts_id
2686: INTO l_coa_id
2687: FROM gl_ledgers
2688: WHERE ledger_id = p_ledger_id;
2689:
2690:
2691: l_join_gcck := l_join_gcck || ' AND gcck.chart_of_accounts_id = ' || l_coa_id;