APPS.AHL_VWP_MR_CST_PR_PVT SQL Statements

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

Line: 55

Select VISIT_ID,
       VISIT_TASK_ID,
       MR_ID,
       ACTUAL_COST,
       ESTIMATED_PRICE,
       PRICE_LIST_ID,
       SERVICE_REQUEST_ID,
       VISIT_TASK_NAME,
       VISIT_TASK_NUMBER
From ahl_visit_tasks_VL
where visit_task_id=c_visit_task_id;

Line: 73

select customer_id
from  CS_INCIDENTS_ALL_B
where incident_id=c_incident_id;

Line: 80

Select VISIT_ID,
       ACTUAL_PRICE,
       ESTIMATED_PRICE,
       PRICE_LIST_ID,
       SERVICE_REQUEST_ID,
       OUTSIDE_PARTY_FLAG,
       ORGANIZATION_ID,
       START_DATE_TIME,
       CLOSE_DATE_TIME
From ahl_visits_vl
where visit_id=c_visit_id;

Line: 95

Select a.WORKORDER_ID,a.MASTER_WORKORDER_FLAG
From ahl_workorders a
where a.visit_task_id=c_visit_task_id
and  a.status_code <>'22' and a.status_code <>'7'
and  a.master_workorder_flag='Y';

Line: 106

Select MR_HEADER_ID,TITLE,DESCRIPTION,BILLING_ITEM_ID,BILLING_ITEM
From ahl_mr_headers_v
where mr_header_id=c_mr_header_id;

Line: 110

   select	MR_HEADER_ID,
            TITLE,
            DESCRIPTION,
            BILLING_ITEM_ID,
            (	SELECT DISTINCT	CONCATENATED_SEGMENTS
               FROM					MTL_SYSTEM_ITEMS_KFV
               WHERE					INVENTORY_ITEM_ID=BILLING_ITEM_ID) BILLING_ITEM
   from		AHL_MR_HEADERS_APP_V
   where		mr_header_id=c_mr_header_id ;

Line: 221

Select v.visit_id, v.any_task_chg_flag
From ahl_visits_b V, ahl_visit_tasks_b T
where T.visit_task_id=c_visit_task_id
AND V.visit_id = T.visit_id;

Line: 418

     p_x_cost_price_rec.Is_Cst_Struc_updated  := l_cost_price_rec.Is_Cst_Struc_updated;

Line: 484

Select visit_task_id, visit_id,
actual_price,
estimated_price,
mr_id,
start_date_time,
end_date_time
From ahl_visit_tasks_b
where visit_task_id=c_visit_task_id;

Line: 498

Select VISIT_ID,
       ACTUAL_PRICE,
       ESTIMATED_PRICE,
       PRICE_LIST_ID,
       SERVICE_REQUEST_ID,
       OUTSIDE_PARTY_FLAG,
       ORGANIZATION_ID,
       START_DATE_TIME,
       any_task_chg_flag
From ahl_visits_b
where visit_id=c_visit_id;

Line: 515

Select visit_task_id,
task_type_code,
mr_id,
start_date_time,
end_date_time
from ahl_visit_tasks_b
where visit_id = c_visit_id
AND NVL(status_code, 'Y') <> NVL ('DELETED', 'X')
and originating_task_id = c_visit_task_id
and mr_id is not null;

Line: 532

select customer_id
from  CS_INCIDENTS_ALL_B
where incident_id=c_incident_id;

Line: 543

   SELECT	mr.billing_item_id, mr.mr_header_id,mtls.primary_uom_code UOM_CODE
	FROM		AHL_MR_HEADERS_APP_V mr, mtl_system_items_b mtls
	WHERE		mr.mr_header_id = c_mr_id
	AND		mr.billing_item_id = mtls.inventory_item_id
	AND		mtls.organization_id = c_org_id
	AND		billing_item_id IS NOT NULL;

Line: 552

      SELECT min(start_date_time)
      FROM ahl_visit_tasks_vl VST
      START WITH visit_task_id  = x_task_id
      AND NVL(VST.status_code, 'Y') <> NVL ('DELETED', 'X')
      CONNECT BY originating_task_id = PRIOR visit_task_id;

Line: 726

    p_x_cost_price_rec.Is_Cst_Struc_updated := l_cost_price_rec.Is_Cst_Struc_updated;

Line: 1120

                        Update AHL_VISITS_B
                        set actual_price=l_visit_rec.actual_price,
                        estimated_price=l_visit_rec.estimated_price
                        where visit_id=l_visit_rec.visit_id;

Line: 1126

                        Update AHL_VISIT_TASKS_B
                        set actual_price=l_actual_price,
                        estimated_price=l_estimate_price
                        where visit_task_id=l_task_rec.visit_task_id;

Line: 1135

                        Update AHL_VISIT_TASKS_B
                        set actual_price=l_actual_price,
                        estimated_price=l_estimate_price
                        where visit_task_id=l_task_rec.visit_task_id;

Line: 1226

Select visit_task_id,
       visit_id,
       price_list_id,
       mr_id, start_date_time
       from Ahl_visit_tasks_vl
       where visit_task_id=c_task_id;

Line: 1236

Select visit_id,
       price_list_id,
       service_Request_id,
       organization_id,
       outside_party_flag
From AHL_VISITS_B
Where VISIT_ID=C_VISIT_ID;

Line: 1249

/*SELECT 1
From AHL_MR_HEADERS_V
WHERE MR_HEADER_ID=C_MR_HEADER_ID;

Line: 1253

	SELECT 1
	From   AHL_MR_HEADERS_APP_V
	WHERE  MR_HEADER_ID=C_MR_HEADER_ID ;

Line: 1261

	SELECT	mr.billing_item_id,
				mr.mr_header_id,
				mtls.primary_uom_code UOM_CODE
	FROM		AHL_MR_HEADERS_APP_V mr, mtl_system_items_b mtls
	WHERE		mr.MR_HEADER_ID = C_MR_ID
	AND		mr.BILLING_ITEM_ID = mtls.INVENTORY_ITEM_ID
	AND		mtls.organization_id = c_org_id
	AND		billing_item_id IS NOT NULL ;

Line: 1275

Select visit_task_id,task_type_code,
mr_id, start_date_time
from ahl_visit_tasks_b
where visit_id = c_visit_id
AND NVL(status_code, 'Y') <> NVL ('DELETED', 'X')
and originating_task_id = c_visit_task_id
and mr_id is not null;

Line: 1289

select customer_id
from  CS_INCIDENTS_ALL_B
where incident_id=c_incident_id;

Line: 1296

/*Select mr_name,
       mr_description,
       task_number,
       task_name
from AHL_SEARCH_VISIT_TASK_V
Where TASK_ID=C_VISIT_TASK_ID;

Line: 1307

   select      mrb.title mr_name,
               mrtl.description mr_description,
               visit_task_number task_number,
               visit_task_name task_name
   from        ahl_visit_tasks_vl tsk,
               ahl_mr_headers_tl mrtl,
               ahl_mr_headers_b mrb,
               ahl_mr_routes   mrr,
               ahl_visits_vl avts
   where       tsk.mr_route_id = mrr.mr_route_id(+)
   and         mrr.mr_header_id = mrb.mr_header_id(+)
   and         mrb.mr_header_id = mrtl.mr_header_id (+)
   and         mrtl.language(+) = USERENV('LANG')
   and         nvl(tsk.status_code,'X') <> 'DELETED'
   and         avts.visit_id = tsk.visit_id
   and         avts.template_flag = 'N'
   and         tsk.task_type_code <> 'SUMMARY'
   AND         visit_task_id=c_visit_task_id
   UNION
   select      title mr_name,
               mrh.description mr_description,
               visit_task_number task_number,
               visit_task_name task_name
   from        ahl_visit_tasks_vl tsk,
               ahl_mr_headers_vl mrh,
               AHL_VISITS_VL AVTS
   where       MRH.MR_HEADER_ID = TSK.MR_ID
   AND         NVL(TSK.STATUS_CODE,'X') <> 'DELETED'
   AND         AVTS.VISIT_ID = TSK.VISIT_ID
   AND         AVTS.TEMPLATE_FLAG = 'N'
   AND         VISIT_TASK_ID=c_visit_task_id;

Line: 1345

Select CONCATENATED_SEGMENTS,DESCRIPTION,INVENTORY_ORG_ID,organization_name
FROM AHL_MTL_ITEMS_OU_V
WHERE INVENTORY_ITEM_ID=C_ITEM_ID
AND   INVENTORY_ORG_ID=C_ORG_ID;

Line: 1351

select   mtl.concatenated_segments,
         mtl.description,
         mtl.organization_id inventory_org_id,
         hou.name organization_name
from     mtl_system_items_kfv mtl,
         hr_organization_units hou,
         inv_organization_info_v org
where    mtl.organization_id = org.organization_id
and      hou.organization_id = org.organization_id
and      nvl (org.operating_unit, mo_global.get_current_org_id ())=mo_global.get_current_org_id()
and      mtl.inventory_item_id=c_item_id
and      mtl.organization_id=c_org_id ;

Line: 1369

      SELECT min(start_date_time)
      FROM ahl_visit_tasks_vl VST
      START WITH visit_task_id  = x_task_id
      AND NVL(VST.status_code, 'Y') <> NVL ('DELETED', 'X')
      CONNECT BY originating_task_id = PRIOR visit_task_id;

Line: 2067

    SELECT status_code
    FROM ahl_visits_b
    WHERE visit_id = p_visit_id;

Line: 2074

SELECT actual_price,ESTIMATEd_price, MR_Id
FROM AHL_VISIT_TASKS_VL
WHERE VISIT_TASK_ID=C_VISIT_TASK_ID;

Line: 2090

Select title, billing_item_id,description,mr_header_id
From ahl_mr_headers_v
where mr_header_id=c_mr_id;

Line: 2094

	Select title, billing_item_id,description,mr_header_id
	From   AHL_MR_HEADERS_APP_V
	where  mr_header_id=c_mr_id;

Line: 2215

        IF(l_cost_price_rec.Is_Cst_Struc_updated = 'N') AND (l_cost_price_rec.workorder_id IS NOT NULL)
            then
                log_message('Before call to AHL_VWP_COST_PVT.calculate_mr_cost',l_api_name);