APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_MATERIAL_TRANSACTIONS

Line 2343: mtl_material_transactions mmt,

2339: select X.status_id
2340: into l_default_status_id from
2341: (SELECT mtln.transaction_id, mtln.status_id
2342: FROM mtl_transaction_lot_numbers mtln,
2343: mtl_material_transactions mmt,
2344: rcv_shipment_lines rsl
2345: WHERE mmt.transaction_id = mtln.transaction_id
2346: AND mtln.inventory_item_id = p_inventory_item_id
2347: AND mmt.inventory_item_id = p_inventory_item_id

Line 2388: FROM mtl_transaction_lot_numbers mtln, mtl_material_transactions mmt

2384:
2385: select X.status_id
2386: into l_default_status_id from
2387: (SELECT mtln.transaction_id, mtln.status_id
2388: FROM mtl_transaction_lot_numbers mtln, mtl_material_transactions mmt
2389: WHERE mmt.transaction_id = mtln.transaction_id
2390: AND mtln.inventory_item_id = p_inventory_item_id
2391: AND mtln.organization_id = p_organization_id
2392: AND mtln.transaction_source_id = p_txn_source_id

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;