APPS.FLM_AUTO_REPLENISHMENT dependencies on WIP_FLOW_SCHEDULES

Line 620: UPDATE wip_flow_schedules

616: p_schedule_number IN VARCHAR2) IS
617:
618: BEGIN
619:
620: UPDATE wip_flow_schedules
621: SET auto_replenish = 'Y'
622: WHERE schedule_number = p_Schedule_Number;
623:
624: END Update_Flow_Schedule;

Line 794: FROM wip_flow_schedules flow,

790: flow.scheduled_start_date scheduled_start_date,
791: flow.scheduled_completion_date scheduled_completion_date,
792: flow.alternate_bom_designator alternate_bom_designator,
793: flow.alternate_routing_designator alternate_routing_designator
794: FROM wip_flow_schedules flow,
795: wip_lines lines
796: WHERE flow.planned_quantity - nvl(flow.quantity_completed, 0) > 0
797: AND flow.status <> 2
798: AND flow.scheduled_completion_date <= (l_server_compl_date + 1)

Line 871: FROM wip_flow_schedules

867: -- Lock the flow schedule for update of auto_replenish flag
868: BEGIN
869: SELECT auto_replenish
870: INTO l_auto_replenish
871: FROM wip_flow_schedules
872: WHERE schedule_number = l_schedule_number
873: FOR UPDATE OF auto_replenish NOWAIT;
874: EXCEPTION
875: WHEN OTHERS THEN

Line 954: FROM wip_flow_schedules

950:
951: -- Replenish the Cards
952: SELECT wip_entity_id
953: INTO l_wip_entity_id
954: FROM wip_flow_schedules
955: WHERE schedule_number = l_comp_table(l_comp_count).schedule_number
956: AND organization_id = p_organization_id;
957:
958: INV_Kanban_GRP.Update_Card_Supply_Status(