eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CLIENT_EXTN_STATUS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 154


	SELECT 	nvl(burdened_cost_itd, 0)
			, nvl(baseline_burdened_cost_tot, 0)
			, nvl(actuals_labor_hours_itd, 0)
			, nvl(baseline_cost_labor_hours_tot, 0)
			, nvl(cmt_burdened_cost_ptd, 0)
			, nvl(baseline_burdened_cost_itd, 0)
			, nvl(baseline_revenue_tot, 0)
			, nvl(revenue_itd, 0)
			, nvl(revenue_ptd, 0)
	INTO	p_burdened_cost_itd
			, p_base_burdened_cost_tot
			, p_actuals_labor_hours_itd
			, p_base_cost_labor_hours_tot
			, p_cmt_burdened_cost_ptd
			, p_base_burdened_cost_itd
			, p_base_revenue_tot
			, p_revenue_itd
			, p_revenue_ptd
	FROM 	pa_status_proj_v
	WHERE		project_id =  x_project_id;

Line: 177


	SELECT 	nvl(burdened_cost_itd, 0)
			, nvl(baseline_burdened_cost_tot, 0)
			, nvl(actuals_labor_hours_itd, 0)
			, nvl(baseline_cost_labor_hours_tot, 0)
			, nvl(cmt_burdened_cost_ptd, 0)
			, nvl(baseline_burdened_cost_itd, 0)
			, nvl(baseline_revenue_tot, 0)
			, nvl(revenue_itd, 0)
			, nvl(revenue_ptd, 0)
	INTO	p_burdened_cost_itd
		, p_base_burdened_cost_tot
		, p_actuals_labor_hours_itd
		, p_base_cost_labor_hours_tot
		, p_cmt_burdened_cost_ptd
		, p_base_burdened_cost_itd
		, p_base_revenue_tot
		, p_revenue_itd
		, p_revenue_ptd
	FROM 	pa_status_task_v
	WHERE		project_id =  x_project_id
	AND		task_id 	   =  x_task_id;

Line: 202


	SELECT 	nvl(burdened_cost_itd, 0)
			, nvl(baseline_burdened_cost_tot, 0)
			, nvl(actuals_labor_hours_itd, 0)
			, nvl(baseline_cost_labor_hours_tot, 0)
			, nvl(cmt_burdened_cost_ptd, 0)
			, nvl(baseline_burdened_cost_itd, 0)
			, nvl(baseline_revenue_tot, 0)
			, nvl(revenue_itd, 0)
	INTO	p_burdened_cost_itd
		, p_base_burdened_cost_tot
		, p_actuals_labor_hours_itd
		, p_base_cost_labor_hours_tot
		, p_cmt_burdened_cost_ptd
		, p_base_burdened_cost_itd
		, p_base_revenue_tot
		, p_revenue_itd
	FROM 	pa_status_rsrc_v
	WHERE		project_id =  x_project_id
	AND		task_id   is null
	AND		resource_list_member_id = x_resource_list_member_id;

Line: 224


	SELECT 	nvl(burdened_cost_itd, 0)
			, nvl(baseline_burdened_cost_tot, 0)
			, nvl(actuals_labor_hours_itd, 0)
			, nvl(baseline_cost_labor_hours_tot, 0)
			, nvl(cmt_burdened_cost_ptd, 0)
			, nvl(baseline_burdened_cost_itd, 0)
			, nvl(baseline_revenue_tot, 0)
			, nvl(revenue_itd, 0)
	INTO	p_burdened_cost_itd
		, p_base_burdened_cost_tot
		, p_actuals_labor_hours_itd
		, p_base_cost_labor_hours_tot
		, p_cmt_burdened_cost_ptd
		, p_base_burdened_cost_itd
		, p_base_revenue_tot
		, p_revenue_itd
	FROM 	pa_status_rsrc_v
	WHERE		project_id =  x_project_id
	AND		task_id     =   x_task_id
	AND		resource_list_member_id = x_resource_list_member_id;