VIEW: APPS.FA_RX_REPORTS_V

Source

View Text - Preformatted

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'                

View Text - HTML Formatted

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'