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_AUTOLOTPROC_PRIV dependencies on MTL_TRANSACTIONS_INTERFACE

Line 657: from mtl_transactions_interface mti,

653: msi.lot_control_code,
654: mti.revision,
655: mti.move_transaction_id,
656: mti.completion_transaction_id
657: from mtl_transactions_interface mti,
658: mtl_system_items_kfv msi,
659: mtl_transaction_lots_interface mtli
660: where mti.transaction_header_id = p_txnHdrID
661: and mti.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,

Line 705: from mtl_transactions_interface mti,

701: msi.lot_control_code,
702: mti.revision,
703: mti.move_transaction_id,
704: mti.completion_transaction_id
705: from mtl_transactions_interface mti,
706: mtl_system_items_kfv msi,
707: mtl_transaction_lots_interface mtli
708: where mti.transaction_header_id = p_txnHdrID
709: and ( mti.completion_transaction_id = p_cplTxnID

Line 2250: from mtl_transactions_interface

2246: into l_qty
2247: from mtl_transaction_lots_interface
2248: where transaction_interface_id in
2249: (select transaction_interface_id
2250: from mtl_transactions_interface
2251: where inventory_item_id = p_inventory_item_id
2252: and organization_id = p_organization_id
2253: and subinventory_code = p_sub_code
2254: and nvl(locator_id, -1) = nvl(p_locator_id, -1))