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.PO_ENCUMBRANCE_PREPROCESSING dependencies on GL_SETS_OF_BOOKS

Line 4502: GL_SETS_OF_BOOKS GL_SOB

4498: GL_PS.QUARTER_NUM
4499: FROM
4500: GL_PERIOD_STATUSES GL_PS,
4501: GL_PERIOD_STATUSES PO_PS,
4502: GL_SETS_OF_BOOKS GL_SOB
4503: WHERE
4504: -- Join conditions:
4505: GL_SOB.set_of_books_id = p_set_of_books_id
4506: AND GL_PS.set_of_books_id = GL_SOB.set_of_books_id

Line 4560: , GL_SETS_OF_BOOKS GL_SOB

4556: (SELECT min(gl_ps.start_date)
4557: FROM
4558: GL_PERIOD_STATUSES GL_PS
4559: , GL_PERIOD_STATUSES PO_PS
4560: , GL_SETS_OF_BOOKS GL_SOB
4561: WHERE
4562: -- Join conditions:
4563: GL_SOB.set_of_books_id = p_set_of_books_id
4564: AND GL_PS.set_of_books_id = GL_SOB.set_of_books_id

Line 4620: , GL_SETS_OF_BOOKS GL_SOB

4616: (SELECT max(gl_ps.end_date)
4617: FROM
4618: GL_PERIOD_STATUSES GL_PS
4619: , GL_PERIOD_STATUSES PO_PS
4620: , GL_SETS_OF_BOOKS GL_SOB
4621: WHERE
4622: -- Join conditions:
4623: GL_SOB.set_of_books_id = p_set_of_books_id
4624: AND GL_PS.set_of_books_id = GL_SOB.set_of_books_id

Line 4681: GL_SETS_OF_BOOKS GL_SOB

4677: TRUNC(GL_PS.START_DATE) latest_open_date
4678: FROM
4679: GL_PERIOD_STATUSES GL_PS,
4680: GL_PERIOD_STATUSES PO_PS,
4681: GL_SETS_OF_BOOKS GL_SOB
4682: WHERE GL_SOB.set_of_books_id = p_set_of_books_id
4683: AND GL_PS.application_id = 101
4684: AND PO_PS.application_id = 201
4685: AND GL_PS.set_of_books_id = GL_SOB.set_of_books_id --JOIN