APPS.INV_LABEL dependencies on WIP_FLOW_SCHEDULES

Line 2222: l_wip_entity_id WIP_FLOW_SCHEDULES.WIP_ENTITY_ID%TYPE;

2218: l_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;
2219: l_total_schedule_number NUMBER;
2220: l_schedule_number NUMBER;
2221: l_to_schedule_number NUMBER;
2222: l_wip_entity_id WIP_FLOW_SCHEDULES.WIP_ENTITY_ID%TYPE;
2223: l_range_schedule_numbers serial_tab_type;
2224:
2225: l_lot_control_code NUMBER := 1;
2226:

Line 2418: FROM WIP_FLOW_SCHEDULES

2414: FOR i IN 1..l_range_schedule_numbers.count LOOP
2415: /* retrieve wip_entity_id from wip_flow_schedule */
2416: BEGIN
2417: SELECT wip_entity_id into l_wip_entity_id
2418: FROM WIP_FLOW_SCHEDULES
2419: WHERE organization_id = p_organization_id
2420: AND schedule_number = l_range_schedule_numbers(i);
2421:
2422: EXCEPTION