Home » SQL & PL/SQL » SQL & PL/SQL » Need Help with Query to break down a combination
Need Help with Query to break down a combination [message #254445] Thu, 26 July 2007 14:47 Go to next message
californiagirl
Messages: 79
Registered: May 2007
Member
Hi All,

I am creating a sql*plus report, but the current query which I am using is simply not reporting the financial information correctly. It is reporting the information strictly at a project summary level and not breaking the expenditures, revenue, budget, etc down to the project/task/award level. I just need the 3 combinations level: project, task and award levels. Any suggestions on how to change this in the query or sql plus report?


/*  APPAXP.sql  Project Expenditures Report 
Program takes six parameters#
##1		from period
##2		to period
##3		from project org number
##4		to project org number   
##5		from project number
##6		to project number  
##7		from natural account
##8		to natural account 
*/
set termout off
set head off
set pages 0
set feedback off
set verify off
set lines 2000
set define #

--Don’t repeat column values
BREAK ON segment1 NODUPLICATES ON task_id NODUPLICATES

--format columns
col start_date noprint new_value s_date
col	end_date   noprint new_value e_date
col	err_msg	   noprint new_value err_message
col sort_col noprint

SELECT  s.start_date,
		e.end_date,
		decode(sign(e.end_date - s.start_date),-1,'*** Note:  From Period is later than To Period, no expenditures reported ***') err_msg
FROM	apps.pa_periods s,
		apps.pa_periods e
WHERE  	s.period_name(+) = '##1'
and		e.period_name(+) = '##2';

set termout on

--Execute the query to generate the report  
SELECT 'AP Project Expenditures for Dates ##s_date - ##e_date, Project Organizations ##3 - ##4, Projects ##5 - ##6 and Accounts ##7 - ##8',
	   0 	sort_col   
FROM   DUAL
UNION 
SELECT '##err_message', 1
FROM   DUAL
UNION 
SELECT 'Project Number^Project Start Date^Project End Date^Status^Project Manager^Responsible Accountant^Task Number^'||
	   'Task Start Date^Task Completion Date^Task Manager^Award Number^Award Short Name^Project Organization^'||
	   'Task Organization^Expense Code^OMB Code^Revenue Line^Burden Rate^Burden Structure^Site^Sponsor^Type^Customer^'||
	   'Award Type^Award Purpose^Federal Flow Thru Code^IDC Schedule Name^Total Expenditure^Direct Charges^'||
	   'Indirect Charges^Cost Share Charges^Total Commitments^Direct Commitments^Indirect Commitments^Cost Share Commitments^'||
	   'Total Invoiced^Total Revenue^Total Funding^'||
	   'Total Budget^Direct Budget^Indirect Budget^Cost Share Budget',
	   2 	   
FROM   DUAL
UNION
select distinct
	   p.segment1||'^'||
	   p.START_DATE||'^'||
	   p.COMPLETION_DATE||'^'||
	   p.PROJECT_STATUS_CODE||'^'||
	   m.FULL_NAME||'^'||
	   ra.FULL_NAME||'^'||
	   t.task_number||'^'||
	   t.START_DATE||'^'||
	   t.COMPLETION_DATE||'^'||
	   tm.full_name||'^'||
	   a.AWARD_NUMBER||'^'||
	   rtrim(translate(a.AWARD_SHORT_NAME,chr(10),' '))||'^'||
	   o1.name||'^'||
	   o2.name||'^'||
	   nvl(c1.class_code,' ')||'^'||
	   nvl(c2.class_code,' ')||'^'||
	   nvl(c3.class_code,' ')||'^'||
	   nvl(c4.class_code,' ')||'^'||
	   nvl(c5.class_code,' ')||'^'||
	   nvl(c6.class_code,' ')||'^'||
	   nvl(c7.class_code,' ')||'^'||
	   nvl(c8.class_code,' ')||'^'||
	   c.CUSTOMER_NAME||'^'||
	   a.type||'^'||
	   a.Award_Purpose_code||'^'||
	   a.attribute10||'^'||
	   i.IND_RATE_SCH_NAME||'^'||
	   e.total_exp||'^'||
	   e.dir_exp||'^'||
	   e.ind_exp||'^'||
	   e.cs_exp||'^'||
	   ct.tot_commit||'^'||
	   ct.dir_commit||'^'||
	   ct.ind_commit||'^'||
	   ct.cs_commit||'^'||
	   e.billed||'^'||
	   e.rev||'^'||
	   f.funding||'^'||
	   b.budget_total||'^'||
	   b.direct_budget||'^'||
	   b.indirect_budget||'^'||
	   b.cs_budget,
	   3
from	
	  (select gra.PROJECT_ID,
	   		  gra.TASK_ID,
	   		  gra.BUDGET_VERSION_ID,
	   		  sum(bl.BURDENED_COST) budget_total,
	   		  sum(decode(substr(r.name,1,10) ,'Award Reve',nvl(bl.BURDENED_COST,0),
	   					 'F & A Cost',nvl(bl.BURDENED_COST,0),0)) indirect_budget,
	   		  sum(decode(substr(r.name,1,10) ,'Award Reve',0,
	   					 'F & A Cost',0,
						 'Cost Share',0, 
						 nvl(bl.BURDENED_COST,0))) direct_budget,
	          sum(decode(substr(r.name,1,10),
						 'Cost Share',nvl(bl.BURDENED_COST,0),0)) cs_budget
	   from   apps.GMS_RESOURCE_ASSIGNMENTS gra,
	   		  apps.gms_budget_lines bl,
	   		  apps.PA_RESOURCE_LIST_MEMBERS rlm,
	   		  apps.PA_RESOURCES r
	   where  rlm.RESOURCE_ID = r.resource_id
and	   gra.RESOURCE_LIST_MEMBER_ID = rlm.RESOURCE_LIST_MEMBER_ID
and	   bl.RESOURCE_ASSIGNMENT_ID = gra.RESOURCE_ASSIGNMENT_ID
and	   gra.budget_version_id in
	   (select max(bv.budget_version_id)
	   from	   gms.gms_budget_versions bv
	   where   bv.PROJECT_ID = gra.PROJECT_ID)
group by
 	  gra.PROJECT_ID,
	  gra.TASK_ID,
	  gra.BUDGET_VERSION_ID) b,
(SELECT 
	pct.project_id,
	pct.TASK_ID, 
	SUM(pct.tot_cmt_burdened_cost)  tot_commit,
    SUM(DECODE(pct.expenditure_category,  
			'F & A Costs',0,
			'Cost Share',0,
			nvl(pct.tot_cmt_burdened_cost,0))) dir_commit,
    SUM(DECODE(pct.expenditure_category,  
			'F & A Costs',nvl(pct.tot_cmt_burdened_cost,0),0)) ind_commit,
    SUM(DECODE(pct.expenditure_category,  
			'Cost Share',nvl(pct.tot_cmt_burdened_cost,0),0)) cs_commit
FROM apps.pa_commitment_txns pct
GROUP BY
	pct.project_id,
	pct.TASK_ID) ct,
(SELECT	gmsac.project_id,
		gmsac.task_id,
		SUM(cdl.PROJECT_BURDENED_COST) total_exp,
		SUM(DECODE(SUBSTR(et.expenditure_category,1,10),'F & A Cost',0,
		'Cost Share',0,
		NVL(gmsac.burdened_cost,0))) dir_exp,
		SUM(DECODE(SUBSTR(et.expenditure_category,1,10),'F & A Cost',NVL(cdl.PROJECT_BURDENED_COST,0),0)) ind_exp,
		SUM(DECODE(SUBSTR(et.expenditure_category,1,10),'Cost Share',NVL(cdl.PROJECT_BURDENED_COST,0),0)) cs_exp,
    	SUM(NVL(gmsac.BILLED_AMOUNT,0)) billed,
   		SUM(NVL(gmsac.REVENUE_AMOUNT,0)) rev
FROM	tams.tams_gms_status_actuals  		 gmsac,
		apps.gl_code_combinations gcc,
		apps.PA_COST_DISTRIBUTION_LINES_ALL  cdl,
		apps.pa_expenditure_types 			 et
WHERE	cdl.EXPENDITURE_ITEM_ID (+) = gmsac.expenditure_item_id  	
and		cdl.pa_date(+) BETWEEN '##s_date'  AND '##e_date'
and		gcc.CODE_COMBINATION_ID  = cdl.dr_CODE_COMBINATION_ID
and		gcc.segment3 between nvl('##7',gcc.segment3) and nvl('##8',gcc.segment3)
and		et.EXPENDITURE_TYPE (+) = gmsac.expenditure_type
group by
	  	gmsac.project_id,
		gmsac.task_id) e,
(SELECT	pf.project_id,
		pf.task_id,
		SUM(pf.FUNDING_AMOUNT) funding
FROM	apps.gms_project_fundings pf
group by
	  	pf.project_id,
	  	pf.task_id) f,
 		apps.pa_projects_all p,
		apps.pa_tasks t,
		apps.gms_awards_all a,
		apps.ra_customers c,
		apps.PA_PROJECT_PARTIES pp1,
		apps.PA_PROJECT_PARTIES pp2,
		apps.GMS_PROJECT_FUNDINGS pf,
		apps.GMS_INSTALLMENTS gi,
		apps.hr_all_organization_units o1, 
		apps.hr_all_organization_units o2,
   		apps.pa_segment_value_lookups d1,
		apps.per_people_f m,
		apps.per_people_f tm,
		apps.per_people_f ra,
		apps.pa_project_classes c1, 
		apps.pa_project_classes c2, 
		apps.pa_project_classes c3, 
		apps.pa_project_classes c4, 
		apps.pa_project_classes c5, 
		apps.pa_project_classes c6, 
		apps.pa_project_classes c7, 
		apps.pa_project_classes c8, 
		apps.PA_IND_RATE_SCHEDULES_ALL_BG i
where   p.project_type = 'Sponsored Program' 
and	    p.SEGMENT1 between nvl('##5',p.segment1) and nvl('##6',p.segment1) 	
and     t.project_id  = p.PROJECT_ID
and     pp1.PROJECT_ID (+) = p.PROJECT_ID
and	    pp1.PROJECT_ROLE_ID (+) = 1	 -- project manager
and     pp1.start_date_active (+) <= sysdate
and     nvl(pp1.END_DATE_ACTIVE (+),sysdate) >= sysdate
and	    m.PERSON_ID (+) = pp1.RESOURCE_SOURCE_ID
and     pp2.PROJECT_ID (+) = p.PROJECT_ID
and	    pp2.PROJECT_ROLE_ID (+) = 1004 -- responsible accountant
and     pp2.start_date_active (+) <= sysdate
and	    ra.PERSON_ID (+) = pp2.RESOURCE_SOURCE_ID
and     nvl(pp2.END_DATE_ACTIVE (+),sysdate) >= sysdate
and	    tm.PERSON_ID (+) = t.TASK_MANAGER_PERSON_ID
and	    o1.ORGANIZATION_ID (+) = p.CARRYING_OUT_ORGANIZATION_ID
and	    d1.SEGMENT_VALUE_LOOKUP (+) = o1.NAME
and	    d1.segment_value  between nvl('##3',d1.segment_value) and nvl('##4',d1.segment_value)
and	   o2.ORGANIZATION_ID (+) = t.CARRYING_OUT_ORGANIZATION_ID
and    c1.PROJECT_ID (+) = p.PROJECT_ID
and	   c1.CLASS_CATEGORY (+) = 'Expense Code' 
and    c2.PROJECT_ID (+) = p.PROJECT_ID
and	   c2.CLASS_CATEGORY (+) = 'OMB A-21'
and    c3.PROJECT_ID (+) = p.PROJECT_ID
and	   c3.CLASS_CATEGORY (+) = 'Revenue Line'
and    c4.PROJECT_ID (+) = p.PROJECT_ID
and	   c4.CLASS_CATEGORY (+) = 'Burden Rate'
and    c5.PROJECT_ID (+) = p.PROJECT_ID
and	   c5.CLASS_CATEGORY (+) = 'Burden Structure'
and    c6.PROJECT_ID (+) = p.PROJECT_ID
and	   c6.CLASS_CATEGORY (+) = 'Site'
and    c7.PROJECT_ID (+) = p.PROJECT_ID
and	   c7.CLASS_CATEGORY (+) = 'Sponsor'
and    c8.PROJECT_ID (+) = p.PROJECT_ID
and	   c8.CLASS_CATEGORY (+) = 'Type'
and	 	b.project_id (+) = t.project_id
and	 	b.task_id (+) = t.task_id
and  	pf.project_ID (+) = t.project_id
and		pf.task_id (+) = t.task_id
and		gi.INSTALLMENT_ID (+) = pf.installment_id	 
and	 	a.AWARD_ID (+) = gi.AWARD_ID 
and	 	ct.project_id (+) = t.project_id
and	 	ct.task_id (+) = t.task_id
and	 	e.project_id (+) = t.project_id
and	 	e.task_id (+) = t.task_id
and	 	f.project_id (+) = t.project_id
and	 	f.task_id (+) = t.task_id
and	 	i.IND_RATE_SCH_ID (+) = a.IDC_SCHEDULE_ID
and  	c.CUSTOMER_ID (+) = a.FUNDING_SOURCE_ID
order by 2;



Californiagirl

[EDIT - LF: added code tags]

[Updated on: Fri, 27 July 2007 00:07] by Moderator

Report message to a moderator

Re: Need Help with Query to break down a combination [message #254446 is a reply to message #254445] Thu, 26 July 2007 14:49 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
Please read & follow the posting guidelines as stated in the STICKY post at top of forum & be sure to use "code tags" for code formatting.

Otherwise You're On Your Own (YOYO)!
Re: Need Help with Query to break down a combination [message #254447 is a reply to message #254445] Thu, 26 July 2007 14:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Any suggestions on how to change this in the query or sql plus report?

Read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS
Make sure that lines of code do not exceed 80 or 100 characters when you format.
Please always post your Oracle version (4 decimals).

Regards
Michel
Re: Need Help with Query to break down a combination [message #254451 is a reply to message #254445] Thu, 26 July 2007 15:14 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
./fa/1587/0/

Does that look formatted you you? You need CODE tags. Please read the sticky.
Re: Need Help with Query to break down a combination [message #269306 is a reply to message #254451] Fri, 21 September 2007 10:45 Go to previous message
californiagirl
Messages: 79
Registered: May 2007
Member
I was thinking of trying to use a case statement to add to this sql*plus report to get the combination I want. I want the combination of detail broken down by PROJECT, TASK AND AWARD. As you can see there are about 42 columns and I need the same column detail for each combination (Project, Task, Award).

Sample case statement:

select
(case
when Project_id something then 'Project'
when Task_id something then 'Task'
else 'Award'
end ) combination,

Any suggestions on how I could possibly get the combination as stated above by using a case statement or any other suggestions?Please keep in mind I will have to add this case statement somewhere in the code below.




SELECT   DISTINCT p.Segment1,
                  p.Start_Date,
                  p.Completion_Date,
                  p.Project_Status_Code,
                  m.Full_Name,
                  ra.Full_Name,
                  t.Task_Number,
                  t.Start_Date,
                  t.Completion_Date,
                  tm.Full_Name,
                  a.Award_Number,
                  Rtrim(Translate(a.Award_Short_Name,Chr(10),' ')),
                  o1.NAME,
                  o2.NAME,
                  Nvl(c1.Class_Code,' '),
                  Nvl(c2.Class_Code,' '),
                  Nvl(c3.Class_Code,' '),
                  Nvl(c4.Class_Code,' '),
                  Nvl(c5.Class_Code,' '),
                  Nvl(c6.Class_Code,' '),
                  Nvl(c7.Class_Code,' '),
                  Nvl(c8.Class_Code,' '),
                  c.Customer_Name,
                  a.TYPE,
                  a.Award_Purpose_Code,
                  a.Attribute10,
                  i.Ind_Rate_sch_Name,
                  e.Total_exp,
                  e.dir_exp,
                  e.Ind_exp,
                  e.cs_exp,
                  ct.Tot_Commit,
                  ct.dir_Commit,
                  ct.Ind_Commit,
                  ct.cs_Commit,
                  e.Billed,
                  e.Rev,
                  f.FundIng,
                  b.Budget_Total,
                  b.Direct_Budget,
                  b.Indirect_Budget,
                  b.cs_Budget
FROM     (SELECT   gra.Project_Id,
                   gra.Task_Id,
                   gra.Budget_Version_Id,
                   SUM(bl.Burdened_Cost) Budget_Total,
                   SUM(DECODE(Substr(r.NAME,1,10),'Award Reve',Nvl(bl.Burdened_Cost,0),
                                                  'F & A Cost',Nvl(bl.Burdened_Cost,0),
                                                  0)) Indirect_Budget,
                   SUM(DECODE(Substr(r.NAME,1,10),'Award Reve',0,
                                                  'F & A Cost',0,
                                                  'Cost Share',0,
                                                  Nvl(bl.Burdened_Cost,0))) Direct_Budget,
                   SUM(DECODE(Substr(r.NAME,1,10),'Cost Share',Nvl(bl.Burdened_Cost,0),
                                                  0)) cs_Budget
          FROM     apps.gms_Resource_Assignments gra,
                   apps.gms_Budget_Lines bl,
                   apps.Pa_Resource_List_Members rlm,
                   apps.Pa_Resources r
          WHERE    rlm.Resource_Id = r.Resource_Id
                   AND gra.Resource_List_Member_Id = rlm.Resource_List_Member_Id
                   AND bl.Resource_Assignment_Id = gra.Resource_Assignment_Id
                   AND gra.Budget_Version_Id IN (SELECT MAX(bv.Budget_Version_Id)
                                                 FROM   gms.gms_Budget_Versions bv
                                                 WHERE  bv.Project_Id = gra.Project_Id)
          GROUP BY gra.Project_Id,
                   gra.Task_Id,
                   gra.Budget_Version_Id) b,
         (SELECT   pct.Project_Id,
                   pct.Task_Id,
                   SUM(pct.Tot_cmt_Burdened_Cost) Tot_Commit,
                   SUM(DECODE(pct.Expenditure_Category,'F & A Costs',0,
                                                       'Cost Share',0,
                                                       Nvl(pct.Tot_cmt_Burdened_Cost,0))) dir_Commit,
                   SUM(DECODE(pct.Expenditure_Category,'F & A Costs',Nvl(pct.Tot_cmt_Burdened_Cost,0),
                                                       0)) Ind_Commit,
                   SUM(DECODE(pct.Expenditure_Category,'Cost Share',Nvl(pct.Tot_cmt_Burdened_Cost,0),
                                                       0)) cs_Commit
          FROM     apps.Pa_Commitment_txns pct
          GROUP BY pct.Project_Id,
                   pct.Task_Id) ct,
         (SELECT   gmSac.Project_Id,
                   gmSac.Task_Id,
                   SUM(cdl.Project_Burdened_Cost) Total_exp,
                   SUM(DECODE(Substr(et.Expenditure_Category,1,10),'F & A Cost',
                              0,
                                                                   'Cost Share',
                              0,
                                                                   Nvl(gmSac.Burdened_Cost,0))) dir_exp,
                   SUM(DECODE(Substr(et.Expenditure_Category,1,10),'F & A Cost',
                              Nvl(cdl.Project_Burdened_Cost,0),
                                                                   0)) Ind_exp,
                   SUM(DECODE(Substr(et.Expenditure_Category,1,10),'Cost Share',
                              Nvl(cdl.Project_Burdened_Cost,0),
                                                                   0)) cs_exp,
                   SUM(Nvl(gmSac.Billed_Amount,0)) Billed,
                   SUM(Nvl(gmSac.Revenue_Amount,0)) Rev
          FROM     Tams.Tams_gms_Status_Actuals gmSac,
                   apps.gl_Code_Combinations gcc,
                   apps.Pa_Cost_Distribution_Lines_All cdl,
                   apps.Pa_Expenditure_Types et
          WHERE    cdl.Expenditure_Item_Id (+)  = gmSac.Expenditure_Item_Id
                   AND cdl.Pa_Date (+)  BETWEEN :from_period
                                                AND :to_period
                   AND gcc.Code_Combination_Id = cdl.dr_Code_Combination_Id
                   AND gcc.Segment3 BETWEEN Nvl(:from_natural_acct,gcc.Segment3)
                                            AND Nvl(:to_natural_account,gcc.Segment3)
                   AND et.Expenditure_Type (+)  = gmSac.Expenditure_Type
          GROUP BY gmSac.Project_Id,
                   gmSac.Task_Id) e,
         (SELECT   pf.Project_Id,
                   pf.Task_Id,
                   SUM(pf.FundIng_Amount) FundIng
          FROM     apps.gms_Project_FundIngs pf
          GROUP BY pf.Project_Id,
                   pf.Task_Id) f,
         apps.Pa_Projects_All p,
         apps.Pa_Tasks t,
         apps.gms_Awards_All a,
         apps.ra_Customers c,
         apps.Pa_Project_Parties pp1,
         apps.Pa_Project_Parties pp2,
         apps.gms_Project_FundIngs pf,
         apps.gms_Installments Gi,
         apps.hr_All_Organization_Units o1,
         apps.hr_All_Organization_Units o2,
         apps.Pa_Segment_Value_LookUps d1,
         apps.Per_People_f m,
         apps.Per_People_f tm,
         apps.Per_People_f ra,
         apps.Pa_Project_Classes c1,
         apps.Pa_Project_Classes c2,
         apps.Pa_Project_Classes c3,
         apps.Pa_Project_Classes c4,
         apps.Pa_Project_Classes c5,
         apps.Pa_Project_Classes c6,
         apps.Pa_Project_Classes c7,
         apps.Pa_Project_Classes c8,
         apps.Pa_Ind_Rate_Schedules_All_bg i
WHERE    p.Project_Type = 'Sponsored Program'
         AND p.Segment1 BETWEEN Nvl(:from_project,p.Segment1)
                                AND Nvl(:to_project,p.Segment1)
         AND t.Project_Id = p.Project_Id
         AND pp1.Project_Id (+)  = p.Project_Id
         AND pp1.Project_Role_Id (+)  = 1     -- project manager
         AND pp1.Start_Date_Active (+)  <= SYSDATE
         AND Nvl(pp1.End_Date_Active (+) ,SYSDATE) >= SYSDATE
         AND m.Person_Id (+)  = pp1.Resource_Source_Id
         AND pp2.Project_Id (+)  = p.Project_Id
         AND pp2.Project_Role_Id (+)  = 1004 -- responsible accountant
         AND pp2.Start_Date_Active (+)  <= SYSDATE
         AND ra.Person_Id (+)  = pp2.Resource_Source_Id
         AND Nvl(pp2.End_Date_Active (+) ,SYSDATE) >= SYSDATE
         AND tm.Person_Id (+)  = t.Task_Manager_Person_Id
         AND o1.Organization_Id (+)  = p.CarryIng_Out_Organization_Id
         AND d1.Segment_Value_LookUp (+)  = o1.NAME
         AND d1.Segment_Value BETWEEN Nvl(:from_proj_org,d1.Segment_Value)
                                      AND Nvl(:to_proj_org,d1.Segment_Value)
         AND o2.Organization_Id (+)  = t.CarryIng_Out_Organization_Id
         AND c1.Project_Id (+)  = p.Project_Id
         AND c1.Class_Category (+)  = 'Expense Code'
         AND c2.Project_Id (+)  = p.Project_Id
         AND c2.Class_Category (+)  = 'OMB A-21'
         AND c3.Project_Id (+)  = p.Project_Id
         AND c3.Class_Category (+)  = 'Revenue Line'
         AND c4.Project_Id (+)  = p.Project_Id
         AND c4.Class_Category (+)  = 'Burden Rate'
         AND c5.Project_Id (+)  = p.Project_Id
         AND c5.Class_Category (+)  = 'Burden Structure'
         AND c6.Project_Id (+)  = p.Project_Id
         AND c6.Class_Category (+)  = 'Site'
         AND c7.Project_Id (+)  = p.Project_Id
         AND c7.Class_Category (+)  = 'Sponsor'
         AND c8.Project_Id (+)  = p.Project_Id
         AND c8.Class_Category (+)  = 'Type'
         AND b.Project_Id (+)  = t.Project_Id
         AND b.Task_Id (+)  = t.Task_Id
         AND pf.Project_Id (+)  = t.Project_Id
         AND pf.Task_Id (+)  = t.Task_Id
         AND Gi.Installment_Id (+)  = pf.Installment_Id
         AND a.Award_Id (+)  = Gi.Award_Id
         AND ct.Project_Id (+)  = t.Project_Id
         AND ct.Task_Id (+)  = t.Task_Id
         AND e.Project_Id (+)  = t.Project_Id
         AND e.Task_Id (+)  = t.Task_Id
         AND f.Project_Id (+)  = t.Project_Id
         AND f.Task_Id (+)  = t.Task_Id
         AND i.Ind_Rate_sch_Id (+)  = a.Idc_Schedule_Id
         AND c.Customer_Id (+)  = a.FundIng_Source_Id
ORDER BY 2;
Previous Topic: Get details of college leavers
Next Topic: ORA-01890: NLS error detected
Goto Forum:
  


Current Time: Mon Dec 05 09:10:44 CST 2016

Total time taken to generate the page: 0.17803 seconds