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

Line 5478: ( select --/+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) / --Bug Fix: 3634912 added hint Bug 9054701 removed hint

5474: , CREATED_BY
5475: , LAST_UPDATE_DATE
5476: , LAST_UPDATED_BY
5477: , LAST_UPDATE_LOGIN )
5478: ( select --/*+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) */ --Bug Fix: 3634912 added hint Bug 9054701 removed hint
5479: part.run_id
5480: ,part.rule_id
5481: ,part.line_num
5482: ,part.project_id

Line 5508: pa_resource_accum_details prad,

5504: ,G_last_update_login
5505: from ----Bug Fix: 3634912 :Changed the order of the tables
5506: pa_alloc_run_targets part,
5507: pa_alloc_run_resource_det parr,
5508: pa_resource_accum_details prad,
5509: pa_txn_accum pta
5510: where pta.txn_accum_id = prad.txn_accum_id
5511: and prad.Resource_list_member_id = parr.resource_list_member_id
5512: and prad.Project_id = part.project_id

Line 5664: ( select --/+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) / --Bug Fix: 3634912 added hint Bug 9054701 removed hint

5660: , CREATED_BY
5661: , LAST_UPDATE_DATE
5662: , LAST_UPDATED_BY
5663: , LAST_UPDATE_LOGIN )
5664: ( select --/*+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) */ --Bug Fix: 3634912 added hint Bug 9054701 removed hint
5665: part.run_id
5666: ,part.rule_id
5667: ,part.line_num
5668: ,part.project_id

Line 5693: pa_resource_accum_details prad,

5689: ,G_last_update_login
5690: from --Bug Fix: 3634912 : Changed the order of the tables.
5691: pa_alloc_run_targets part,
5692: pa_alloc_run_resource_det parr,
5693: pa_resource_accum_details prad,
5694: pa_txn_accum pta
5695: where pta.txn_accum_id = prad.txn_accum_id
5696: and prad.Resource_list_member_id = parr.resource_list_member_id
5697: and pta.Project_id = part.project_id

Line 5799: ( select --/+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) / --Bug Fix: 3634912 added hint Bug 9054701 removed hint

5795: , CREATED_BY
5796: , LAST_UPDATE_DATE
5797: , LAST_UPDATED_BY
5798: , LAST_UPDATE_LOGIN )
5799: ( select --/*+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) */ --Bug Fix: 3634912 added hint Bug 9054701 removed hint
5800: part.run_id
5801: ,part.rule_id
5802: ,part.line_num
5803: ,part.project_id

Line 5828: pa_resource_accum_details prad,

5824: ,G_last_update_login
5825: from --Bug Fix: 3634912 : Changed the order of tables
5826: pa_alloc_run_targets part,
5827: pa_alloc_run_resource_det parr,
5828: pa_resource_accum_details prad,
5829: pa_txn_accum pta
5830: where pta.txn_accum_id = prad.txn_accum_id
5831: and prad.Resource_list_member_id = parr.resource_list_member_id
5832: and pta.Project_id = part.project_id

Line 5965: ( select --/+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) / -- Bug Fix: 3634912 added hint Bug 9054701 removed hint

5961: , CREATED_BY
5962: , LAST_UPDATE_DATE
5963: , LAST_UPDATED_BY
5964: , LAST_UPDATE_LOGIN )
5965: ( select --/*+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) */ -- Bug Fix: 3634912 added hint Bug 9054701 removed hint
5966: part.run_id
5967: ,part.rule_id
5968: ,part.line_num
5969: ,part.project_id

Line 5995: pa_resource_accum_details prad,

5991: ,G_last_update_login
5992: from -- Bug Fix: 3634912 : Changed the order of tables.
5993: pa_alloc_run_targets part,
5994: pa_alloc_run_resource_det parr,
5995: pa_resource_accum_details prad,
5996: pa_txn_accum pta
5997: where pta.txn_accum_id = prad.txn_accum_id
5998: and prad.Resource_list_member_id = parr.resource_list_member_id
5999: and prad.Project_id = part.project_id

Line 6218: ( select --/+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) / --Bug Fix: 3634912 added hint Bug 9054701 removed hint

6214: , CREATED_BY
6215: , LAST_UPDATE_DATE
6216: , LAST_UPDATED_BY
6217: , LAST_UPDATE_LOGIN )
6218: ( select --/*+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) */ --Bug Fix: 3634912 added hint Bug 9054701 removed hint
6219: pars.run_id
6220: ,pars.rule_id
6221: ,pars.line_num
6222: ,pars.project_id

Line 6262: pa_resource_accum_details prad,

6258: ,G_last_update_login
6259: from --Bug Fix: 3634912 : Changed the order of the tables.
6260: pa_alloc_run_sources pars,
6261: pa_alloc_run_resource_det parr,
6262: pa_resource_accum_details prad,
6263: pa_txn_accum pta
6264: where pta.txn_accum_id = prad.txn_accum_id
6265: and prad.Resource_list_member_id = parr.resource_list_member_id
6266: and prad.Project_id = pars.project_id

Line 6436: ( select --/+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) / -- Bug Fix: 3634912 added hint Bug 9054701 removed hint

6432: , CREATED_BY
6433: , LAST_UPDATE_DATE
6434: , LAST_UPDATED_BY
6435: , LAST_UPDATE_LOGIN )
6436: ( select --/*+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) */ -- Bug Fix: 3634912 added hint Bug 9054701 removed hint
6437: pars.run_id
6438: ,pars.rule_id
6439: ,pars.line_num
6440: ,pars.project_id

Line 6478: pa_resource_accum_details prad,

6474: ,G_last_update_login
6475: from -- Bug Fix: 3634912 :Changed the order of the tables.
6476: pa_alloc_run_sources pars,
6477: pa_alloc_run_resource_det parr,
6478: pa_resource_accum_details prad,
6479: pa_txn_accum pta
6480: where pta.txn_accum_id = prad.txn_accum_id
6481: and prad.Resource_list_member_id = parr.resource_list_member_id
6482: and pta.Project_id = pars.project_id

Line 6599: ( select --/+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) / --Bug Fix: 3634912 added hint Bug 9054701 removed hint

6595: , CREATED_BY
6596: , LAST_UPDATE_DATE
6597: , LAST_UPDATED_BY
6598: , LAST_UPDATE_LOGIN )
6599: ( select --/*+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) */ --Bug Fix: 3634912 added hint Bug 9054701 removed hint
6600: pars.run_id
6601: ,pars.rule_id
6602: ,pars.line_num
6603: ,pars.project_id

Line 6641: pa_resource_accum_details prad,

6637: ,G_last_update_login
6638: from --Bug Fix: 3634912 : Changed the order of the tables.
6639: pa_alloc_run_sources pars,
6640: pa_alloc_run_resource_det parr,
6641: pa_resource_accum_details prad,
6642: pa_txn_accum pta
6643: where pta.txn_accum_id = prad.txn_accum_id
6644: and prad.Resource_list_member_id = parr.resource_list_member_id
6645: and pta.Project_id = pars.project_id

Line 6794: ( select --/+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) / --Bug Fix: 3634912 added hint Bug 9054701 removed hint

6790: , CREATED_BY
6791: , LAST_UPDATE_DATE
6792: , LAST_UPDATED_BY
6793: , LAST_UPDATE_LOGIN )
6794: ( select --/*+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) */ --Bug Fix: 3634912 added hint Bug 9054701 removed hint
6795: pars.run_id
6796: ,pars.rule_id
6797: ,pars.line_num
6798: ,pars.project_id

Line 6838: pa_resource_accum_details prad,

6834: ,G_last_update_login
6835: from --Bug Fix: 3634912 : Changed the order of the tables
6836: pa_alloc_run_sources pars,
6837: pa_alloc_run_resource_det parr,
6838: pa_resource_accum_details prad,
6839: pa_txn_accum pta
6840: where pta.txn_accum_id = prad.txn_accum_id
6841: and prad.Resource_list_member_id = parr.resource_list_member_id
6842: and prad.Project_id = pars.project_id

Line 7192: pa_resource_accum_details prad

7188: 0
7189: )),0)
7190: from pa_txn_accum pta,
7191: pa_periods pp,
7192: pa_resource_accum_details prad
7193: where pta.txn_accum_id = prad.txn_accum_id
7194: and prad. Resource_list_member_id = p_rlm_id
7195: and prad. Project_id = p_project_id
7196: and prad.task_id = p_task_id

Line 7216: pa_resource_accum_details prad

7212: +nvl(pta.i_tot_quantity,0),
7213: 0
7214: )),0)
7215: from pa_txn_accum pta,
7216: pa_resource_accum_details prad
7217: where pta.txn_accum_id = prad.txn_accum_id
7218: and prad. Resource_list_member_id = p_rlm_id
7219: and prad. Project_id = p_project_id
7220: and prad.task_id = p_task_id

Line 7239: pa_resource_accum_details prad

7235: 0
7236: )),0)
7237: from pa_txn_accum pta,
7238: pa_periods pp ,
7239: pa_resource_accum_details prad
7240: where pta.txn_accum_id = prad.txn_accum_id
7241: and prad. Resource_list_member_id = p_rlm_id
7242: and prad. Project_id = p_project_id
7243: and prad.task_id = p_task_id