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_SYSTEM_ITEMS_KFV

Line 288: mtl_system_items_kfv msi,

284: msi.serial_number_control_code,
285: msi.lot_control_code,
286: mmtt.revision
287: from mtl_material_transactions_temp mmtt,
288: mtl_system_items_kfv msi,
289: mtl_transaction_lots_temp mtlt
290: where mmtt.completion_transaction_id = p_cplTxnID
291: and mmtt.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,
292: wip_constants.issnegc_action, wip_constants.retnegc_action)

Line 331: mtl_system_items_kfv msi,

327: msi.serial_number_control_code,
328: msi.lot_control_code,
329: mmtt.revision
330: from mtl_material_transactions_temp mmtt,
331: mtl_system_items_kfv msi,
332: mtl_transaction_lots_temp mtlt
333: where mmtt.move_transaction_id = p_movTxnID
334: and mmtt.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,
335: wip_constants.issnegc_action, wip_constants.retnegc_action)

Line 659: mtl_system_items_kfv msi,

655: mti.revision,
656: mti.move_transaction_id,
657: mti.completion_transaction_id
658: from mtl_transactions_interface mti,
659: mtl_system_items_kfv msi,
660: mtl_transaction_lots_interface mtli
661: where mti.transaction_header_id = p_txnHdrID
662: and mti.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,
663: wip_constants.issnegc_action, wip_constants.retnegc_action)

Line 707: mtl_system_items_kfv msi,

703: mti.revision,
704: mti.move_transaction_id,
705: mti.completion_transaction_id
706: from mtl_transactions_interface mti,
707: mtl_system_items_kfv msi,
708: mtl_transaction_lots_interface mtli
709: where mti.transaction_header_id = p_txnHdrID
710: and ( mti.completion_transaction_id = p_cplTxnID
711: or mti.move_transaction_id in (p_movTxnID, p_childMovTxnID))

Line 754: mtl_system_items_kfv msi,

750: msi.serial_number_control_code,
751: msi.lot_control_code,
752: mti.revision
753: from mtl_material_transactions_temp mti,
754: mtl_system_items_kfv msi,
755: mtl_transaction_lots_temp mtlt
756: where mti.move_transaction_id = p_movTxnID
757: and mti.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,
758: wip_constants.issnegc_action, wip_constants.retnegc_action)