APPS.INV_MINMAX_PVT dependencies on OE_DROP_SHIP_SOURCES

Line 1085: AND NOT EXISTS (SELECT ''X'' FROM OE_DROP_SHIP_SOURCES ODSS

1081: OR :l_level = 2
1082: )
1083: AND (:l_level = 1 OR to_subinventory = :l_subinv)
1084: -- Bug 5041763 Not considering supply from drop ship orders
1085: AND NOT EXISTS (SELECT ''X'' FROM OE_DROP_SHIP_SOURCES ODSS
1086: WHERE DECODE(sup.PO_HEADER_ID, NULL, sup.REQ_LINE_ID, sup.PO_LINE_LOCATION_ID) =
1087: DECODE(sup.PO_HEADER_ID,NULL, ODSS.REQUISITION_LINE_ID, ODSS.LINE_LOCATION_ID)) ';
1088:
1089:

Line 1682: FROM OE_DROP_SHIP_SOURCES ODSS

1678: AND mln.inventory_item_id = p_item_id
1679: AND mln.availability_type = decode(p_include_nonnet,1,mln.availability_type,1)))
1680: -- Bug 5041763 excluding drop ship demand
1681: and NOT EXISTS (SELECT 1
1682: FROM OE_DROP_SHIP_SOURCES ODSS
1683: WHERE ODSS.LINE_ID = DEMAND_SOURCE_LINE_ID);
1684:
1685: /* nsinghi MIN-MAX INVCONV end */
1686:

Line 2274: FROM OE_DROP_SHIP_SOURCES ODSS

2270: 1,
2271: S.availability_type,
2272: 1)))
2273: and EXISTS (SELECT 1
2274: FROM OE_DROP_SHIP_SOURCES ODSS
2275: WHERE ODSS.LINE_ID = DEMAND_SOURCE_LINE_ID);
2276: total := total + NVL(qty,0);
2277: --Bug 6240025 BEGIN
2278: l_loaded_qty := get_loaded_qty(p_org_id