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 5455: ( select /+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) / --Bug Fix: 3634912 added hint

5451: , CREATED_BY
5452: , LAST_UPDATE_DATE
5453: , LAST_UPDATED_BY
5454: , LAST_UPDATE_LOGIN )
5455: ( select /*+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) */ --Bug Fix: 3634912 added hint
5456: part.run_id
5457: ,part.rule_id
5458: ,part.line_num
5459: ,part.project_id

Line 5485: pa_resource_accum_details prad,

5481: ,G_last_update_login
5482: from ----Bug Fix: 3634912 :Changed the order of the tables
5483: pa_alloc_run_targets part,
5484: pa_alloc_run_resource_det parr,
5485: pa_resource_accum_details prad,
5486: pa_txn_accum pta
5487: where pta.txn_accum_id = prad.txn_accum_id
5488: and prad.Resource_list_member_id = parr.resource_list_member_id
5489: and prad.Project_id = part.project_id

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

5637: , CREATED_BY
5638: , LAST_UPDATE_DATE
5639: , LAST_UPDATED_BY
5640: , LAST_UPDATE_LOGIN )
5641: ( select /*+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) */ --Bug Fix: 3634912 added hint
5642: part.run_id
5643: ,part.rule_id
5644: ,part.line_num
5645: ,part.project_id

Line 5670: pa_resource_accum_details prad,

5666: ,G_last_update_login
5667: from --Bug Fix: 3634912 : Changed the order of the tables.
5668: pa_alloc_run_targets part,
5669: pa_alloc_run_resource_det parr,
5670: pa_resource_accum_details prad,
5671: pa_txn_accum pta
5672: where pta.txn_accum_id = prad.txn_accum_id
5673: and prad.Resource_list_member_id = parr.resource_list_member_id
5674: and pta.Project_id = part.project_id

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

5772: , CREATED_BY
5773: , LAST_UPDATE_DATE
5774: , LAST_UPDATED_BY
5775: , LAST_UPDATE_LOGIN )
5776: ( select /*+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) */ --Bug Fix: 3634912 added hint
5777: part.run_id
5778: ,part.rule_id
5779: ,part.line_num
5780: ,part.project_id

Line 5805: pa_resource_accum_details prad,

5801: ,G_last_update_login
5802: from --Bug Fix: 3634912 : Changed the order of tables
5803: pa_alloc_run_targets part,
5804: pa_alloc_run_resource_det parr,
5805: pa_resource_accum_details prad,
5806: pa_txn_accum pta
5807: where pta.txn_accum_id = prad.txn_accum_id
5808: and prad.Resource_list_member_id = parr.resource_list_member_id
5809: and pta.Project_id = part.project_id

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

5938: , CREATED_BY
5939: , LAST_UPDATE_DATE
5940: , LAST_UPDATED_BY
5941: , LAST_UPDATE_LOGIN )
5942: ( select /*+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) */ -- Bug Fix: 3634912 added hint
5943: part.run_id
5944: ,part.rule_id
5945: ,part.line_num
5946: ,part.project_id

Line 5972: pa_resource_accum_details prad,

5968: ,G_last_update_login
5969: from -- Bug Fix: 3634912 : Changed the order of tables.
5970: pa_alloc_run_targets part,
5971: pa_alloc_run_resource_det parr,
5972: pa_resource_accum_details prad,
5973: pa_txn_accum pta
5974: where pta.txn_accum_id = prad.txn_accum_id
5975: and prad.Resource_list_member_id = parr.resource_list_member_id
5976: and prad.Project_id = part.project_id

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

6191: , CREATED_BY
6192: , LAST_UPDATE_DATE
6193: , LAST_UPDATED_BY
6194: , LAST_UPDATE_LOGIN )
6195: ( select /*+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) */ --Bug Fix: 3634912 added hint
6196: pars.run_id
6197: ,pars.rule_id
6198: ,pars.line_num
6199: ,pars.project_id

Line 6239: pa_resource_accum_details prad,

6235: ,G_last_update_login
6236: from --Bug Fix: 3634912 : Changed the order of the tables.
6237: pa_alloc_run_sources pars,
6238: pa_alloc_run_resource_det parr,
6239: pa_resource_accum_details prad,
6240: pa_txn_accum pta
6241: where pta.txn_accum_id = prad.txn_accum_id
6242: and prad.Resource_list_member_id = parr.resource_list_member_id
6243: and prad.Project_id = pars.project_id

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

6409: , CREATED_BY
6410: , LAST_UPDATE_DATE
6411: , LAST_UPDATED_BY
6412: , LAST_UPDATE_LOGIN )
6413: ( select /*+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) */ -- Bug Fix: 3634912 added hint
6414: pars.run_id
6415: ,pars.rule_id
6416: ,pars.line_num
6417: ,pars.project_id

Line 6455: pa_resource_accum_details prad,

6451: ,G_last_update_login
6452: from -- Bug Fix: 3634912 :Changed the order of the tables.
6453: pa_alloc_run_sources pars,
6454: pa_alloc_run_resource_det parr,
6455: pa_resource_accum_details prad,
6456: pa_txn_accum pta
6457: where pta.txn_accum_id = prad.txn_accum_id
6458: and prad.Resource_list_member_id = parr.resource_list_member_id
6459: and pta.Project_id = pars.project_id

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

6572: , CREATED_BY
6573: , LAST_UPDATE_DATE
6574: , LAST_UPDATED_BY
6575: , LAST_UPDATE_LOGIN )
6576: ( select /*+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) */ --Bug Fix: 3634912 added hint
6577: pars.run_id
6578: ,pars.rule_id
6579: ,pars.line_num
6580: ,pars.project_id

Line 6618: pa_resource_accum_details prad,

6614: ,G_last_update_login
6615: from --Bug Fix: 3634912 : Changed the order of the tables.
6616: pa_alloc_run_sources pars,
6617: pa_alloc_run_resource_det parr,
6618: pa_resource_accum_details prad,
6619: pa_txn_accum pta
6620: where pta.txn_accum_id = prad.txn_accum_id
6621: and prad.Resource_list_member_id = parr.resource_list_member_id
6622: and pta.Project_id = pars.project_id

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

6767: , CREATED_BY
6768: , LAST_UPDATE_DATE
6769: , LAST_UPDATED_BY
6770: , LAST_UPDATE_LOGIN )
6771: ( select /*+ ORDERED INDEX (prad, PA_RESOURCE_ACCUM_DETAILS_N2) */ --Bug Fix: 3634912 added hint
6772: pars.run_id
6773: ,pars.rule_id
6774: ,pars.line_num
6775: ,pars.project_id

Line 6815: pa_resource_accum_details prad,

6811: ,G_last_update_login
6812: from --Bug Fix: 3634912 : Changed the order of the tables
6813: pa_alloc_run_sources pars,
6814: pa_alloc_run_resource_det parr,
6815: pa_resource_accum_details prad,
6816: pa_txn_accum pta
6817: where pta.txn_accum_id = prad.txn_accum_id
6818: and prad.Resource_list_member_id = parr.resource_list_member_id
6819: and prad.Project_id = pars.project_id

Line 7169: pa_resource_accum_details prad

7165: 0
7166: )),0)
7167: from pa_txn_accum pta,
7168: pa_periods pp,
7169: pa_resource_accum_details prad
7170: where pta.txn_accum_id = prad.txn_accum_id
7171: and prad. Resource_list_member_id = p_rlm_id
7172: and prad. Project_id = p_project_id
7173: and prad.task_id = p_task_id

Line 7193: pa_resource_accum_details prad

7189: +nvl(pta.i_tot_quantity,0),
7190: 0
7191: )),0)
7192: from pa_txn_accum pta,
7193: pa_resource_accum_details prad
7194: where pta.txn_accum_id = prad.txn_accum_id
7195: and prad. Resource_list_member_id = p_rlm_id
7196: and prad. Project_id = p_project_id
7197: and prad.task_id = p_task_id

Line 7216: pa_resource_accum_details prad

7212: 0
7213: )),0)
7214: from pa_txn_accum pta,
7215: pa_periods pp ,
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