[Home] [Help]
530: wmat.primary_quantity,
531: rowidtochar(wrs.rowid),
532: rowidtochar(wo.rowid)
533: from wip_operations wo,
534: wip_repetitive_schedules wrs,
535: wip_mtl_allocations_temp wmat
536: where wrs.wip_entity_id = p_cplRec.wipEntityID
537: and wrs.line_id = p_cplRec.repLineID
538: and wrs.status_type in (wip_constants.released, wip_constants.comp_chrg)
643: else
644: l_status := wip_constants.released;
645: end if;
646:
647: update wip_repetitive_schedules
648: set quantity_completed = quantity_completed + l_schedRecTbl.preAlcQty(i),
649: status_type = l_status,
650: last_updated_by = fnd_global.user_id,
651: last_update_date = sysdate,
927: nvl(wo.quantity_waiting_to_move,
928: ((wrs.daily_production_rate * wrs.processing_work_days) - wrs.quantity_completed)) availQty,
929: nvl(sum(wmat.primary_quantity), 0) tempQty
930: from wip_operations wo,
931: wip_repetitive_schedules wrs,
932: wip_mtl_allocations_temp wmat
933: where wrs.wip_entity_id = v_wipEntityID
934: and wrs.line_id = v_repLineID
935: and wrs.date_released < v_txnDate
952: select wrs.repetitive_schedule_id repSchedID,
953: wrs.bom_revision bomRev,
954: wrs.quantity_completed availQty,
955: nvl(sum(wmat.primary_quantity), 0) tempQty
956: from wip_repetitive_schedules wrs,
957: wip_mtl_allocations_temp wmat
958: where wrs.wip_entity_id = v_wipEntityID
959: and wrs.line_id = v_repLineID
960: and wrs.date_released < v_txnDate
1141: if(p_txnActionID = wip_constants.cplassy_action) then
1142: if(l_schedRecTbl.availQty(j) is null) then
1143: select ((wrs.daily_production_rate * wrs.processing_work_days) - wrs.quantity_completed) - nvl(sum(wo.quantity_scrapped), 0)
1144: into l_schedRecTbl.availQty(j)
1145: from wip_repetitive_schedules wrs,
1146: wip_operations wo
1147: where wrs.wip_entity_id = p_wipEntityID
1148: and wrs.repetitive_schedule_id = l_schedRecTbl.repSchedID(j)
1149: and wrs.repetitive_schedule_id = wo.repetitive_schedule_id (+)
1352: select wrs.repetitive_schedule_id,
1353: ((wrs.daily_production_rate * wrs.processing_work_days) - wrs.quantity_completed) startQty,
1354: wrs.quantity_completed cplQty,
1355: sum(wmat.primary_quantity) tempQty
1356: from wip_repetitive_schedules wrs,
1357: wip_mtl_allocations_temp wmat
1358: where wrs.wip_entity_id = p_wipEntityID
1359: and wrs.line_id = p_repLineID
1360: and wrs.status_type in (wip_constants.released, wip_constants.comp_chrg)