APPS.EAM_WO_NETWORK_UTIL_PVT dependencies on WIP_DISCRETE_JOBS

Line 146: WIP_DISCRETE_JOBS WDJ

142: FROM WIP_SCHED_RELATIONSHIPS WSR
143: WHERE WSR.RELATIONSHIP_TYPE = 1
144: CONNECT BY prior WSR.CHILD_OBJECT_ID = WSR.PARENT_OBJECT_ID
145: START WITH WSR.PARENT_OBJECT_ID = l_obj_id) WSR1,
146: WIP_DISCRETE_JOBS WDJ
147: WHERE l_obj_type_id = 1
148: AND WSR1.CHILD_OBJECT_ID = WDJ.WIP_ENTITY_ID
149: AND ( WDJ.firm_planned_flag = l_cur_non_firm_flag OR WDJ.firm_planned_flag = l_cur_firm_flag)
150: AND WDJ.status_type NOT IN (7,4,5,12,14)

Line 163: FROM WIP_DISCRETE_JOBS WDJ

159: WDJ.requested_start_date,
160: WDJ.due_date,
161: 0 WO_LEVEL,
162: WDJ.FIRM_PLANNED_FLAG
163: FROM WIP_DISCRETE_JOBS WDJ
164: WHERE WDJ.WIP_ENTITY_ID = l_obj_id
165: AND l_obj_type_id = 1
166: AND WDJ.status_type NOT IN (7,4,5,12,14)
167: ) ORDER BY 8 DESC ;

Line 218: FROM wip_operation_resource_usage woru, wip_discrete_jobs wdj

214: woru.resource_seq_num,
215: woru.instance_id,
216: woru.serial_number,
217: woru.assigned_units
218: FROM wip_operation_resource_usage woru, wip_discrete_jobs wdj
219: WHERE woru.wip_entity_id = l_obj_id
220: AND wdj.wip_entity_id = l_obj_id
221: -- AND wdj.firm_planned_flag = l_cur_firm_flag
222: AND l_obj_type_id = 1;

Line 284: from wip_discrete_jobs where

280: l_completion_date := p_completion_date;
281:
282: select scheduled_start_date, scheduled_completion_date
283: into l_wo_start_date, l_wo_completion_date
284: from wip_discrete_jobs where
285: wip_entity_id = p_work_object_id;
286:
287: if l_offset_days is null then
288: if l_start_date is not null then

Line 680: FROM WIP_DISCRETE_JOBS WDJ

676: INTO l_job_status,
677: l_organization_id,
678: l_scheduled_start_date,
679: l_scheduled_completion_date
680: FROM WIP_DISCRETE_JOBS WDJ
681: WHERE WDJ.WIP_ENTITY_ID = l_work_object_id
682: AND l_work_object_type_id = 1;
683: EXCEPTION
684: WHEN OTHERS THEN

Line 705: UPDATE WIP_DISCRETE_JOBS WDJ

701:
702: BEGIN
703:
704: /* Update the job start and Enc Dates */
705: UPDATE WIP_DISCRETE_JOBS WDJ
706: SET WDJ.SCHEDULED_START_DATE = WDJ.SCHEDULED_START_DATE + l_offset_days,
707: WDJ.SCHEDULED_COMPLETION_DATE = WDJ.SCHEDULED_COMPLETION_DATE + l_offset_days
708: WHERE WDJ.WIP_ENTITY_ID = l_work_object_id
709: AND l_work_object_type_id = 1;

Line 859: FROM WIP_DISCRETE_JOBS WDJ

855: INTO l_job_status,
856: l_organization_id,
857: l_scheduled_start_date,
858: l_scheduled_completion_date
859: FROM WIP_DISCRETE_JOBS WDJ
860: WHERE WDJ.WIP_ENTITY_ID = l_work_object_id
861: AND l_work_object_type_id = 1;
862: EXCEPTION
863: WHEN OTHERS THEN