View: AR_AI_BATCH_SOURCE_V

Product:	AR - Receivables
Description:	Selects batch sources based on the org returned from ar_ai_org_v. Each batch source (name) should appear on the list only once.
Implementation/DBA Data:	APPS.AR_AI_BATCH_SOURCE_V

View Text

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' 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'

Columns