APPS.WIP_BFLPROC_PRIV dependencies on MTL_TRANSACTIONS_INTERFACE

Line 91: from mtl_transactions_interface mti,

87: -1 * mti.primary_quantity priQty, --make qty relative to wip (relative to inv in table)
88: -1 * mti.transaction_quantity txnQty, --make qty relative to wip (relative to inv in table)
89: msi.lot_control_code lotControlCode,
90: msi.serial_number_control_code serialNumControlCode
91: from mtl_transactions_interface mti,
92: mtl_system_items_b msi
93: where mti.transaction_header_id = p_txnHdrID
94: and mti.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,
95: wip_constants.issnegc_action, wip_constants.retnegc_action)

Line 247: from mtl_transactions_interface mti

243: /* BUG 4712505 */
244: cursor c_checkExistingMTI(x_opSeqNum NUMBER, x_inventoryItemID NUMBER,
245: x_txnActionID NUMBER, x_txnTypeID NUMBER) IS
246: select 1
247: from mtl_transactions_interface mti
248: where mti.transaction_source_id = p_wipEntityID
249: and mti.organization_id = p_orgID
250: and mti.operation_seq_num = x_opSeqNum
251: and mti.inventory_item_id = x_inventoryItemID

Line 547: update mtl_transactions_interface

543: wip_logger.log('found existing requirement',l_returnStatus);
544: end if;
545: if(fnd_api.to_boolean(p_mergeMode)) then
546: --user wants to merge requirements. Update the txn qty
547: update mtl_transactions_interface
548: set last_update_date = sysdate,
549: last_updated_by = fnd_global.user_id,
550: last_update_login = fnd_global.login_id,
551: request_id = fnd_global.conc_request_id,

Line 626: insert into mtl_transactions_interface

622: l_created_by:= fnd_global.user_id;
623: end;
624: /* End of fix for Bug 5444243 */
625:
626: insert into mtl_transactions_interface
627: (last_update_date,
628: last_updated_by,
629: creation_date,
630: created_by,

Line 2633: FROM mtl_transactions_interface

2629: END IF; -- Repetive schedule
2630:
2631: SELECT COUNT(*)
2632: INTO l_bf_count
2633: FROM mtl_transactions_interface
2634: WHERE transaction_header_id = p_txnHdrID
2635: AND transaction_action_id IN (WIP_CONSTANTS.ISSCOMP_ACTION,
2636: WIP_CONSTANTS.RETCOMP_ACTION,
2637: WIP_CONSTANTS.ISSNEGC_ACTION,

Line 2641: FROM mtl_transactions_interface mti,

2637: WIP_CONSTANTS.ISSNEGC_ACTION,
2638: WIP_CONSTANTS.RETNEGC_ACTION);
2639: SELECT COUNT(*)
2640: INTO l_lot_ser_count
2641: FROM mtl_transactions_interface mti,
2642: mtl_system_items msi
2643: WHERE mti.organization_id = msi.organization_id
2644: AND mti.inventory_item_id = msi.inventory_item_id
2645: AND (msi.lot_control_code = WIP_CONSTANTS.LOT