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
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
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
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(+)