[Home] [Help]
View: SO_REPORT_PRINTERS_QF_V
View Text
SELECT RP.ROWID ROW_ID
, RP.REPORT_ID
, RP.LEVEL_TYPE_ID
, RP.LEVEL_VALUE_ID
, RP.CREATION_DATE
, RP.CREATED_BY
, RP.LAST_UPDATE_DATE
, RP.LAST_UPDATED_BY
, RP.LAST_UPDATE_LOGIN
, P.PRINTER_NAME
, RP.ENABLE_FLAG
, RP.DESCRIPTION
, F.USER_CONCURRENT_PROGRAM_NAME REPORT_NAME
, DECODE(RP.LEVEL_TYPE_ID
, 10001
, V.PROFILE_OPTION_VALUE
, 10002
, A.APPLICATION_NAME
, 10003
, RY.RESPONSIBILITY_NAME
, 10004
, U.USER_NAME) LEVEL_NAME
FROM FND_PROFILE_OPTION_VALUES V
, FND_USER U
, FND_RESPONSIBILITY_TL RY
, FND_CONCURRENT_PROGRAMS_VL F
, FND_APPLICATION_TL A
, FND_PRINTER_TL P
, SO_REPORTS R
, SO_REPORT_PRINTERS RP
WHERE RP.REPORT_ID = R.REPORT_ID
AND R.NAME = F.CONCURRENT_PROGRAM_NAME
AND RP.PRINTER_NAME = P.PRINTER_NAME
AND RP.LEVEL_VALUE_ID = A.APPLICATION_ID(+)
AND RP.LEVEL_VALUE_ID = RY.RESPONSIBILITY_ID(+)
AND RP.LEVEL_VALUE_ID = U.USER_ID(+)
AND RP.LEVEL_VALUE_ID = V.LEVEL_VALUE(+)
AND V.PROFILE_OPTION_ID(+) = 125
AND RP.APPLICATION_ID = RY.APPLICATION_ID (+)
AND RP.APPLICATION_ID = V.APPLICATION_ID (+)
Columns
Name |
ROW_ID |
REPORT_ID |
LEVEL_TYPE_ID |
LEVEL_VALUE_ID |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
PRINTER_NAME |
ENABLE_FLAG |
DESCRIPTION |
REPORT_NAME |
LEVEL_NAME |