DBA Data[Home] [Help]

APPS.WMS_WAVE_PLANNING_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 1877: MTL_SECONDARY_INVENTORIES MSI,

1873: inventory_item_id,
1874: dropping_order,
1875: transaction_quantity
1876: from mtl_material_transactions_temp mmtt,
1877: MTL_SECONDARY_INVENTORIES MSI,
1878: wms_zone_locators wzl1,
1879: wms_zone_locators wzl2,
1880: wms_zones_vl wz1,
1881: wms_zones_vl wz2

Line 1925: MTL_SECONDARY_INVENTORIES MSI

1921: inventory_item_id,
1922: dropping_order,
1923: transaction_quantity
1924: from mtl_material_transactions_temp mmtt,
1925: MTL_SECONDARY_INVENTORIES MSI
1926: where move_order_header_id = p_move_order_hdr_id
1927: AND mmtt.transfer_subinventory = msi.SECONDARY_INVENTORY_NAME
1928: AND mmtt.organization_id = msi.organization_id
1929: and parent_line_id = p_parent_line_id

Line 7562: from MTL_SECONDARY_INVENTORIES MSI,

7558: wms_wave_planning_pvt.get_conversion_rate(MSIB.INVENTORY_ITEM_id,
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

Line 9055: mtl_secondary_inventories msi,

9051: l_item_prim_uom_code,
9052: l_organization_id
9053: FROM mtl_material_transactions_temp mmtt,
9054: mtl_item_locations mil,
9055: mtl_secondary_inventories msi,
9056: mtl_system_items item
9057: WHERE mmtt.transaction_temp_id = l_mmtt_tbl(i)
9058: AND mmtt.locator_id = mil.inventory_location_id(+)
9059: AND mmtt.organization_id = mil.organization_id(+)