APPS.INV_MINMAX_PVT dependencies on MTL_DEMAND

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

1453: , 9);
1454: END IF;
1455:
1456: --
1457: -- select unreserved qty from mtl_demand for non oe rows.
1458: --
1459: IF p_net_unrsv = 1 THEN
1460: /*4518296*/
1461: select sum(PRIMARY_UOM_QUANTITY - GREATEST(NVL(RESERVATION_QUANTITY,0),

Line 1464: from mtl_demand

1460: /*4518296*/
1461: select sum(PRIMARY_UOM_QUANTITY - GREATEST(NVL(RESERVATION_QUANTITY,0),
1462: NVL(COMPLETED_QUANTITY,0)))
1463: into qty
1464: from mtl_demand
1465: WHERE RESERVATION_TYPE = 1
1466: AND parent_demand_id IS NULL
1467: AND ORGANIZATION_ID = p_org_id
1468: and PRIMARY_UOM_QUANTITY > GREATEST(NVL(RESERVATION_QUANTITY,0),

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

1499: AND mln.availability_type = decode(p_include_nonnet,1,mln.availability_type,1)));
1500: /* nsinghi MIN-MAX INVCONV end */
1501:
1502: IF G_TRACE_ON = 1 THEN
1503: print_debug('Demand from mtl_demand: ' || to_char(qty), 'get_demand_qty', 9);
1504: END IF;
1505: total := total + NVL(qty,0);
1506: END IF;
1507:

Line 1970: -- WIP Reservations from mtl_demand

1966: auto-create requisition and for sales orders with ATO items after
1967: auto-create WIP job. Commenting the below code which fetches duplicate
1968: demand */
1969:
1970: -- WIP Reservations from mtl_demand
1971: --
1972: /* IF p_level = 1 THEN
1973: --
1974: -- SUBINVENTORY IS Always expected to be Null when Reservation_type is 3.

Line 1979: from mtl_demand

1975: --
1976: select sum(PRIMARY_UOM_QUANTITY - GREATEST(NVL(RESERVATION_QUANTITY,0),
1977: NVL(COMPLETED_QUANTITY,0)))
1978: into qty
1979: from mtl_demand
1980: where RESERVATION_TYPE = 3
1981: and ORGANIZATION_ID = p_org_id
1982: and PRIMARY_UOM_QUANTITY >
1983: GREATEST(NVL(RESERVATION_QUANTITY,0), NVL(COMPLETED_QUANTITY,0))

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

1985: and REQUIREMENT_DATE <= p_d_cutoff
1986: and p_net_rsv = 1;
1987:
1988: IF G_TRACE_ON = 1 THEN
1989: print_debug('WIP Reservations from mtl_demand: ' || to_char(qty)
1990: , 'get_demand_qty'
1991: , 9);
1992: END IF;
1993: total := total + NVL(qty,0);