APPS.CSP_MINMAX_PVT dependencies on WIP_FLOW_SCHEDULES

Line 1405: FROM wip_flow_schedules

1401: THEN
1402: SELECT SUM(NVL(planned_quantity,0)
1403: - NVL(quantity_completed,0))
1404: INTO l_qty
1405: FROM wip_flow_schedules
1406: WHERE organization_id = p_org_id
1407: AND primary_item_id = p_item_id
1408: AND status = 1
1409: --Bug 2647862

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

1410: AND trunc(scheduled_completion_date) <= p_s_cutoff
1411: AND (NVL(planned_quantity,0)
1412: - NVL(quantity_completed,0)) > 0;
1413:
1414: print_debug('Supply from WIP flow schedules: ' || to_char(l_qty)
1415: , 'get_supply_qty'
1416: , 9);
1417: l_total := l_total + NVL(l_qty,0);
1418: END IF;