APPS.WSM_INFINITE_SCHEDULER_PVT dependencies on WIP_OPERATION_RESOURCES

Line 618: from wip_operation_resources

614: for update nowait;
615:
616: cursor c_WOR is
617: select 1
618: from wip_operation_resources
619: where wip_entity_id = p_wipEntityID
620: and organization_id = p_orgID
621: for update nowait;
622:

Line 701: wip_operation_resources wor,

697: wor.basis_type,
698: wor.assigned_units
699: from wip_discrete_jobs wdj,
700: wip_operations wo,
701: wip_operation_resources wor,
702: mtl_uom_conversions muc,
703: bom_department_resources bdr
704: where wdj.wip_entity_id = p_wipEntityID
705: and wdj.organization_id = p_orgID

Line 1081: from WIP_OPERATION_RESOURCES

1077: select substitute_group_num,
1078: replacement_group_num
1079: into l_sub_grp_num,
1080: l_rpl_grp_num
1081: from WIP_OPERATION_RESOURCES
1082: where wip_entity_id = p_wipEntityID
1083: and operation_seq_num = -p_opSeqNum
1084: and resource_seq_num = p_resSeqNum;
1085: end if;

Line 1740: update wip_operation_resources

1736:
1737: l_stat_num := 110;
1738: --update resources (WOR)
1739: forall i in 1..l_cnt_wor
1740: update wip_operation_resources
1741: set start_date = NVL(x_resTbls.startDate(i), start_date),
1742: completion_date = NVL(x_resTbls.endDate(i), completion_date),
1743: ----standard who columns----
1744: last_update_date = l_sysdate,