View: FA_RX_NOCR_REPORTS_V

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

View Text

SELECT RX.ROWID ROW_ID
, RX.REPORT_ID
, A.APPLICATION_NAME
, RX.APPLICATION_ID
, RX.RESPONSIBILITY_ID
, R.RESPONSIBILITY_NAME
, TO_NUMBER(NULL) REQUEST_GROUP_ID
, RX.CONCURRENT_PROGRAM_FLAG
, TO_NUMBER(NULL) CONCURRENT_PROGRAM_ID
, TO_CHAR(NULL) CONCURRENT_PROGRAM_NAME
, RX.SELECT_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_RESPONSIBILITY_VL R
, FND_APPLICATION_ALL_VIEW A
, FA_RX_REPORTS RX
WHERE R.APPLICATION_ID = RX.APPLICATION_ID
AND R.RESPONSIBILITY_ID = RX.RESPONSIBILITY_ID
AND RX.APPLICATION_ID = A.APPLICATION_ID
AND RX.CONCURRENT_PROGRAM_FLAG = 'N'

Columns