eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_BFLPROC_PRIV dependencies on MTL_TRANSACTIONS_INTERFACE

Line 90: from mtl_transactions_interface mti,

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

Line 246: from mtl_transactions_interface mti

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

Line 555: update mtl_transactions_interface

551: wip_logger.log('found existing requirement',l_returnStatus);
552: end if;
553: if(fnd_api.to_boolean(p_mergeMode)) then
554: --user wants to merge requirements. Update the txn qty
555: update mtl_transactions_interface
556: set last_update_date = sysdate,
557: last_updated_by = fnd_global.user_id,
558: last_update_login = fnd_global.login_id,
559: request_id = fnd_global.conc_request_id,

Line 634: insert into mtl_transactions_interface

630: l_created_by:= fnd_global.user_id;
631: end;
632: /* End of fix for Bug 5444243 */
633:
634: insert into mtl_transactions_interface
635: (last_update_date,
636: last_updated_by,
637: creation_date,
638: created_by,

Line 2610: UPDATE MTL_TRANSACTIONS_INTERFACE

2606: x_compTbl => l_compTbl,
2607: x_returnStatus => l_returnStatus);
2608: --Bug#16315556(FP of bug#16343002): Transaction_Batch_id is set for overcompletion as it is set to null in processRequirements
2609: -- This will ensure that components are not transacted if the assembly transaction fails
2610: UPDATE MTL_TRANSACTIONS_INTERFACE
2611: SET TRANSACTION_BATCH_ID=p_batchID,transaction_Batch_seq=l_batch_seq
2612: WHERE TRANSACTION_HEADER_ID=p_txnHdrID and transaction_source_type_id=5 and transaction_source_id=p_wipEntityID
2613: AND transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,
2614: wip_constants.issnegc_action, wip_constants.retnegc_action);

Line 2694: FROM mtl_transactions_interface mti

2690:
2691: --Updated as per Bug#9544120
2692: SELECT COUNT(*)
2693: INTO l_bf_count
2694: FROM mtl_transactions_interface mti
2695: WHERE mti.transaction_header_id = p_txnHdrID
2696: AND mti.transaction_action_id IN (WIP_CONSTANTS.ISSCOMP_ACTION,
2697: WIP_CONSTANTS.RETCOMP_ACTION,
2698: WIP_CONSTANTS.ISSNEGC_ACTION,

Line 2719: FROM mtl_transactions_interface mti,

2715: -- Bug 9907143: updated for serial tagging enhancement for SUN
2716: /*
2717: SELECT COUNT(*)
2718: INTO l_lot_ser_count
2719: FROM mtl_transactions_interface mti,
2720: mtl_system_items msi
2721: WHERE mti.organization_id = msi.organization_id
2722: AND mti.inventory_item_id = msi.inventory_item_id
2723: AND (msi.lot_control_code = WIP_CONSTANTS.LOT

Line 2736: FROM mtl_transactions_interface mti,

2732: */
2733: --Updated as per Bug#9544120
2734: SELECT COUNT(*)
2735: INTO l_lot_ser_count
2736: FROM mtl_transactions_interface mti,
2737: mtl_system_items msi
2738: WHERE mti.organization_id = msi.organization_id
2739: AND mti.inventory_item_id = msi.inventory_item_id
2740: AND (msi.lot_control_code = WIP_CONSTANTS.LOT