VIEW: APPS.SO_REPORT_PRINTERS_QF_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)