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 GL_PERIOD_TYPES

Line 459: gl_period_types pt,

455: AND nit.nit_id = t.nit_id
456: AND sob1.set_of_books_id = p_set_of_books_id
457: AND t.period_name IN (SELECT p.period_name
458: FROM gl_periods p,
459: gl_period_types pt,
460: gl_period_sets ps,
461: gl_sets_of_books sob2
462: WHERE p.period_year = p_reported_year
463: AND p.period_num BETWEEN p_period_start

Line 549: gl_period_types pt,

545: )
546: AND b.period_name IN
547: (SELECT p.period_name
548: FROM gl_periods p,
549: gl_period_types pt,
550: gl_period_sets ps,
551: gl_sets_of_books sob2
552: WHERE p.period_year = p_reported_year
553: AND p.period_num BETWEEN p_period_start

Line 1787: gl_period_types pt,

1783: AND EXISTS (SELECT 1
1784: FROM gl_period_statuses stat,
1785: gl_periods p,
1786: gl_sets_of_books sob,
1787: gl_period_types pt,
1788: gl_period_sets ps,
1789: fnd_application a
1790: WHERE a.application_short_name = 'SQLGL'
1791: AND stat.application_id = a.application_id