APPS.CSP_EXCESS_PARTS_PVT dependencies on MTL_DEMAND

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

1613: l_total_demand_qty := 0;
1614: l_demand_qty := 0;
1615: l_total_reserve_qty := 0;
1616:
1617: -- select unreserved qty from mtl_demand for non oe rows.
1618: select sum(PRIMARY_UOM_QUANTITY- GREATEST(NVL(RESERVATION_QUANTITY,0),nvl(COMPLETED_QUANTITY,0)))
1619: into qty
1620: from mtl_demand
1621: WHERE RESERVATION_TYPE = 1

Line 1620: from mtl_demand

1616:
1617: -- select unreserved qty from mtl_demand for non oe rows.
1618: select sum(PRIMARY_UOM_QUANTITY- GREATEST(NVL(RESERVATION_QUANTITY,0),nvl(COMPLETED_QUANTITY,0)))
1619: into qty
1620: from mtl_demand
1621: WHERE RESERVATION_TYPE = 1
1622: AND p_net_unreserved = 1
1623: AND parent_demand_id IS NULL
1624: AND ORGANIZATION_ID = p_organization_id

Line 1834: -- WIP Reservations from mtl_demand

1830: end if;
1831: total := total + nvl(l_demand_qty,0);
1832: end if;
1833:
1834: -- WIP Reservations from mtl_demand
1835: select sum(PRIMARY_UOM_QUANTITY - GREATEST(NVL(RESERVATION_QUANTITY,0),
1836: nvl(COMPLETED_QUANTITY,0)))
1837: into qty
1838: from mtl_demand

Line 1838: from mtl_demand

1834: -- WIP Reservations from mtl_demand
1835: select sum(PRIMARY_UOM_QUANTITY - GREATEST(NVL(RESERVATION_QUANTITY,0),
1836: nvl(COMPLETED_QUANTITY,0)))
1837: into qty
1838: from mtl_demand
1839: where RESERVATION_TYPE = 3
1840: and ORGANIZATION_ID = p_organization_id
1841: and PRIMARY_UOM_QUANTITY > GREATEST(NVL(RESERVATION_QUANTITY,0),
1842: nvl(COMPLETED_QUANTITY,0))