APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on WIP_ENTITIES

Line 1205: FROM wip_entities

1201:
1202: -- this is for specific OSFM validation
1203: SELECT COUNT (1)
1204: INTO l_lot_count
1205: FROM wip_entities
1206: WHERE wip_entity_name = p_rs_lot_num_tbl (i)
1207: AND organization_id = p_organization_id;
1208:
1209: IF l_lot_count > 0

Line 1290: FROM wip_entities

1286: END IF;
1287:
1288: SELECT COUNT (1)
1289: INTO l_lot_count
1290: FROM wip_entities
1291: WHERE organization_id = p_organization_id
1292: AND wip_entity_name = p_rs_lot_num_tbl (1);
1293:
1294: IF l_lot_count > 0

Line 1365: FROM WIP_ENTITIES

1361: print_debug('after validating against mtl_lot_numbers', 'validate_result_lot');
1362: END IF;
1363: SELECT count(1)
1364: INTO l_lot_count
1365: FROM WIP_ENTITIES
1366: WHERE organization_id = p_organization_id
1367: AND wip_entity_name = p_rs_lot_num_tbl(1);
1368:
1369: if( l_lot_count = 0 ) then

Line 1371: print_debug('after validating against wip_entities', 'validate_result_lot');

1367: AND wip_entity_name = p_rs_lot_num_tbl(1);
1368:
1369: if( l_lot_count = 0 ) then
1370: IF (l_debug = 1) THEN
1371: print_debug('after validating against wip_entities', 'validate_result_lot');
1372: END IF;
1373: SELECT COUNT(1)
1374: INTO l_lot_count
1375: FROM MTL_TRANSACTION_LOTS_TEMP MTLT, MTL_MATERIAL_TRANSACTIONS_TEMP MMTT