DBA Data[Home] [Help]

APPS.MTL_LOT_UOM_CONV_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 1486: FROM mtl_transactions_interface

1482: ============================================*/
1483:
1484: CURSOR c_check_mti IS
1485: SELECT 1
1486: FROM mtl_transactions_interface
1487: WHERE source_lot_number = p_lot_number
1488: AND inventory_item_id = p_inventory_item_id
1489: AND organization_id = p_organization_id
1490: AND transaction_type_id NOT IN (95,1004);

Line 1498: FROM mtl_transactions_interface

1494: Type from 96 to 1004.
1495: ========================*/
1496: CURSOR c_check_mti_head IS
1497: SELECT 1
1498: FROM mtl_transactions_interface
1499: WHERE source_lot_number = p_lot_number
1500: AND inventory_item_id = p_inventory_item_id
1501: AND organization_id = p_organization_id
1502: AND transaction_type_id NOT IN (95,1004)