APPS.INV_MINMAX_PVT dependencies on WIP_FLOW_SCHEDULES

Line 1380: FROM wip_flow_schedules

1376: THEN
1377: SELECT SUM(NVL(planned_quantity,0)
1378: - NVL(quantity_completed,0))
1379: INTO l_qty
1380: FROM wip_flow_schedules
1381: WHERE organization_id = p_org_id
1382: AND primary_item_id = p_item_id
1383: AND status = 1
1384: AND scheduled_flag = 1 -- Bug 3151797

Line 1391: print_debug('Supply from WIP flow schedules: ' || to_char(l_qty)

1387: AND (NVL(planned_quantity,0)
1388: - NVL(quantity_completed,0)) > 0;
1389:
1390: IF G_TRACE_ON = 1 THEN
1391: print_debug('Supply from WIP flow schedules: ' || to_char(l_qty)
1392: , 'get_supply_qty'
1393: , 9);
1394: END IF;
1395: l_total := l_total + NVL(l_qty,0);