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.WSMPUTIL dependencies on MTL_MATERIAL_TRANSACTIONS

Line 3586: --mtl_material_transactions_temp also.

3582: If l_qty_at_tomove = 0 Then -- BBK
3583:
3584: BEGIN
3585: --This SQL is commented out.New SQL is added that includes
3586: --mtl_material_transactions_temp also.
3587: /*
3588: select sum(primary_quantity)
3589: into l_dummy_number
3590: from mtl_material_transactions

Line 3590: from mtl_material_transactions

3586: --mtl_material_transactions_temp also.
3587: /*
3588: select sum(primary_quantity)
3589: into l_dummy_number
3590: from mtl_material_transactions
3591: where organization_id = p_organization_id
3592: and transaction_source_id = p_wip_entity_id
3593: and operation_seq_num = p_op_seq_num
3594: --and transaction_source_type_id = 5 -- Job or Schedule

Line 3611: from mtl_material_transactions

3607: select sum(primary_quantity)
3608: into l_dummy_number
3609: from (
3610: select inventory_item_id,primary_quantity
3611: from mtl_material_transactions
3612: where organization_id = p_organization_id
3613: and transaction_source_id = p_wip_entity_id
3614: and operation_seq_num = p_op_seq_num
3615: and ((transaction_source_type_id = 5

Line 3622: from mtl_material_transactions_temp

3618: or transaction_type_id not in (55, 56, 57, 58)
3619: )
3620: union all
3621: select inventory_item_id,primary_quantity
3622: from mtl_material_transactions_temp
3623: where organization_id = p_organization_id
3624: and transaction_source_id = p_wip_entity_id
3625: and operation_seq_num = p_op_seq_num
3626: and ((transaction_source_type_id = 5