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 3562: FROM mtl_unit_transactions mut,

3558: mtt.transaction_type_name mtl_txn_name,
3559: mmt.transaction_action_id mtl_action_id,
3560: mmt.transaction_source_type_id mtl_source_type_id,
3561: mmt.transaction_source_id mtl_source_id
3562: FROM mtl_unit_transactions mut,
3563: mtl_material_transactions mmt,
3564: mtl_transaction_types mtt
3565: WHERE mut.serial_number = p_serial_number
3566: AND mut.inventory_item_id = p_item_id

Line 3579: FROM mtl_unit_transactions mut,

3575: mtt.transaction_type_name mtl_txn_name,
3576: mmt.transaction_action_id mtl_action_id,
3577: mmt.transaction_source_type_id mtl_source_type_id,
3578: mmt.transaction_source_id mtl_source_id
3579: FROM mtl_unit_transactions mut,
3580: mtl_transaction_lot_numbers mtln,
3581: mtl_material_transactions mmt,
3582: mtl_transaction_types mtt
3583: WHERE mut.serial_number = p_serial_number

Line 3707: mtl_unit_transactions mut

3703: CURSOR issued_srl_cur IS
3704: SELECT mut.serial_number,
3705: mut.inventory_item_id
3706: FROM mtl_material_transactions mmt,
3707: mtl_unit_transactions mut
3708: WHERE mmt.transaction_source_type_id = 5
3709: AND mmt.transaction_action_id = 1
3710: AND mmt.inventory_item_id = px_config_rec.sub_config_item_id
3711: AND mmt.transaction_source_id = px_config_rec.config_wip_job_id

Line 3719: mtl_unit_transactions mut

3715: SELECT mut.serial_number,
3716: mut.inventory_item_id
3717: FROM mtl_material_transactions mmt,
3718: mtl_transaction_lot_numbers mtln,
3719: mtl_unit_transactions mut
3720: WHERE mmt.transaction_source_type_id = 5
3721: AND mmt.transaction_action_id = 1
3722: AND mmt.inventory_item_id = px_config_rec.sub_config_item_id
3723: AND mmt.transaction_source_id = px_config_rec.config_wip_job_id

Line 9918: mtl_unit_transactions mut,

9914: to_number(null) ib_current_loc_id
9915: FROM oe_order_headers_all ooh,
9916: oe_order_lines_all ool,
9917: mtl_system_items msi,
9918: mtl_unit_transactions mut,
9919: mtl_material_transactions mmt,
9920: mtl_secondary_inventories msei,
9921: hr_all_organization_units haou
9922: WHERE mmt.transaction_id = p_mtl_txn_id

Line 9976: mtl_unit_transactions mut,

9972: to_number(null) ib_current_loc_id
9973: FROM oe_order_headers_all ooh,
9974: oe_order_lines_all ool,
9975: mtl_system_items msi,
9976: mtl_unit_transactions mut,
9977: mtl_transaction_lot_numbers mtln,
9978: mtl_material_transactions mmt,
9979: mtl_secondary_inventories msei,
9980: hr_all_organization_units haou