APPS.EAM_OP_COMP dependencies on WIP_OPERATIONS

Line 128: wip_operations wo,

124: ewod.workflow_type,
125: wo.last_unit_completion_date,
126: we.wip_entity_name
127: from
128: wip_operations wo,
129: wip_discrete_jobs wdj,
130: eam_work_order_details ewod,
131: wip_entities we
132: where

Line 146: select 1 from wip_operations

142: where
143: won.wip_entity_id = p_wip_entity_id and
144: won.next_operation = p_operation_seq_num and
145: exists (
146: select 1 from wip_operations
147: where
148: wip_entity_id = p_wip_entity_id and
149: operation_seq_num = won.prior_operation and
150: nvl(operation_completed,'N') <> 'Y'

Line 159: select 1 from wip_operations

155: where
156: won.wip_entity_id = p_wip_entity_id and
157: won.prior_operation = p_operation_seq_num and
158: exists (
159: select 1 from wip_operations
160: where
161: wip_entity_id = p_wip_entity_id and
162: operation_seq_num = won.next_operation and
163: operation_completed = 'Y'

Line 276: -- update TABLE wip_operations

272: l_last_updated_by := FND_GLOBAL.USER_ID;
273: l_last_update_login := FND_GLOBAL.LOGIN_ID;
274: l_last_update_date := sysdate;
275:
276: -- update TABLE wip_operations
277: UPDATE wip_operations
278: SET
279: operation_completed = l_op_completed,
280: quantity_completed = 1,

Line 277: UPDATE wip_operations

273: l_last_update_login := FND_GLOBAL.LOGIN_ID;
274: l_last_update_date := sysdate;
275:
276: -- update TABLE wip_operations
277: UPDATE wip_operations
278: SET
279: operation_completed = l_op_completed,
280: quantity_completed = 1,
281: last_updated_by = l_last_updated_by,

Line 608: from wip_operations

604: eam_debug.init_err_stack('eam_workorders_jsp.' || l_api_name);
605:
606: select first_unit_start_date,last_unit_completion_date
607: into l_scheduled_start_date,l_scheduled_end_date
608: from wip_operations
609: where wip_entity_id=p_wip_entity_id
610: and operation_seq_num=p_operation_seq_num;
611:
612: