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.CSI_ORDER_FULFILL_PUB dependencies on MTL_UNIT_TRANSACTIONS

Line 3610: FROM mtl_unit_transactions mut,

3606: mtt.transaction_type_name mtl_txn_name,
3607: mmt.transaction_action_id mtl_action_id,
3608: mmt.transaction_source_type_id mtl_source_type_id,
3609: mmt.transaction_source_id mtl_source_id
3610: FROM mtl_unit_transactions mut,
3611: mtl_material_transactions mmt,
3612: mtl_transaction_types mtt
3613: WHERE mut.serial_number = p_serial_number
3614: AND mut.inventory_item_id = p_item_id

Line 3627: FROM mtl_unit_transactions mut,

3623: mtt.transaction_type_name mtl_txn_name,
3624: mmt.transaction_action_id mtl_action_id,
3625: mmt.transaction_source_type_id mtl_source_type_id,
3626: mmt.transaction_source_id mtl_source_id
3627: FROM mtl_unit_transactions mut,
3628: mtl_transaction_lot_numbers mtln,
3629: mtl_material_transactions mmt,
3630: mtl_transaction_types mtt
3631: WHERE mut.serial_number = p_serial_number

Line 3755: mtl_unit_transactions mut

3751: CURSOR issued_srl_cur IS
3752: SELECT mut.serial_number,
3753: mut.inventory_item_id
3754: FROM mtl_material_transactions mmt,
3755: mtl_unit_transactions mut
3756: WHERE mmt.transaction_source_type_id = 5
3757: AND mmt.transaction_action_id = 1
3758: AND mmt.inventory_item_id = px_config_rec.sub_config_item_id
3759: AND mmt.transaction_source_id = px_config_rec.config_wip_job_id

Line 3767: mtl_unit_transactions mut

3763: SELECT mut.serial_number,
3764: mut.inventory_item_id
3765: FROM mtl_material_transactions mmt,
3766: mtl_transaction_lot_numbers mtln,
3767: mtl_unit_transactions mut
3768: WHERE mmt.transaction_source_type_id = 5
3769: AND mmt.transaction_action_id = 1
3770: AND mmt.inventory_item_id = px_config_rec.sub_config_item_id
3771: AND mmt.transaction_source_id = px_config_rec.config_wip_job_id

Line 10934: mtl_unit_transactions mut,

10930: to_number(null) ib_current_loc_id
10931: FROM oe_order_headers_all ooh,
10932: oe_order_lines_all ool,
10933: mtl_system_items msi,
10934: mtl_unit_transactions mut,
10935: mtl_material_transactions mmt,
10936: mtl_secondary_inventories msei,
10937: hr_all_organization_units haou
10938: WHERE mmt.transaction_id = p_mtl_txn_id

Line 10992: mtl_unit_transactions mut,

10988: to_number(null) ib_current_loc_id
10989: FROM oe_order_headers_all ooh,
10990: oe_order_lines_all ool,
10991: mtl_system_items msi,
10992: mtl_unit_transactions mut,
10993: mtl_transaction_lot_numbers mtln,
10994: mtl_material_transactions mmt,
10995: mtl_secondary_inventories msei,
10996: hr_all_organization_units haou