APPS.INV_MINMAX_PVT dependencies on MTL_DEMAND

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

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

Line 1461: from mtl_demand

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

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

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

Line 1967: -- WIP Reservations from mtl_demand

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

Line 1976: from mtl_demand

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

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

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