DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

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 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