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.PA_ALLOC_RUN dependencies on GL_PERIOD_STATUSES

Line 5520: /* Using gl_period_statuses instead of pa_periods for Bug 2757875 */

5516: and parr.member_type = 'B'
5517: and part.project_id = c_projects_rec.project_id
5518: and part.exclude_flag = 'N'
5519: and exists
5520: /* Using gl_period_statuses instead of pa_periods for Bug 2757875 */
5521: (select /*+ NO_UNNEST */ -- Bug Fix: 3634912 added hint
5522: gl.period_name
5523: from gl_period_statuses gl,
5524: pa_implementations imp

Line 5523: from gl_period_statuses gl,

5519: and exists
5520: /* Using gl_period_statuses instead of pa_periods for Bug 2757875 */
5521: (select /*+ NO_UNNEST */ -- Bug Fix: 3634912 added hint
5522: gl.period_name
5523: from gl_period_statuses gl,
5524: pa_implementations imp
5525: where pta.gl_period = gl.period_name
5526: and gl.set_of_books_id = imp.set_of_books_id
5527: and gl.application_id = pa_period_process_pkg.application_id

Line 5605: from gl_period_statuses gl,

5601: and part.project_id = c_projects_rec.project_id
5602: and part.exclude_flag = 'N'
5603: and exists
5604: ( select gl.period_name
5605: from gl_period_statuses gl,
5606: pa_implementations imp
5607: where pta.gl_period = gl.period_name
5608: and gl.set_of_books_id = imp.set_of_books_id
5609: and gl.application_id = pa_period_process_pkg.application_id

Line 6274: /* Using gl_period_statuses instead of pa_periods for bug 2757875 */

6270: and parr.member_type = 'S'
6271: and pars.project_id = c_projects_rec.project_id
6272: and pars.exclude_flag = 'N'
6273: and exists
6274: /* Using gl_period_statuses instead of pa_periods for bug 2757875 */
6275: (select /*+ NO_UNNEST */ -- Bug Fix: 3634912 added hint
6276: gl.period_name
6277: From gl_period_statuses gl,
6278: pa_implementations imp

Line 6277: From gl_period_statuses gl,

6273: and exists
6274: /* Using gl_period_statuses instead of pa_periods for bug 2757875 */
6275: (select /*+ NO_UNNEST */ -- Bug Fix: 3634912 added hint
6276: gl.period_name
6277: From gl_period_statuses gl,
6278: pa_implementations imp
6279: where pta.gl_period = gl.period_name
6280: and gl.set_of_books_id = imp.set_of_books_id
6281: and gl.application_id = pa_period_process_pkg.application_id

Line 6376: From gl_period_statuses gl,

6372: and pars.project_id = C_projects_rec.project_id
6373: and pars.exclude_flag = 'N'
6374: and Exists
6375: (select gl.period_name
6376: From gl_period_statuses gl,
6377: pa_implementations imp
6378: where pta.gl_period = gl.period_name
6379: and gl.set_of_books_id = imp.set_of_books_id
6380: and gl.application_id = pa_period_process_pkg.application_id

Line 7611: /* Commenting out pa_periods for bug 2757875 and using gl_period_statuses instead */

7607: +nvl(pta.i_tot_burdened_cost,0),
7608: 0) * v_pool_percent ) )
7609: from pa_alloc_txn_accum_v pta,
7610: /* FP.M : Allocation Impact : pa_txn_accum pta */
7611: /* Commenting out pa_periods for bug 2757875 and using gl_period_statuses instead */
7612: -- pa_periods pp ,
7613: gl_period_statuses gl ,
7614: pa_implementations imp
7615: /* pa_alloc_run_sources pars */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */

Line 7613: gl_period_statuses gl ,

7609: from pa_alloc_txn_accum_v pta,
7610: /* FP.M : Allocation Impact : pa_txn_accum pta */
7611: /* Commenting out pa_periods for bug 2757875 and using gl_period_statuses instead */
7612: -- pa_periods pp ,
7613: gl_period_statuses gl ,
7614: pa_implementations imp
7615: /* pa_alloc_run_sources pars */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */
7616: where /* Bug 3749469
7617: pars.rule_id = p_rule_id

Line 8305: /* Commenting out pa_periods and using gl_period_statuses instead for bug 2757875 */

8301: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
8302: +nvl(pta.i_tot_quantity,0),
8303: 0 )) AMOUNT
8304: from pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta, */
8305: /* Commenting out pa_periods and using gl_period_statuses instead for bug 2757875 */
8306: -- pa_periods pp ,
8307: gl_period_statuses gl,
8308: pa_implementations imp
8309: /* pa_alloc_run_targets part */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */

Line 8307: gl_period_statuses gl,

8303: 0 )) AMOUNT
8304: from pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta, */
8305: /* Commenting out pa_periods and using gl_period_statuses instead for bug 2757875 */
8306: -- pa_periods pp ,
8307: gl_period_statuses gl,
8308: pa_implementations imp
8309: /* pa_alloc_run_targets part */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */
8310: where /* Bug 3749469 part.rule_id = p_rule_id
8311: and part.run_id = p_run_id