DBA Data[Home] [Help]

APPS.EAM_OP_COMP dependencies on WIP_DISCRETE_JOBS

Line 129: wip_discrete_jobs wdj,

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
133: wdj.wip_entity_id = p_wip_entity_id AND

Line 254: from wip_discrete_jobs

250:
251: IF (p_wip_entity_id is not null) and (l_op_completed = 'N') THEN
252: select status_type
253: into l_job_status
254: from wip_discrete_jobs
255: where wip_entity_id = p_wip_entity_id;
256:
257: IF (l_job_status = 4 ) THEN
258: x_err_code := 1;