[Home] [Help]
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
238: WHERE RH.REQUISITION_HEADER_ID = RL.REQUISITION_HEADER_ID
239: AND RH.TYPE_LOOKUP_CODE = 'PURCHASE'
240: AND NVL(RL.MODIFIED_BY_AGENT_FLAG,'N') = 'N'
241: AND RL.SOURCE_TYPE_CODE = 'VENDOR'
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
368: AND POL.PO_LINE_ID = PLL.PO_LINE_ID
369: AND PLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED','PLANNED')
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
497: where ap.invoice_id = aid.invoice_id
498: and aid.invoice_distribution_id = adl.invoice_distribution_id -- AP Lines change
499: and aid.invoice_id = adl.invoice_id
635: PA_COST_DISTRIBUTION_LINES_ALL PC,
636: GL_PERIOD_STATUSES GL,
637: PA_EXPENDITURE_ITEMS_ALL PE,
638: PA_EXPENDITURES_ALL PA,
639: PA_EXPENDITURE_TYPES PET
640: WHERE ADL.PROJECT_ID = x_project_id
641: AND ADL.AWARD_ID = x_award_id
642: AND ADL.ADL_STATUS = 'A'
643: AND NVL(ADL.FC_STATUS,'N') = 'A'
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,
668: gl_sets_of_books glsob,
669: pa_implementations imp
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
809: and adl.award_id = x_award_id
939: et.expenditure_category, -- Bug 2069132 ( RLMI Change)
940: et.revenue_category_code -- Bug 2069132 ( RLMI Change)
941: from /*pa_ind_rate_sch_revisions irsr, --for performance fix bug 5569067 */
942: --pa_cost_bases cb, --Bug 3630704 : Performance fix
943: pa_expenditure_types et,
944: pa_ind_cost_codes icc, /* Bug 5676410 */
945: pa_cost_base_exp_types cbet,
946: --pa_ind_rate_schedules_all_bg irs, --Bug 3630704 : Performance fix
947: pa_cost_base_cost_codes cbcc, /*for performance fix bug 5569067 */
1076: et.expenditure_category, -- Bug 2069132 ( RLMI Change)
1077: et.revenue_category_code -- Bug 2069132 ( RLMI Change)
1078: from --pa_ind_rate_sch_revisions irsr, /* Commented for bug 5689194 */
1079: --pa_cost_bases cb, --Bug 3630704 : Performance fix
1080: pa_expenditure_types et,
1081: pa_ind_cost_codes icc,
1082: pa_cost_base_exp_types cbet,
1083: --pa_ind_rate_schedules_all_bg irs, --Bug 3630704 : Performance fix
1084: pa_cost_base_cost_codes cbcc , /* added for bug 5689194 */
1224: et.expenditure_category, -- Bug 2069132 ( RLMI Change)
1225: et.revenue_category_code -- Bug 2069132 ( RLMI Change)
1226: from pa_ind_rate_sch_revisions irsr,
1227: --pa_cost_bases cb, --Bug 3630704 : Performance fix
1228: pa_expenditure_types et,
1229: pa_ind_cost_codes icc,
1230: pa_cost_base_exp_types cbet,
1231: --pa_ind_rate_schedules_all_bg irs, --Bug 3630704 : Performance fix
1232: pa_ind_compiled_sets ics,
1321:
1322: CURSOR C_group_by_none_cat is
1323: SELECT 'X'
1324: FROM pa_child_resources_v a,
1325: pa_expenditure_types b,
1326: pa_resource_lists c
1327: WHERE a.resource_list_id = x_res_list_id
1328: AND a.resource_type_name = 'Expenditure Category'
1329: AND a.resource_list_id = c.resource_list_id
1350: decode(sign(nvl(gms.entered_dr,0) - nvl(gms.entered_cr,0)),1,'D','I')
1351: from gms_bc_packets gms,
1352: gms_budget_versions bv,
1353: pa_budget_entry_methods pm,
1354: pa_expenditure_types TYPE,
1355: gms_encumbrance_items_all ei
1356: where gms.packet_id = x_packet_id
1357: and gms.budget_version_id = bv.budget_version_id
1358: and gms.document_type = 'ENC'
1376: decode(sign(nvl(gms.entered_dr,0) - nvl(gms.entered_cr,0)),1,'D','I')
1377: from gms_bc_packets gms,
1378: gms_budget_versions bv,
1379: pa_budget_entry_methods pm,
1380: pa_expenditure_types TYPE,
1381: pa_expenditure_items_all ei
1382: where gms.packet_id = x_packet_id
1383: and gms.budget_version_id = bv.budget_version_id
1384: and gms.document_type = 'EXP'
1497: SELECT DISTINCT tp.attribute2,
1498: tp.attribute3
1499: INTO x_non_labor_resource,
1500: x_non_labor_resource_org_id
1501: FROM pa_expenditure_types tp,
1502: gms_bc_packets bc
1503: WHERE bc.packet_id = x_packet_id
1504: AND bc.bc_packet_id = x_bc_packet_id
1505: AND tp.expenditure_type = bc.expenditure_type;