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 804: update wip_op_resource_instances

800: end if;
801:
802:
803: forall i in 1..x_resTbls.resID.count
804: update wip_op_resource_instances
805: set start_date = x_resTbls.startDate(i),
806: completion_date = x_resTbls.endDate(i),
807: last_update_date = l_sysdate,
808: last_updated_by = l_userID,

Line 930: wip_op_resource_instances wori,

926: l_progApplID,
927: l_progID,
928: l_sysdate
929: from wip_operation_resource_usage woru,
930: wip_op_resource_instances wori,
931: wip_operation_resources wor
932: where woru.wip_entity_id = wori.wip_entity_id
933: and woru.operation_seq_num = wori.operation_seq_num
934: and woru.resource_seq_num = wori.resource_seq_num