APPS.CSP_EXCESS_PARTS_PVT dependencies on MTL_DEMAND

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

1492: l_total_demand_qty := 0;
1493: l_demand_qty := 0;
1494: l_total_reserve_qty := 0;
1495:
1496: -- select unreserved qty from mtl_demand for non oe rows.
1497: select sum(PRIMARY_UOM_QUANTITY- GREATEST(NVL(RESERVATION_QUANTITY,0),nvl(COMPLETED_QUANTITY,0)))
1498: into qty
1499: from mtl_demand
1500: WHERE RESERVATION_TYPE = 1

Line 1499: from mtl_demand

1495:
1496: -- select unreserved qty from mtl_demand for non oe rows.
1497: select sum(PRIMARY_UOM_QUANTITY- GREATEST(NVL(RESERVATION_QUANTITY,0),nvl(COMPLETED_QUANTITY,0)))
1498: into qty
1499: from mtl_demand
1500: WHERE RESERVATION_TYPE = 1
1501: AND p_net_unreserved = 1
1502: AND parent_demand_id IS NULL
1503: AND ORGANIZATION_ID = p_organization_id

Line 1713: -- WIP Reservations from mtl_demand

1709: end if;
1710: total := total + nvl(l_demand_qty,0);
1711: end if;
1712:
1713: -- WIP Reservations from mtl_demand
1714: select sum(PRIMARY_UOM_QUANTITY - GREATEST(NVL(RESERVATION_QUANTITY,0),
1715: nvl(COMPLETED_QUANTITY,0)))
1716: into qty
1717: from mtl_demand

Line 1717: from mtl_demand

1713: -- WIP Reservations from mtl_demand
1714: select sum(PRIMARY_UOM_QUANTITY - GREATEST(NVL(RESERVATION_QUANTITY,0),
1715: nvl(COMPLETED_QUANTITY,0)))
1716: into qty
1717: from mtl_demand
1718: where RESERVATION_TYPE = 3
1719: and ORGANIZATION_ID = p_organization_id
1720: and PRIMARY_UOM_QUANTITY > GREATEST(NVL(RESERVATION_QUANTITY,0),
1721: nvl(COMPLETED_QUANTITY,0))