1170:
1171: -- this is for specific OSFM validation
1172: SELECT COUNT (1)
1173: INTO l_lot_count
1174: FROM wip_entities
1175: WHERE wip_entity_name = p_rs_lot_num_tbl (i)
1176: AND organization_id = p_organization_id;
1177:
1178: IF l_lot_count > 0
1240: l_validation_status := 'Y';
1241:
1242: SELECT COUNT (1)
1243: INTO l_lot_count
1244: FROM wip_entities
1245: WHERE organization_id = p_organization_id
1246: AND wip_entity_name = p_rs_lot_num_tbl (1);
1247:
1248: IF l_lot_count > 0
1297: print_debug('after validating against mtl_lot_numbers', 'validate_result_lot');
1298: END IF;
1299: SELECT count(1)
1300: INTO l_lot_count
1301: FROM WIP_ENTITIES
1302: WHERE organization_id = p_organization_id
1303: AND wip_entity_name = p_rs_lot_num_tbl(1);
1304:
1305: if( l_lot_count = 0 ) then
1303: AND wip_entity_name = p_rs_lot_num_tbl(1);
1304:
1305: if( l_lot_count = 0 ) then
1306: IF (l_debug = 1) THEN
1307: print_debug('after validating against wip_entities', 'validate_result_lot');
1308: END IF;
1309: SELECT COUNT(1)
1310: INTO l_lot_count
1311: FROM MTL_TRANSACTION_LOTS_TEMP MTLT, MTL_MATERIAL_TRANSACTIONS_TEMP MMTT