APPS.GMS_COST_PLUS_EXTN dependencies on PO_DISTRIBUTIONS_ALL

Line 326: -- 4004559 - PJ.M:B8:P13:OTH:PERF: FULL TABLE SCAN COST ON PO_DISTRIBUTIONS_ALL EXCEEDS 5

322: and pod.award_id = adl.award_set_id
323: and adl.adl_line_num = 1
324: and adl.po_distribution_id = pod.po_distribution_id
325: --
326: -- 4004559 - PJ.M:B8:P13:OTH:PERF: FULL TABLE SCAN COST ON PO_DISTRIBUTIONS_ALL EXCEEDS 5
327: -- gms_budget_versions criteria was added so that index can be used.
328: -- and full table scan on po_distributions_all is gone.
329: --
330: and pod.project_id in ( select gbv.project_id

Line 328: -- and full table scan on po_distributions_all is gone.

324: and adl.po_distribution_id = pod.po_distribution_id
325: --
326: -- 4004559 - PJ.M:B8:P13:OTH:PERF: FULL TABLE SCAN COST ON PO_DISTRIBUTIONS_ALL EXCEEDS 5
327: -- gms_budget_versions criteria was added so that index can be used.
328: -- and full table scan on po_distributions_all is gone.
329: --
330: and pod.project_id in ( select gbv.project_id
331: from gms_budget_versions gbv
332: where gbv.budget_type_code = 'AC'

Line 1219: -- po_distributions_all pod

1215: select adl.ind_compiled_set_id
1216: into l_compiled_set_id
1217: from gms_award_distributions adl
1218: -- R12 Funds Managment Uptake : Obsolete Ap/PO/REQ usage as its not required
1219: -- po_distributions_all pod
1220: where adl.award_id = x_award_id
1221: and adl.task_id = x_task_id
1222: and adl.po_distribution_id = x_document_distribution_id
1223: and adl.document_type = 'PO'

Line 2254: FROM po_distributions_all pod,

2250: cursor po_dist_records is
2251: select nvl(adl.burdenable_raw_cost,0) ,
2252: adl.award_set_id award_set_id,
2253: adl_line_num adl_line_num
2254: FROM po_distributions_all pod,
2255: gms_award_distributions adl
2256: where adl.award_set_id = pod.award_id
2257: AND adl.po_distribution_id = pod.po_distribution_id
2258: and adl.adl_status = 'A'

Line 4386: po_distributions_all po

4382: --
4383: select adl.ind_compiled_set_id
4384: into x_ind_compiled_set_id
4385: from gms_award_distributions adl,
4386: po_distributions_all po
4387: where po.po_distribution_id = x_distribution_id
4388: and po.award_id = adl.award_set_id
4389: and adl.adl_line_num = 1 ;
4390:

Line 4455: po_distributions_all po

4451: --
4452: select adl.burdenable_raw_cost
4453: into x_burdenable_raw_cost
4454: from gms_award_distributions adl,
4455: po_distributions_all po
4456: where po.po_distribution_id = x_distribution_id
4457: and po.award_id = adl.award_set_id
4458: and adl.adl_line_num = 1 ;
4459: