[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select user_id from fnd_user where user_name = p_user_id;
select responsibility_id from fnd_responsibility_vl where responsibility_key = G_BPEL_USER_ROLE_KEY;
l_query_string := 'SELECT DISTINCT '||
'wo.workorder_id workorder_id, '||
'wo.object_version_number object_version_number, '||
'Wo.Job_Number workorder_number, '||
'wo.Job_Description Description, '||
'wo.job_status_code status_code, '||
'Wo.Job_Status_Meaning status, '||
'Wo.Visit_Number visit_number, '||
'Wo.Unit_Name unit_name, '||
'Wo.Scheduled_Start_Date assigned_start_date, '||
'Wo.Confirm_Failure_flag is_complete_enabled, '||
'Wo.Confirm_Failure_flag is_update_enabled, '||
'Wo.Confirm_Failure_flag is_res_txn_enabled '||
'FROM '||
'ahl_Search_Workorders_V Wo , '||
'wip_discrete_jobs widj, '||
'ahl_Workorder_Operations Wop, '||
'ahl_Operation_Resources Opr, '||
'ahl_Work_Assignments Wass, '||
'per_People_F Pf, '||
'per_Person_Types Pt, '||
'Fnd_User fnd '||
'WHERE '||
'fnd.USER_ID = FND_GLOBAL.USER_ID and '||
'fnd.employee_id = pf.PERSON_ID and '||
'wass.employee_id = pf.PERSON_ID and '||
' pt.Person_Type_Id = Pf.Person_Type_Id And '||
'pt.system_person_type =''EMP'' AND '||
'( Trunc(Sysdate) Between Pf.Effective_Start_Date And '||
'Pf.Effective_End_Date) and '||
'wass.Operation_Resource_Id = Opr.Operation_Resource_Id And '||
'opr.Workorder_Operation_Id = Wop.Workorder_Operation_Id And '||
'wop.Workorder_Id = Wo.Workorder_Id and '||
'wo.JOB_STATUS_CODE not in (1, 17, 22) and '||
'wo.wip_entity_id = widj.wip_entity_id and '||
'widj.date_released is not null';
l_query_string := 'SELECT '||
'wo.workorder_id workorder_id, '||
'wo.object_version_number object_version_number, '||
'Wo.Job_Number workorder_number, '||
'wo.Job_Description Description, '||
'wo.job_status_code status_code, '||
'Wo.Job_Status_Meaning status, '||
'Wo.Visit_Number visit_number, '||
'Wo.Unit_Name unit_name, '||
'Wo.Scheduled_Start_Date assigned_start_date, '||
'Wo.Confirm_Failure_flag is_complete_enabled, '||
'Wo.Confirm_Failure_flag is_update_enabled, '||
'Wo.Confirm_Failure_flag is_res_txn_enabled '||
'FROM( '||
'SELECT DISTINCT '||
'wod.workorder_id , '||
'Wod.Job_Number , '||
'wod.job_status_code , '||
'Wod.Job_Status_Meaning , '||
'Wod.Visit_Number , '||
'wod.VISIT_ID , '||
'Wod.Incident_Number , '||
'wod.INCIDENT_ID , '||
'nvl(wod.ACtual_START_DATE, wod.SCHEDULED_START_DATE) scheduled_start_date, '||
'wod.JOB_DESCRIPTION , '||
'wod.class_code class_code, '||
'wod.Visit_Task_number, '||
'wod.project_name , '||
'wod.Project_Task_name , '||
'wod.Mr_Title, '||
'wod.wo_part_number , '||
'wod.Serial_Number, '||
' wod.Organization_name , '||
'wod.department_name , '||
'wod.UNIT_NAME, '||
'NVL(WOd.ACTUAL_END_DATE, WOd.SCHEDULED_END_DATE) scheduled_end_date, '||
' wod.department_class_code, '||
'wod.visit_task_id, '||
'wod.object_version_number, '||
'wod.Confirm_Failure_flag '||
'FROM '||
' ahl_search_workorders_v wod, '||
'wip_discrete_jobs widj, '||
'per_people_f pf, '||
'bom_resource_employees bre, '||
'PER_PERSON_TYPES PEPT, '||
'ahl_pp_requirement_v aprv, '||
'Fnd_User fnd '||
'WHERE '||
'fnd.USER_ID = FND_GLOBAL.USER_ID and '||
'fnd.employee_id = pf.PERSON_ID and '||
' NVL(pf.CURRENT_EMPLOYEE_FLAG, ''X'') = ''Y'' AND '||
'PEPT.PERSON_TYPE_ID = pf.PERSON_TYPE_ID AND '||
'PEPT.SYSTEM_PERSON_TYPE =''EMP'' AND '||
'( TRUNC(SYSDATE) BETWEEN PF.EFFECTIVE_START_DATE AND PF.EFFECTIVE_END_DATE ) and '||
'pf.person_id = bre.person_id and '||
'bre.resource_id = aprv.RESOURCE_ID and '||
'wod.workorder_id not in ( '||
'SELECT DISTINCT '||
'wo1.workorder_id '||
'FROM '||
'ahl_Workorders Wo1, '||
'wip_discrete_jobs widj1, '||
'ahl_Workorder_Operations Wop, '||
'ahl_Operation_Resources Opr, '||
'ahl_Work_Assignments Wass, '||
'Fnd_User fnd '||
'WHERE '||
'fnd.USER_ID = FND_GLOBAL.USER_ID and '||
'fnd.employee_id = pf.PERSON_ID and '||
'NVL(pf.CURRENT_EMPLOYEE_FLAG, ''X'') = ''Y'' AND '||
'PEPT.PERSON_TYPE_ID = pf.PERSON_TYPE_ID AND '||
'PEPT.SYSTEM_PERSON_TYPE =''EMP'' AND '||
'( TRUNC(SYSDATE) BETWEEN PF.EFFECTIVE_START_DATE AND PF.EFFECTIVE_END_DATE ) and '||
'wass.Employee_Id = pf.person_id And '||
'wass.Operation_Resource_Id = Opr.Operation_Resource_Id And '||
'opr.Workorder_Operation_Id = Wop.Workorder_Operation_Id And '||
'wop.Workorder_Id = Wo1.Workorder_Id and '||
'wo1.STATUS_CODE not in (1, 17, 22) and '||
'wo1.wip_entity_id = widj1.wip_entity_id and '||
'widj1.date_released is not null '||
' ) and '||
'aprv.job_id = wod.workorder_id and '||
'wod.JOB_STATUS_CODE not in (1, 17, 22) and '||
'wod.wip_entity_id = widj.wip_entity_id and '||
'widj.date_released is not null '||
' UNION '||
'SELECT DISTINCT '||
'wod.workorder_id , '||
'Wod.Job_Number , '||
'wod.job_status_code , '||
'Wod.Job_Status_Meaning , '||
'Wod.Visit_Number , '||
'wod.VISIT_ID , '||
'Wod.Incident_Number , '||
'wod.INCIDENT_ID , '||
'nvl(wod.ACtual_START_DATE, wod.SCHEDULED_START_DATE) scheduled_start_date, '||
'wod.JOB_DESCRIPTION , '||
'wod.class_code class_code, '||
'wod.Visit_Task_number, '||
'wod.project_name , '||
'wod.Project_Task_name , '||
'wod.Mr_Title, '||
'wod.wo_part_number , '||
'wod.Serial_Number, '||
' wod.Organization_name , '||
'wod.department_name , '||
'wod.UNIT_NAME, '||
'NVL(WOd.ACTUAL_END_DATE, WOd.SCHEDULED_END_DATE) scheduled_end_date, '||
' wod.department_class_code, '||
'wod.visit_task_id, '||
'wod.object_version_number, '||
'wod.Confirm_Failure_flag '||
' FROM '||
'ahl_search_workorders_v wod, '||
'wip_discrete_jobs widj '||
' WHERE '||
'wod.workorder_id not in (select job_id from ahl_pp_requirement_v where resource_type_code = 2) and wod.JOB_STATUS_CODE not in (1, 17, 22) and '||
'wod.wip_entity_id = widj.wip_entity_id and '||
'widj.date_released is not null) wo where 1=1';
l_query_string := l_query_string || 'AND wo.WORKORDER_ID in (select wop.workorder_id from per_people_f pf, ahl_work_assignments wass, ahl_operation_resources opr, ahl_workorder_operations wop where ';
l_query_string := l_query_string || ' AND exists ( SELECT ''x'' FROM AHL_WORKORDER_OPERATIONS_V WOP where WOP.workorder_id = WO.workorder_id';
l_query_string := l_query_string || ' AND exists ( SELECT ''x'' FROM AHL_PP_REQUIREMENT_V RES where RES.job_id = WO.workorder_id and upper(RES.RESOURCE_CODE) like upper(:' ||l_bind_index ||'))';
l_work_order_rec.IS_UPDATE_ENABLED,
l_work_order_rec.IS_RES_TXN_ENABLED;
x_work_order_results.WORK_ORDERS(j).IS_UPDATE_ENABLED := 'F';
x_work_order_results.WORK_ORDERS(j).IS_UPDATE_ENABLED := 'T';