APPS.INV_LABEL dependencies on WIP_FLOW_SCHEDULES

Line 2283: l_wip_entity_id WIP_FLOW_SCHEDULES.WIP_ENTITY_ID%TYPE;

2279: l_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;
2280: l_total_schedule_number NUMBER;
2281: l_schedule_number NUMBER;
2282: l_to_schedule_number NUMBER;
2283: l_wip_entity_id WIP_FLOW_SCHEDULES.WIP_ENTITY_ID%TYPE;
2284: l_range_schedule_numbers serial_tab_type;
2285: l_lot_control_code NUMBER := 1;
2286: --Bug8329454
2287: l_rev_control_code NUMBER := 1;

Line 2487: FROM WIP_FLOW_SCHEDULES

2483: FOR i IN 1..l_range_schedule_numbers.count LOOP
2484: /* retrieve wip_entity_id from wip_flow_schedule */
2485: BEGIN
2486: SELECT wip_entity_id into l_wip_entity_id
2487: FROM WIP_FLOW_SCHEDULES
2488: WHERE organization_id = p_organization_id
2489: AND schedule_number = l_range_schedule_numbers(i);
2490:
2491: EXCEPTION