DBA Data[Home] [Help]

APPS.MTL_LOT_UOM_CONV_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 1468: FROM mtl_transactions_interface

1464: ============================================*/
1465:
1466: CURSOR c_check_mti IS
1467: SELECT 1
1468: FROM mtl_transactions_interface
1469: WHERE source_lot_number = p_lot_number
1470: AND inventory_item_id = p_inventory_item_id
1471: AND organization_id = p_organization_id
1472: AND transaction_type_id NOT IN (95,1004);

Line 1480: FROM mtl_transactions_interface

1476: Type from 96 to 1004.
1477: ========================*/
1478: CURSOR c_check_mti_head IS
1479: SELECT 1
1480: FROM mtl_transactions_interface
1481: WHERE source_lot_number = p_lot_number
1482: AND inventory_item_id = p_inventory_item_id
1483: AND organization_id = p_organization_id
1484: AND transaction_type_id NOT IN (95,1004)