APPS.WSMPLBMI dependencies on MTL_TRANSACTIONS_INTERFACE

Line 11472: from MTL_TRANSACTIONS_INTERFACE

11468: BEGIN
11469: BEGIN
11470: select count(*)
11471: into l_mti_rows
11472: from MTL_TRANSACTIONS_INTERFACE
11473: where transaction_header_id = p_mtl_txn_hdr_id;
11474: EXCEPTION
11475: WHEN no_data_found THEN
11476: l_mti_rows := 0;

Line 11506: mtl_transactions_interface MTI

11502: CURSOR C_MTLI IS
11503: SELECT MTLI.TRANSACTION_INTERFACE_ID, MTLI.LOT_NUMBER, MTLI.TRANSACTION_QUANTITY,
11504: MTLI.PRIMARY_QUANTITY
11505: FROM mtl_transaction_lots_interface MTLI,
11506: mtl_transactions_interface MTI
11507: WHERE MTI.TRANSACTION_HEADER_ID = p_mtl_txn_hdr_id
11508: AND MTI.TRANSACTION_INTERFACE_ID = MTLI.TRANSACTION_INTERFACE_ID;
11509: BEGIN
11510: FOR rec in C_MTLI LOOP

Line 11548: UPDATE MTL_TRANSACTIONS_INTERFACE MTL

11544:
11545: IF (l_mti_rows > 0) THEN
11546:
11547:
11548: UPDATE MTL_TRANSACTIONS_INTERFACE MTL
11549: SET MTL.wip_entity_type = WIP_CONSTANTS.LOTBASED,
11550: --bug 5584140 operation_seq_num is already stamped in the UI and there could be multiple
11551: --operation seq nums so don't overwrite. Get department_id for each operation
11552: --operation_seq_num = p_fm_operation_seq_num,

Line 11572: from mtl_transactions_interface

11568: x_trans_count => x_trans_count);
11569:
11570: select count(*)
11571: into l_numErrRows
11572: from mtl_transactions_interface
11573: where transaction_header_id = p_mtl_txn_hdr_id;
11574:
11575: select count(*)
11576: into l_numTempRows

Line 11600: from mtl_transactions_interface mti,

11596: IF (x_return_status = g_ret_success) THEN
11597: if(l_numErrRows <> 0) then
11598: select msik.concatenated_segments, mti.error_explanation
11599: bulk collect into l_itemNameTbl,l_errExplTbl
11600: from mtl_transactions_interface mti,
11601: mtl_system_items_kfv msik
11602: where mti.transaction_header_id = p_mtl_txn_hdr_id
11603: and mti.error_explanation is not null
11604: and mti.inventory_item_id = msik.inventory_item_id