DBA Data[Home] [Help]

APPS.WSMPLBMI dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 11709: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt

11705: AND mtlt.TRANSACTION_TEMP_ID = mmtt.TRANSACTION_TEMP_ID;
11706:
11707: SELECT count(*)
11708: INTO l_msnt_rows
11709: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt
11710: WHERE mmtt.transaction_header_id = p_mtl_txn_hdr_id
11711: AND msnt.TRANSACTION_TEMP_ID = mmtt.TRANSACTION_TEMP_ID;
11712:
11713: IF (x_return_status = g_ret_success) THEN