VIEW: APPS.FA_RX_CR_REPORTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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