DBA Data[Home] [Help]

APPS.WMS_WAVE_PLANNING_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 7564: mtl_onhand_quantities_Detail moqd

7560: MSIB.PRIMARY_UOM_CODE) AS CONVERSION_RATE,
7561: MSI.PICKING_ORDER
7562: from MTL_SECONDARY_INVENTORIES MSI,
7563: MTL_SYSTEM_ITEMS_B MSIB,
7564: mtl_onhand_quantities_Detail moqd
7565: WHERE MSIB.organization_id = l_org_id
7566: and MSIB.INVENTORY_ITEM_ID = l_item_id
7567: AND MSI.PICK_UOM_CODE IS NOT NULL
7568: AND (MSI.SECONDARY_INVENTORY_NAME = v_picking_subinventory or

Line 9566: from mtl_onhand_quantities_detail moqd

9562: wsh_delivery_details wdd2,
9563: wsh_delivery_assignments wda
9564: where wdd2.
9565: lpn_id in (select distinct lpn_id
9566: from mtl_onhand_quantities_detail moqd
9567: where locator_id = p_consol_locator_id)
9568: and WND.DELIVERY_ID(+) = WDA.DELIVERY_ID
9569: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
9570: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id(+);