[Home] [Help]
229: rd.requisition_line_id,
230: rh.requisition_header_id,
231: rl.vendor_id
232: from po_req_distributions_all rd,
233: gms_award_distributions adl,
234: po_requisition_lines_all rl,
235: po_requisition_headers_all rh,
236: gl_period_statuses gps,
237: pa_expenditure_types pet
359: po_lines_all pol,
360: po_line_locations_all pll,
361: po_releases_all por,
362: po_distributions_all pod,
363: gms_award_distributions adl,
364: gl_period_statuses gps,
365: pa_expenditure_types pet
366: WHERE POH.TYPE_LOOKUP_CODE IN ('STANDARD','BLANKET','PLANNED')
367: AND POL.PO_HEADER_ID = POH.PO_HEADER_ID
488: pet.expenditure_category,
489: pet.revenue_category_code,
490: adl.ind_compiled_set_id -- Bug 2387678 (Performance Tuning)
491: from ap_invoices_all ap,
492: gms_award_distributions adl,
493: ap_invoice_distributions aid,
494: gl_period_statuses gps,
495: pa_expenditure_types pet,
496: gl_ledgers g
630: /* Changed the order of queries and
631: removed join with tables
632: gl_date_period_map map,
633: gl_sets_of_books glsob and pa_implementations imp for bug# 6043224 */
634: FROM GMS_AWARD_DISTRIBUTIONS ADL,
635: PA_COST_DISTRIBUTION_LINES_ALL PC,
636: GL_PERIOD_STATUSES GL,
637: PA_EXPENDITURE_ITEMS_ALL PE,
638: PA_EXPENDITURES_ALL PA,
659: pa_expenditures_all pa,
660: pa_cost_distribution_lines_all pc,
661: gl_period_STATUSES gl,
662: -- pa_tasks task, -- commented for Bug:1703510
663: gms_award_distributions adl,
664: --pa_periods pp, -- Bug 2887849, EPP changes
665: pa_expenditure_types pet, -- Bug 2069132 (RLMI Change)
666: -- Added the joins with the tables for Bug 5569067
667: gl_date_period_map map,
800: from gms_encumbrance_items_all gei,
801: gms_encumbrances_all ge,
802: gl_period_STATUSES gl,
803: --pa_tasks task, -- commented out NOCOPY for porting bug:1703510
804: gms_award_distributions adl,
805: pa_expenditure_types pet -- Bug 2069132 (RLMI Change)
806: -- where task.project_id = x_project_id -- commented out NOCOPY for porting bug:1703510
807: -- and gei.task_id = task.task_id -- commented out NOCOPY for porting bug:1703510
808: where adl.project_id = x_project_id -- added for the above bug
2212:
2213: CURSOR c_get_quantity_invoiced IS
2214: SELECT nvl(sum(aid.quantity_invoiced),0)
2215: FROM ap_invoice_distributions aid,
2216: gms_award_distributions adl
2217: WHERE aid.po_distribution_id = p_po_distribution_id
2218: AND aid.distribution_line_number = adl.distribution_line_number
2219: AND aid.invoice_distribution_id = adl.invoice_distribution_id -- AP Lines change
2220: AND aid.invoice_id = adl.invoice_id