APPS.WSM_INFINITE_SCHEDULER_PVT dependencies on WSM_COPY_OPERATIONS

Line 242: from wsm_copy_operations wco

238: wco.reco_path_seq_num
239: into l_strRtgOpSeqNum,
240: l_strRtgOpSeqId,
241: l_strRecoSeqNum
242: from wsm_copy_operations wco
243: where wco.wip_entity_id = p_wipEntityID
244: and wco.network_start_end = 'S';
245:
246: l_stmt_num := 20.2;

Line 254: from wsm_copy_operations wco

250: wco.reco_path_seq_num
251: into l_endRtgOpSeqNum,
252: l_endRtgOpSeqId,
253: l_endRecoSeqNum
254: from wsm_copy_operations wco
255: where wco.wip_entity_id = p_wipEntityID
256: and wco.network_start_end = 'E';
257:
258: -- BD: bug 3388636, should remove this check

Line 639: from wsm_copy_operations

635: for update nowait;
636:
637: cursor c_WCO is
638: select 1
639: from wsm_copy_operations
640: where wip_entity_id = p_wipEntityID
641: and organization_id = p_orgID
642: for update nowait;
643:

Line 758: wsm_copy_operations wco,

754: * nvl(bdr.utilization, 1) * nvl(bdr.efficiency, 1) ),
755: wcor.basis_type,
756: wcor.assigned_units
757: from wip_discrete_jobs wdj,
758: wsm_copy_operations wco,
759: wsm_copy_op_resources wcor,
760: mtl_uom_conversions muc,
761: bom_department_resources bdr
762: where wdj.wip_entity_id = p_wipEntityID

Line 809: from wsm_copy_operations wco

805: union
806: -- other rtg ops --
807: select wco.reco_path_seq_num lvl,
808: operation_seq_num OP_SEQ_NUM
809: from wsm_copy_operations wco
810: where wco.wip_entity_id = p_wipEntityID
811: and (wco.reco_path_seq_num between c_fst_rec_seq_seq and c_lst_rec_seq_seq)
812: order by lvl;
813:

Line 820: from wsm_copy_operations wco

816: c_fst_rec_seq_seq number,
817: c_lst_rec_seq_seq number) is
818: select operation_seq_num,
819: NVL(yield, 1.0)
820: from wsm_copy_operations wco
821: where wco.wip_entity_id = p_wipEntityID
822: and (wco.reco_path_seq_num between c_fst_rec_seq_seq and c_lst_rec_seq_seq)
823: order by wco.reco_path_seq_num;
824:

Line 891: from WSM_COPY_OPERATIONS wco

887: l_stat_num := 30.1;
888: BEGIN
889: select wco.reco_path_seq_num
890: into l_fst_rec_seq_num
891: from WSM_COPY_OPERATIONS wco
892: where wco.wip_entity_id = p_wipEntityID
893: and wco.operation_sequence_id = p_curJobOpSeqId;
894: EXCEPTION
895: when no_data_found then

Line 923: from WSM_COPY_OPERATIONS wco

919: if(p_opSeqNum IS NOT NULL and p_opSeqNum > 0) then
920: BEGIN
921: select wco.reco_path_seq_num
922: into l_the_rec_seq_num
923: from WSM_COPY_OPERATIONS wco
924: where wco.wip_entity_id = p_wipEntityID
925: and wco.operation_seq_num = p_opSeqNum;
926: EXCEPTION
927: when no_data_found then

Line 1364: from wsm_copy_operations

1360: select reco_start_date,
1361: reco_completion_date
1362: into l_OpStartDate(1),
1363: l_OpEndDate(1)
1364: from wsm_copy_operations
1365: where wip_entity_id = p_wipEntityID
1366: and organization_id = p_orgID
1367: and operation_seq_num = l_curOp;
1368: end if;

Line 1618: update wsm_copy_operations

1614:
1615: l_stat_num := 80;
1616: --update operations WCO
1617: forall i in l_cnt_wo+1..p_opTbl.count
1618: update wsm_copy_operations
1619: set reco_start_date = l_OpStartDate(i),
1620: reco_completion_date = l_OpEndDate(i),
1621: reco_scheduled_quantity = l_OpQty(i),
1622: ----standard who columns----

Line 1640: update wsm_copy_operations

1636:
1637: --bug 6345672: begin
1638: l_stat_num := 85;
1639: if g_update_current_op and l_cnt_wo is not NULL and l_cnt_wo > 0 THEN --bug 6345672
1640: update wsm_copy_operations
1641: set reco_start_date = l_OpStartDate(l_cnt_wo),
1642: reco_completion_date = l_OpEndDate(l_cnt_wo),
1643: reco_scheduled_quantity = l_OpQty(l_cnt_wo),
1644: ----standard who columns----