APPS.INV_LOT_API_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1073: FROM mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt

1069: mtlt.n_attribute10,
1070: mtlt.territory_code,
1071: mtlt.vendor_name,
1072: p_parent_lot_number -- bug 10176719 - inserting parent_lot_number
1073: FROM mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt
1074: WHERE mtlt.transaction_temp_id = p_transaction_temp_id
1075: AND mtlt.lot_number = p_lot_number
1076: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
1077: AND NOT EXISTS ( SELECT NULL

Line 2445: mtl_material_transactions_temp mmtt

2441: CURSOR mtlt_cur_2
2442: IS
2443: SELECT lot.lot_number
2444: FROM mtl_transaction_lots_temp lot,
2445: mtl_material_transactions_temp mmtt
2446: WHERE lot.transaction_temp_id = mmtt.transaction_temp_id
2447: AND lot.lot_number = p_auto_lot_number
2448: AND mmtt.inventory_item_id <> p_inventory_item_id;
2449:

Line 2453: FROM mtl_material_transactions_temp lot

2449:
2450: CURSOR mmtt_cur_2
2451: IS
2452: SELECT lot_number
2453: FROM mtl_material_transactions_temp lot
2454: WHERE lot_number = p_auto_lot_number
2455: AND inventory_item_id <> p_inventory_item_id;
2456: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2457: BEGIN

Line 2771: mtl_material_transactions_temp mmtt

2767: Removed check for existing parent lot.
2768: CURSOR mtlt_cur_1 IS
2769: SELECT lot.lot_number
2770: FROM mtl_transaction_lots_temp lot,
2771: mtl_material_transactions_temp mmtt
2772: WHERE lot.transaction_temp_id = mmtt.transaction_temp_id
2773: AND lot.lot_number = p_parent_lot_number
2774: AND inventory_item_id = p_inventory_item_id;
2775:

Line 3654: mtl_material_transactions_temp mmtt

3650: CURSOR mtlt_cur_1
3651: IS
3652: SELECT lot.lot_number
3653: FROM mtl_transaction_lots_temp lot,
3654: mtl_material_transactions_temp mmtt
3655: WHERE lot.transaction_temp_id = mmtt.transaction_temp_id
3656: AND lot.lot_number = p_auto_lot_number
3657: AND mmtt.inventory_item_id = p_inventory_item_id;
3658:

Line 3662: FROM mtl_material_transactions_temp lot

3658:
3659: CURSOR mmtt_cur_1
3660: IS
3661: SELECT lot_number
3662: FROM mtl_material_transactions_temp lot
3663: WHERE lot_number = p_auto_lot_number
3664: AND inventory_item_id = p_inventory_item_id;
3665: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3666: BEGIN

Line 11030: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

11026:
11027:
11028: begin
11029: select transaction_action_id INTO l_transaction_action_id
11030: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
11031: WHERE transaction_temp_id=p_transaction_temp_id;
11032: EXCEPTION
11033: WHEN No_Data_Found THEN
11034: l_transaction_action_id:=NULL;