DBA Data[Home] [Help]

APPS.WMS_WAVE_PLANNING_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 7563: MTL_SYSTEM_ITEMS_B MSIB,

7559: MSI.PICK_UOM_CODE,
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

Line 13142: ',MTL_SYSTEM_ITEMS_B MSIB ';

13138: elsif cur_rec.parameter_id IN (5001, 5002, 5003, 5004, 2001, 5005) then
13139: --ITEM
13140: if v_item_flag = 'N' then
13141: g_Unreleased_SQL := g_Unreleased_SQL ||
13142: ',MTL_SYSTEM_ITEMS_B MSIB ';
13143: g_WHERE_SQL := g_WHERE_SQL ||
13144: ' WDD.INVENTORY_ITEM_ID=MSIB.INVENTORY_ITEM_ID AND ';
13145: end if;
13146: v_item_flag := 'Y';