APPS.WSMPLBMI dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 11577: from mtl_material_transactions_temp

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

Line 11696: FROM mtl_material_transactions_temp

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

Line 11701: FROM mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt

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

Line 11707: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt

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