DBA Data[Home] [Help]

APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 3270: FROM mtl_material_transactions_temp mmtt

3266: IS
3267: SELECT mmtt.transaction_temp_id , mmtt.subinventory_code ,
3268: mmtt.locator_id , mmtt.inventory_item_id ,
3269: mmtt.lpn_id , mmtt.item_lot_control_code
3270: FROM mtl_material_transactions_temp mmtt
3271: WHERE mmtt.transfer_lpn_id = p_lpn_id
3272: AND NVL(mmtt.lpn_id,-99) <> p_lpn_id
3273: AND NVL(mmtt.content_lpn_id,-99) <> p_lpn_id;
3274: CURSOR mtlt_cur(l_transaction_temp_id NUMBER)

Line 3787: FROM mtl_material_transactions_temp mmtt

3783: IS SELECT mmtt.transaction_temp_id , mmtt.subinventory_code,
3784: mmtt.transaction_type_id,
3785: mmtt.locator_id , mmtt.inventory_item_id ,
3786: nvl(mmtt.lpn_id,mmtt.content_lpn_id) lpn_id , mmtt.item_lot_control_code
3787: FROM mtl_material_transactions_temp mmtt
3788: where mmtt.transfer_lpn_id = p_fromlpn_id
3789: AND mmtt.transaction_source_type_id = 2
3790: AND mmtt.transaction_type_id = 52
3791: AND Nvl(l_cur_inventory_item_id,inventory_item_id)=inventory_item_id;