DBA Data[Home] [Help]

APPS.WIP_INFINITE_SCHEDULER_PVT dependencies on WIP_OP_RESOURCE_INSTANCES

Line 512: from wip_op_resource_instances wori,

508: for update nowait;
509:
510: cursor c_resInsts is
511: select 1
512: from wip_op_resource_instances wori,
513: wip_operation_resources wor
514: where wor.wip_entity_id = p_wipEntityID
515: and wor.organization_id = p_orgID
516: and ( wor.operation_seq_num < p_maxOpSeqNum

Line 824: update wip_op_resource_instances

820: end if;
821:
822:
823: forall i in 1..x_resTbls.resID.count
824: update wip_op_resource_instances
825: set start_date = x_resTbls.startDate(i),
826: completion_date = x_resTbls.endDate(i),
827: last_update_date = l_sysdate,
828: last_updated_by = l_userID,

Line 950: wip_op_resource_instances wori,

946: l_progApplID,
947: l_progID,
948: l_sysdate
949: from wip_operation_resource_usage woru,
950: wip_op_resource_instances wori,
951: wip_operation_resources wor
952: where woru.wip_entity_id = wori.wip_entity_id
953: and woru.operation_seq_num = wori.operation_seq_num
954: and woru.resource_seq_num = wori.resource_seq_num