DBA Data[Home] [Help]

APPS.IEX_METRIC_PVT dependencies on GL_LEDGERS_PUBLIC_V

Line 78: gl_ledgers_public_v gll,

74: c.minimum_accountable_unit,
75: TRUNC(add_months(sysdate, - 12)) pastYearFrom ,
76: TRUNC(sysdate) pastYearTo
77: FROM ar_system_parameters sp,
78: gl_ledgers_public_v gll,
79: fnd_currencies c
80: WHERE gll.ledger_id = sp.set_of_books_id
81: AND gll.currency_code = c.currency_code;
82: --End bug#5208170 schekuri 29-May-2006

Line 549: --Replaced view gl_sets_of_books with gl_ledgers_public_v

545:
546: END Test_Metric;
547: BEGIN
548: --Strat MOAC
549: --Replaced view gl_sets_of_books with gl_ledgers_public_v
550: --Begin bug#5208170 schekuri 29-May-2006
551: --Removed this because it's not being used anywhere
552: /*SELECT gll.currency_code,
553: c.precision,

Line 559: gl_ledgers_public_v gll,

555: INTO g_curr_rec.base_currency,
556: g_curr_rec.base_precision,
557: g_curr_rec.base_min_acc_unit
558: FROM ar_system_parameters sysp,
559: gl_ledgers_public_v gll,
560: fnd_currencies c
561: WHERE gll.ledger_id = sysp.set_of_books_id
562: AND gll.currency_code = c.currency_code;*/
563: --End bug#5208170 schekuri 29-May-2006