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.

[Home] [Help]

APPS.JMF_GTA_ARTRX_PROC dependencies on GL_SETS_OF_BOOKS

Line 929: FROM Gl_Sets_Of_Books

925: AND h.Org_Id = gd.Org_Id
926: AND h.Org_Id = ctt.Org_Id
927: AND h.Org_Id =:p_org_id
928: AND GP.PERIOD_SET_NAME = (SELECT period_set_name
929: FROM Gl_Sets_Of_Books
930: WHERE set_of_books_id = h.set_of_books_id)
931: AND gp.period_type = (SELECT accounted_period_type
932: FROM Gl_Sets_Of_Books
933: WHERE set_of_books_id = h.set_of_books_id)

Line 932: FROM Gl_Sets_Of_Books

928: AND GP.PERIOD_SET_NAME = (SELECT period_set_name
929: FROM Gl_Sets_Of_Books
930: WHERE set_of_books_id = h.set_of_books_id)
931: AND gp.period_type = (SELECT accounted_period_type
932: FROM Gl_Sets_Of_Books
933: WHERE set_of_books_id = h.set_of_books_id)
934: AND gp.adjustment_period_flag = ''N''
935: AND gp.start_date <= gd.GL_DATE
936: AND gp.end_date >= gd.gl_date ';

Line 2412: FROM Gl_Sets_Of_Books

2408: AND h.Org_Id = ctt.Org_Id
2409: AND h.Org_Id = p_org_id
2410: AND GP.PERIOD_SET_NAME =
2411: (SELECT period_set_name
2412: FROM Gl_Sets_Of_Books
2413: WHERE set_of_books_id = h.set_of_books_id)
2414: AND gp.period_type =
2415: (SELECT accounted_period_type
2416: FROM Gl_Sets_Of_Books

Line 2416: FROM Gl_Sets_Of_Books

2412: FROM Gl_Sets_Of_Books
2413: WHERE set_of_books_id = h.set_of_books_id)
2414: AND gp.period_type =
2415: (SELECT accounted_period_type
2416: FROM Gl_Sets_Of_Books
2417: WHERE set_of_books_id = h.set_of_books_id)
2418: AND gp.adjustment_period_flag = 'N'
2419: AND gp.start_date <= gd.GL_DATE
2420: AND gp.end_date >= gd.gl_date