APPS.INV_MINMAX_PVT dependencies on WIP_FLOW_SCHEDULES

Line 1383: FROM wip_flow_schedules

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

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

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