VIEW: APPS.FA_RX_NOCR_REPORTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'