APPS.CSP_MINMAX_PVT dependencies on MTL_DEMAND

Line 1468: -- select unreserved qty from mtl_demand for non oe rows.

1464: , 9);
1465: END IF;
1466:
1467: --
1468: -- select unreserved qty from mtl_demand for non oe rows.
1469: --
1470: IF p_net_unrsv = 1 THEN
1471: select sum(PRIMARY_UOM_QUANTITY - GREATEST(NVL(RESERVATION_QUANTITY,0),
1472: NVL(COMPLETED_QUANTITY,0)))

Line 1474: from mtl_demand

1470: IF p_net_unrsv = 1 THEN
1471: select sum(PRIMARY_UOM_QUANTITY - GREATEST(NVL(RESERVATION_QUANTITY,0),
1472: NVL(COMPLETED_QUANTITY,0)))
1473: into qty
1474: from mtl_demand
1475: WHERE RESERVATION_TYPE = 1
1476: AND parent_demand_id IS NULL
1477: AND ORGANIZATION_ID = p_org_id
1478: and PRIMARY_UOM_QUANTITY > GREATEST(NVL(RESERVATION_QUANTITY,0),

Line 1496: print_debug('Demand from mtl_demand: ' || to_char(qty), 'get_demand_qty', 9);

1492: 1,
1493: S.availability_type,
1494: 1)));
1495:
1496: print_debug('Demand from mtl_demand: ' || to_char(qty), 'get_demand_qty', 9);
1497: total := total + NVL(qty,0);
1498: END IF;
1499:
1500: --

Line 1799: -- WIP Reservations from mtl_demand

1795:
1796: end if; -- end if level=1
1797:
1798: --
1799: -- WIP Reservations from mtl_demand
1800: --
1801: IF p_level = 1 THEN
1802: --
1803: -- SUBINVENTORY IS Always expected to be Null when Reservation_type is 3.

Line 1808: from mtl_demand

1804: --
1805: select sum(PRIMARY_UOM_QUANTITY - GREATEST(NVL(RESERVATION_QUANTITY,0),
1806: NVL(COMPLETED_QUANTITY,0)))
1807: into qty
1808: from mtl_demand
1809: where RESERVATION_TYPE = 3
1810: and ORGANIZATION_ID = p_org_id
1811: and PRIMARY_UOM_QUANTITY >
1812: GREATEST(NVL(RESERVATION_QUANTITY,0), NVL(COMPLETED_QUANTITY,0))

Line 1817: print_debug('WIP Reservations from mtl_demand: ' || to_char(qty)

1813: and INVENTORY_ITEM_ID = p_item_id
1814: and REQUIREMENT_DATE <= p_d_cutoff
1815: and p_net_rsv = 1;
1816:
1817: print_debug('WIP Reservations from mtl_demand: ' || to_char(qty)
1818: , 'get_demand_qty'
1819: , 9);
1820: total := total + NVL(qty,0);
1821: END IF;