APPS.WSMPLBMI dependencies on MTL_TRANSACTIONS_INTERFACE

Line 11474: from MTL_TRANSACTIONS_INTERFACE

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

Line 11508: mtl_transactions_interface MTI

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

Line 11550: UPDATE MTL_TRANSACTIONS_INTERFACE MTL

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

Line 11574: from mtl_transactions_interface

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

Line 11602: from mtl_transactions_interface mti,

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