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 1486: -- po_distributions_all pod

1482: select adl.ind_compiled_set_id
1483: into l_compiled_set_id
1484: from gms_award_distributions adl
1485: -- R12 Funds Managment Uptake : Obsolete Ap/PO/REQ usage as its not required
1486: -- po_distributions_all pod
1487: where adl.award_id = x_award_id
1488: and adl.task_id = x_task_id
1489: and adl.po_distribution_id = x_document_distribution_id
1490: and adl.document_type = 'PO'

Line 2521: FROM po_distributions_all pod,

2517: cursor po_dist_records is
2518: select nvl(adl.burdenable_raw_cost,0) ,
2519: adl.award_set_id award_set_id,
2520: adl_line_num adl_line_num
2521: FROM po_distributions_all pod,
2522: gms_award_distributions adl
2523: where adl.award_set_id = pod.award_id
2524: AND adl.po_distribution_id = pod.po_distribution_id
2525: and adl.adl_status = 'A'

Line 4776: po_distributions_all po

4772: --
4773: select adl.ind_compiled_set_id
4774: into x_ind_compiled_set_id
4775: from gms_award_distributions adl,
4776: po_distributions_all po
4777: where po.po_distribution_id = x_distribution_id
4778: and po.award_id = adl.award_set_id
4779: and adl.adl_line_num = 1 ;
4780:

Line 4876: po_distributions_all po

4872: --
4873: select adl.burdenable_raw_cost
4874: into x_burdenable_raw_cost
4875: from gms_award_distributions adl,
4876: po_distributions_all po
4877: where po.po_distribution_id = x_distribution_id
4878: and po.award_id = adl.award_set_id
4879: and adl.adl_line_num = 1 ;
4880: