APPS.WSMPLBMI dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 11579: from mtl_material_transactions_temp

11575: where transaction_header_id = p_mtl_txn_hdr_id;
11576:
11577: select count(*)
11578: into l_numTempRows
11579: from mtl_material_transactions_temp
11580: where transaction_header_id = p_mtl_txn_hdr_id;
11581:
11582: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
11583: l_msg_tokens.delete;

Line 11698: FROM mtl_material_transactions_temp

11694: BEGIN
11695:
11696: SELECT count(*)
11697: INTO l_mmtt_rows
11698: FROM mtl_material_transactions_temp
11699: WHERE transaction_header_id = p_mtl_txn_hdr_id;
11700:
11701: SELECT count(*)
11702: INTO l_mtlt_rows

Line 11703: FROM mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt

11699: WHERE transaction_header_id = p_mtl_txn_hdr_id;
11700:
11701: SELECT count(*)
11702: INTO l_mtlt_rows
11703: FROM mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt
11704: WHERE mmtt.transaction_header_id = p_mtl_txn_hdr_id
11705: AND mtlt.TRANSACTION_TEMP_ID = mmtt.TRANSACTION_TEMP_ID;
11706:
11707: SELECT count(*)

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