DBA Data[Home] [Help]

APPS.WIP_WICTPG dependencies on MTL_MATERIAL_TXN_ALLOCATIONS

Line 2120: x_purge_rec.table_name := 'MTL_MATERIAL_TXN_ALLOCATIONS';

2116: -- reset message; check for allocations
2117: fnd_message.set_name('WIP', 'WIP_ALLOCATIONS_EXIST');
2118: x_purge_rec.info := fnd_message.get;
2119:
2120: x_purge_rec.table_name := 'MTL_MATERIAL_TXN_ALLOCATIONS';
2121: SELECT COUNT(*) into l_num_rows
2122: FROM DUAL
2123: WHERE EXISTS (SELECT 1
2124: FROM MTL_MATERIAL_TXN_ALLOCATIONS

Line 2124: FROM MTL_MATERIAL_TXN_ALLOCATIONS

2120: x_purge_rec.table_name := 'MTL_MATERIAL_TXN_ALLOCATIONS';
2121: SELECT COUNT(*) into l_num_rows
2122: FROM DUAL
2123: WHERE EXISTS (SELECT 1
2124: FROM MTL_MATERIAL_TXN_ALLOCATIONS
2125: WHERE REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
2126: AND ORGANIZATION_ID = x_purge_rec.org_id);
2127: x_records_found := x_records_found OR (l_num_rows > 0);
2128: if ( l_num_rows > 0 ) then