DBA Data[Home] [Help]

APPS.WIP_RES_INST_VALIDATIONS dependencies on WIP_OPERATIONS

Line 239: from wip_operations wo, wip_operation_resources wor

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

Line 342: from wip_operations wo, wip_operation_resources wor

338: l_resource_id number;
339: begin
340: select wo.department_id, wor.resource_id
341: into l_dept_id, l_resource_id
342: from wip_operations wo, wip_operation_resources wor
343: where wo.wip_entity_id = p_wip_entity_id
344: and wo.operation_seq_num = p_operation_seq_num
345: and wo.organization_id = p_organization_id
346: and wo.repetitive_schedule_id is null