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_PERIOD_STATUSES

Line 4418: GL_PERIOD_STATUSES GL_PS,

4414: GL_PS.PERIOD_YEAR,
4415: GL_PS.PERIOD_NUM,
4416: GL_PS.QUARTER_NUM
4417: FROM
4418: GL_PERIOD_STATUSES GL_PS,
4419: GL_PERIOD_STATUSES PO_PS,
4420: GL_SETS_OF_BOOKS GL_SOB
4421: WHERE
4422: -- Join conditions:

Line 4419: GL_PERIOD_STATUSES PO_PS,

4415: GL_PS.PERIOD_NUM,
4416: GL_PS.QUARTER_NUM
4417: FROM
4418: GL_PERIOD_STATUSES GL_PS,
4419: GL_PERIOD_STATUSES PO_PS,
4420: GL_SETS_OF_BOOKS GL_SOB
4421: WHERE
4422: -- Join conditions:
4423: GL_SOB.set_of_books_id = p_set_of_books_id

Line 4461: GL_PERIOD_STATUSES GL_PS2

4457: GL_PS2.PERIOD_NUM ,
4458: GL_PS2.QUARTER_NUM,
4459: GL_PS2.START_DATE --
4460: FROM
4461: GL_PERIOD_STATUSES GL_PS2
4462: WHERE
4463: GL_PS2.set_of_books_id = p_set_of_books_id AND
4464: GL_PS2.application_id= 101 AND
4465: /* Bug 3967418 Start */

Line 4471: GL_PERIOD_STATUSES GL_PS

4467: /* Bug 3967418 End */
4468: GL_PS2.start_date=
4469: (SELECT min(gl_ps.start_date)
4470: FROM
4471: GL_PERIOD_STATUSES GL_PS
4472: , GL_PERIOD_STATUSES PO_PS
4473: , GL_SETS_OF_BOOKS GL_SOB
4474: WHERE
4475: -- Join conditions:

Line 4472: , GL_PERIOD_STATUSES PO_PS

4468: GL_PS2.start_date=
4469: (SELECT min(gl_ps.start_date)
4470: FROM
4471: GL_PERIOD_STATUSES GL_PS
4472: , GL_PERIOD_STATUSES PO_PS
4473: , GL_SETS_OF_BOOKS GL_SOB
4474: WHERE
4475: -- Join conditions:
4476: GL_SOB.set_of_books_id = p_set_of_books_id

Line 4516: GL_PERIOD_STATUSES GL_PS2

4512: GL_PS2.PERIOD_NUM ,
4513: GL_PS2.QUARTER_NUM,
4514: GL_PS2.START_DATE --
4515: FROM
4516: GL_PERIOD_STATUSES GL_PS2
4517: WHERE
4518: GL_PS2.set_of_books_id = p_set_of_books_id AND
4519: GL_PS2.application_id= 101 AND
4520: /* Bug 3967418 Start */

Line 4526: GL_PERIOD_STATUSES GL_PS

4522: /* Bug 3967418 End */
4523: GL_PS2.end_date=
4524: (SELECT max(gl_ps.end_date)
4525: FROM
4526: GL_PERIOD_STATUSES GL_PS
4527: , GL_PERIOD_STATUSES PO_PS
4528: , GL_SETS_OF_BOOKS GL_SOB
4529: WHERE
4530: -- Join conditions:

Line 4527: , GL_PERIOD_STATUSES PO_PS

4523: GL_PS2.end_date=
4524: (SELECT max(gl_ps.end_date)
4525: FROM
4526: GL_PERIOD_STATUSES GL_PS
4527: , GL_PERIOD_STATUSES PO_PS
4528: , GL_SETS_OF_BOOKS GL_SOB
4529: WHERE
4530: -- Join conditions:
4531: GL_SOB.set_of_books_id = p_set_of_books_id