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 1685: FROM OE_DROP_SHIP_SOURCES ODSS

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

Line 2284: FROM OE_DROP_SHIP_SOURCES ODSS

2280: 1,
2281: S.availability_type,
2282: 1)))
2283: and EXISTS (SELECT 1
2284: FROM OE_DROP_SHIP_SOURCES ODSS
2285: WHERE ODSS.LINE_ID = DEMAND_SOURCE_LINE_ID);
2286: total := total + NVL(qty,0);
2287: --Bug 6240025 BEGIN
2288: l_loaded_qty := get_loaded_qty(p_org_id