APPS.INV_LOT_API_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 958: FROM mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt

954: mtlt.supplier_lot_number,
955: mtlt.n_attribute10,
956: mtlt.territory_code,
957: mtlt.vendor_name
958: FROM mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt
959: WHERE mtlt.transaction_temp_id = p_transaction_temp_id
960: AND mtlt.lot_number = p_lot_number
961: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
962: AND NOT EXISTS ( SELECT NULL

Line 2326: mtl_material_transactions_temp mmtt

2322: CURSOR mtlt_cur_2
2323: IS
2324: SELECT lot.lot_number
2325: FROM mtl_transaction_lots_temp lot,
2326: mtl_material_transactions_temp mmtt
2327: WHERE lot.transaction_temp_id = mmtt.transaction_temp_id
2328: AND lot.lot_number = p_auto_lot_number
2329: AND mmtt.inventory_item_id <> p_inventory_item_id;
2330:

Line 2334: FROM mtl_material_transactions_temp lot

2330:
2331: CURSOR mmtt_cur_2
2332: IS
2333: SELECT lot_number
2334: FROM mtl_material_transactions_temp lot
2335: WHERE lot_number = p_auto_lot_number
2336: AND inventory_item_id <> p_inventory_item_id;
2337: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2338: BEGIN

Line 2624: mtl_material_transactions_temp mmtt

2620: Removed check for existing parent lot.
2621: CURSOR mtlt_cur_1 IS
2622: SELECT lot.lot_number
2623: FROM mtl_transaction_lots_temp lot,
2624: mtl_material_transactions_temp mmtt
2625: WHERE lot.transaction_temp_id = mmtt.transaction_temp_id
2626: AND lot.lot_number = p_parent_lot_number
2627: AND inventory_item_id = p_inventory_item_id;
2628:

Line 3495: mtl_material_transactions_temp mmtt

3491: CURSOR mtlt_cur_1
3492: IS
3493: SELECT lot.lot_number
3494: FROM mtl_transaction_lots_temp lot,
3495: mtl_material_transactions_temp mmtt
3496: WHERE lot.transaction_temp_id = mmtt.transaction_temp_id
3497: AND lot.lot_number = p_auto_lot_number
3498: AND mmtt.inventory_item_id = p_inventory_item_id;
3499:

Line 3503: FROM mtl_material_transactions_temp lot

3499:
3500: CURSOR mmtt_cur_1
3501: IS
3502: SELECT lot_number
3503: FROM mtl_material_transactions_temp lot
3504: WHERE lot_number = p_auto_lot_number
3505: AND inventory_item_id = p_inventory_item_id;
3506: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3507: BEGIN