DBA Data[Home] [Help]

APPS.WIP_RES_INST_VALIDATIONS dependencies on WIP_OPERATIONS

Line 237: from wip_operations wo, wip_operation_resources wor

233: begin
234:
235: select wo.department_id, wor.resource_id
236: into l_dept_id, l_resource_id
237: from wip_operations wo, wip_operation_resources wor
238: where wo.wip_entity_id = p_wip_entity_id
239: and wo.operation_seq_num = p_operation_seq_num
240: and wo.organization_id = p_organization_id
241: and wo.repetitive_schedule_id is null

Line 337: from wip_operations wo, wip_operation_resources wor

333: l_resource_id number;
334: begin
335: select wo.department_id, wor.resource_id
336: into l_dept_id, l_resource_id
337: from wip_operations wo, wip_operation_resources wor
338: where wo.wip_entity_id = p_wip_entity_id
339: and wo.operation_seq_num = p_operation_seq_num
340: and wo.organization_id = p_organization_id
341: and wo.repetitive_schedule_id is null