eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_CO_GL_MG_MEDIA_PKG dependencies on JL_CO_GL_BALANCES

Line 588: FROM jl_co_gl_balances b,

584: '6', SUM(NVL(b.begin_balance_cr, 0)) - SUM(NVL(b.begin_balance_dr, 0)) +
585: SUM(NVL(b.period_net_cr, 0)) - SUM(NVL(b.period_net_dr, 0)),
586: 0
587: ) amount
588: FROM jl_co_gl_balances b,
589: gl_sets_of_books sob1
590: WHERE b.set_of_books_id = sob1.set_of_books_id
591: AND b.currency_code = sob1.currency_code
592: AND sob1.set_of_books_id = p_set_of_books_id

Line 595: FROM jl_co_gl_balances b1

591: AND b.currency_code = sob1.currency_code
592: AND sob1.set_of_books_id = p_set_of_books_id
593: AND b.period_num =
594: (SELECT MAX(b1.period_num)
595: FROM jl_co_gl_balances b1
596: WHERE b.set_of_books_id = b1.set_of_books_id
597: AND b.code_combination_id = b1.code_combination_id
598: AND b.nit_id = b1.nit_id
599: --AND b.period_name = b1.period_name

Line 879: Select nit_id and sum(amount) from jl_co_gl_balances and jl_co_gl_trx tables

875: get_move_rec.send_back_flag := 'N';
876: get_move_rec.origin := 'A';
877:
878: /****************************************************************************
879: Select nit_id and sum(amount) from jl_co_gl_balances and jl_co_gl_trx tables
880: ****************************************************************************/
881:
882: IF literal_rec.movement_type IN ('1', '2', '3', '4') THEN
883: