SELECT name, max(description) description, max(batch_source_id) batch_source_id, max(org_id) org_id, 'Y' get_all from ra_batch_sources_all WHERE batch_source_type = 'FOREIGN' and org_id is not null /* 9676826 */ group by name UNION ALL select name, description, batch_source_id, org_id, 'N' get_all from ra_batch_sources_all where batch_source_type = 'FOREIGN'
SELECT NAME
, MAX(DESCRIPTION) DESCRIPTION
, MAX(BATCH_SOURCE_ID) BATCH_SOURCE_ID
, MAX(ORG_ID) ORG_ID
, 'Y' GET_ALL
FROM RA_BATCH_SOURCES_ALL
WHERE BATCH_SOURCE_TYPE = 'FOREIGN'
AND ORG_ID IS NOT NULL /* 9676826 */ GROUP BY NAME UNION ALL SELECT NAME
, DESCRIPTION
, BATCH_SOURCE_ID
, ORG_ID
, 'N' GET_ALL
FROM RA_BATCH_SOURCES_ALL
WHERE BATCH_SOURCE_TYPE = 'FOREIGN'
|
|
|