APPS.INV_LABEL_PVT4 dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 474: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

470: , mmtt.subinventory_code /*from sub, to select printer*/
471: , abs(nvl(mtlt.secondary_quantity, -- invconv fabdi
472: mmtt.secondary_transaction_quantity)) secondary_quantity
473: , mmtt.secondary_uom_code -- invconv fabdi
474: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
475: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
476: AND mmtt.transaction_temp_id = p_transaction_id;
477:
478: CURSOR c_mmtt_pregen_lpn IS

Line 763: , mtl_transaction_lots_temp mtlt

759: , mtlt.expiration_action_code
760: , mtlt.supplier_lot_number
761: FROM mtl_parameters mp
762: , mtl_system_items_kfv msik
763: , mtl_transaction_lots_temp mtlt
764: , mtl_material_transactions_temp mmtt
765: , po_hazard_classes poh
766: , mtl_material_statuses_vl mmsv
767: WHERE msik.inventory_item_id = p_item_id

Line 1993: FROM MTL_TRANSACTION_LOTS_TEMP

1989: END IF;
1990: BEGIN -- End Bug# 15896768
1991: SELECT LOT_NUMBER
1992: INTO p_lot_number
1993: FROM MTL_TRANSACTION_LOTS_TEMP
1994: WHERE TRANSACTION_TEMP_ID = p_transaction_id;
1995: EXCEPTION
1996: WHEN OTHERS THEN
1997: p_lot_number := NULL;

Line 2025: FROM MTL_TRANSACTION_LOTS_TEMP

2021: -- multiple labels getting fired when PO received into more than one lot
2022: BEGIN
2023: SELECT LOT_NUMBER
2024: INTO p_lot_number
2025: FROM MTL_TRANSACTION_LOTS_TEMP
2026: WHERE TRANSACTION_TEMP_ID = p_transaction_id;
2027: EXCEPTION WHEN OTHERS
2028: THEN
2029: p_lot_number := NULL;