View: FA_RX_CR_REPORTS_V

Product:	OFA - Assets
Description:	- Retrofitted
Implementation/DBA Data:	APPS.FA_RX_CR_REPORTS_V

View Text

SELECT RX.ROWID ROW_ID
, RX.REPORT_ID
, A.APPLICATION_NAME
, RX.APPLICATION_ID
, RX.RESPONSIBILITY_ID
, TO_CHAR(NULL) RESPONSIBILITY_NAME
, RGU.REQUEST_GROUP_ID
, RX.CONCURRENT_PROGRAM_FLAG
, RX.CONCURRENT_PROGRAM_ID
, CP.CONCURRENT_PROGRAM_NAME
, CP.USER_CONCURRENT_PROGRAM_NAME USER_PROGRAM_NAME
, RX.INTERFACE_TABLE
, RX.LAST_UPDATE_DATE
, RX.LAST_UPDATED_BY
, RX.CREATED_BY
, RX.CREATION_DATE
, RX.LAST_UPDATE_LOGIN
, RX.WHERE_CLAUSE_API
, RX.PURGE_API
FROM FND_APPLICATION_ALL_VIEW A
, FND_REQUEST_GROUP_UNITS RGU
, FND_CONCURRENT_PROGRAMS_VL CP
, FA_RX_REPORTS RX
WHERE RX.APPLICATION_ID = A.APPLICATION_ID
AND RX.APPLICATION_ID = RGU.APPLICATION_ID
AND RGU.REQUEST_UNIT_ID = CP.CONCURRENT_PROGRAM_ID
AND RX.CONCURRENT_PROGRAM_ID = CP.CONCURRENT_PROGRAM_ID
AND RX.APPLICATION_ID = CP.APPLICATION_ID UNION SELECT RX.ROWID ROW_ID
, RX.REPORT_ID
, A.APPLICATION_NAME
, A.APPLICATION_ID
, RX.RESPONSIBILITY_ID
, TO_CHAR(NULL) RESPONSIBILITY_NAME
, RGU.REQUEST_GROUP_ID
, RX.CONCURRENT_PROGRAM_FLAG
, RX.CONCURRENT_PROGRAM_ID
, CP.CONCURRENT_PROGRAM_NAME
, CP.USER_CONCURRENT_PROGRAM_NAME USER_PROGRAM_NAME
, RX.INTERFACE_TABLE
, RX.LAST_UPDATE_DATE
, RX.LAST_UPDATED_BY
, RX.CREATED_BY
, RX.CREATION_DATE
, RX.LAST_UPDATE_LOGIN
, RX.WHERE_CLAUSE_API
, RX.PURGE_API
FROM FND_APPLICATION_ALL_VIEW A
, FND_REQUEST_GROUP_UNITS RGU
, FND_CONCURRENT_PROGRAMS_VL CP
, FA_RX_REPORTS RX
WHERE RGU.APPLICATION_ID = A.APPLICATION_ID
AND RX.APPLICATION_ID = RGU.UNIT_APPLICATION_ID
AND RGU.REQUEST_UNIT_TYPE = 'A'
AND RX.CONCURRENT_PROGRAM_ID = CP.CONCURRENT_PROGRAM_ID
AND RX.APPLICATION_ID = CP.APPLICATION_ID

Columns