DBA Data[Home] [Help]

APPS.WIP_OP_LINK_VALIDATIONS dependencies on WIP_OPERATIONS

Line 191: FROM WIP_OPERATIONS

187: AND organization_id = p_organization_id
188: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
189: AND substitution_type = p_subst_type
190: AND not exists (select 1
191: FROM WIP_OPERATIONS
192: WHERE wip_entity_id = p_wip_entity_id
193: AND organization_id = p_organization_id
194: AND operation_seq_num = p_operation_seq_num);
195:

Line 311: from wip_operations

307: if (p_wip_entity_id is not null and to_id is not null and from_id is not null) then
308: begin
309: select operation_completed,first_unit_start_date
310: into l_completed, l_next_op_start_date
311: from wip_operations
312: where wip_entity_id = p_wip_entity_id
313: and operation_seq_num = l_operation_seq_num;
314: exception
315: when others then

Line 323: from wip_operations

319: l_operation_seq_num := from_id;
320: begin
321: select operation_completed, last_unit_completion_date
322: into l_prev_op_complete, l_previous_op_completion_date
323: from wip_operations
324: where wip_entity_id = p_wip_entity_id
325: and operation_seq_num = l_operation_seq_num;
326: exception
327: when others then