View: FA_RX_REPORTS_V

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

View Text

SELECT RX.ROWID ROW_ID
, RX.REPORT_ID REPORT_ID
, AP.APPLICATION_NAME APPLICATION_NAME
, RX.APPLICATION_ID APPLICATION_ID
, TO_NUMBER(NULL) RESPONSIBILITY_ID
, NULL RESPONSIBILITY_NAME
, TO_NUMBER(NULL) REQUEST_GROUP_ID
, RX.CONCURRENT_PROGRAM_FLAG CONCURRENT_PROGRAM_FLAG
, CP.CONCURRENT_PROGRAM_ID CONCURRENT_PROGRAM_ID
, CP.CONCURRENT_PROGRAM_NAME CONCURRENT_PROGRAM_NAME
, CP.USER_CONCURRENT_PROGRAM_NAME USER_PROGRAM_NAME
, RX.INTERFACE_TABLE INTERFACE_TABLE
, RX.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RX.LAST_UPDATED_BY LAST_UPDATED_BY
, RX.CREATED_BY CREATED_BY
, RX.CREATION_DATE CREATION_DATE
, RX.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RX.WHERE_CLAUSE_API WHERE_CLAUSE_API
, RX.PURGE_API PURGE_API
FROM FND_CONCURRENT_PROGRAMS_VL CP
, FND_APPLICATION_ALL_VIEW AP
, FA_RX_REPORTS RX
WHERE CP.APPLICATION_ID = RX.APPLICATION_ID
AND CP.CONCURRENT_PROGRAM_ID = RX.CONCURRENT_PROGRAM_ID AND AP.APPLICATION_ID = RX.APPLICATION_ID
AND NVL(RX.CONCURRENT_PROGRAM_FLAG
, 'N') = 'Y' UNION ALL SELECT RX.ROWID
, RX.REPORT_ID
, AP.APPLICATION_NAME
, RX.APPLICATION_ID
, RX.RESPONSIBILITY_ID
, RS.RESPONSIBILITY_NAME
, TO_NUMBER(NULL)
, RX.CONCURRENT_PROGRAM_FLAG
, TO_NUMBER(NULL)
, RX.CONCURRENT_PROGRAM_NAME
, RX.SELECT_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_RESPONSIBILITY_VL RS
, FND_APPLICATION_ALL_VIEW AP
, FA_RX_REPORTS RX
WHERE RS.APPLICATION_ID = RX.APPLICATION_ID
AND RS.RESPONSIBILITY_ID = RX.RESPONSIBILITY_ID AND AP.APPLICATION_ID = RX.APPLICATION_ID
AND NVL(RX.CONCURRENT_PROGRAM_FLAG
, 'N') = 'N'

Columns