APPS.INV_LOT_API_PUB dependencies on MTL_MATERIAL_TRANSACTIONS

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 8689: l_revision mtl_material_transactions.revision%type; --Bug 12716806

8685: ll_sqs NUMBER;
8686: ll_satt NUMBER;
8687: ll_satr NUMBER;
8688: l_revision_qty_control_code NUMBER ; --Bug 12716806
8689: l_revision mtl_material_transactions.revision%type; --Bug 12716806
8690:
8691: /*====================================
8692: Get item details:
8693: - lot_divisible_flag = Y(divisible), N(indivisible), NULL(divisible)

Line 8735: FROM mtl_transaction_lot_numbers mtln, mtl_material_transactions mmt

8731:
8732: /*Bug#9717803 any issue transaction other than the misc issue */
8733: CURSOR cur_any_consumptions IS
8734: SELECT 1
8735: FROM mtl_transaction_lot_numbers mtln, mtl_material_transactions mmt
8736: WHERE mtln.organization_id = p_organization_id
8737: AND mtln.inventory_item_id = p_inventory_item_id
8738: AND mtln.lot_number = p_lot_number
8739: AND mtln.transaction_id = mmt.transaction_id

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;