DBA Data[Home] [Help]

APPS.WMS_CROSS_DOCK_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 1690: FROM mtl_transaction_lots_temp

1686:
1687: -- Get lot info. Will always be only one lot
1688: SELECT lot_number,serial_transaction_temp_id INTO l_lot,
1689: l_serial_temp_id
1690: FROM mtl_transaction_lots_temp
1691: WHERE (transaction_temp_id in (select TRANSACTION_TEMP_ID from mtl_material_transactions_temp where PARENT_LINE_ID=l_temp_id)
1692: or transaction_temp_id = l_temp_id ) -- 11701595
1693: and rownum=1; -- Modified for Bug#8489892
1694: