VIEW: APPS.FND_CONCURRENT_PROGRAMS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.RESOURCE_CONSUMER_GROUP, B.ROLLBACK_SEGMENT, B.OPTIMIZER_MODE, B.SECURITY_GROUP_ID, B.APPLICATION_ID, B.CONCURRENT_PROGRAM_ID , B.CONCURRENT_PROGRAM_NAME, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.EXECUTABLE_APPLICATION_ID, B.EXECUTABLE_ID, B.EXECUTION_METHOD_CODE, B.ARGUMENT_METHOD_CODE, B.QUEUE_CONTROL_FLAG, B.QUEUE_METHOD_CODE, B.REQUEST_SET_FLAG, B.ENABLED_FLAG, B.PRINT_FLAG, B.RUN_ALONE_FLAG, B.SRS_FLAG, B.CLASS_APPLICATION_ID, B.CONCURRENT_CLASS_ID, B.EXECUTION_OPTIONS, B.SAVE_OUTPUT_FLAG, B.REQUIRED_STYLE, B.OUTPUT_PRINT_STYLE, B.PRINTER_NAME, B.MINIMUM_WIDTH, B.MINIMUM_LENGTH, B.REQUEST_PRIORITY, B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE15, B.IPROG_ID, B.OUTPUT_FILE_TYPE, B.ENABLE_TRACE, B.RESTART, B.NLS_COMPLIANT, B.ICON_NAME, B.CD_PARAMETER, B.INCREMENT_PROC, B.MLS_EXECUTABLE_APP_ID, B.MLS_EXECUTABLE_ID, B.ENABLE_TIME_STATISTICS, B.REFRESH_PORTLET, B.PROGRAM_TYPE, B.ACTIVITY_SUMMARIZER, B.REQUEST_SCH_INTERVAL, B.ALLOW_MULTIPLE_PENDING_REQUEST, B.DELETE_LOG_FILE, B.TEMPLATE_APPL_SHORT_NAME, B.TEMPLATE_CODE, B.MULTI_ORG_CATEGORY,T.USER_CONCURRENT_PROGRAM_NAME, T.DESCRIPTION FROM FND_CONCURRENT_PROGRAMS_TL T, FND_CONCURRENT_PROGRAMS B WHERE B.APPLICATION_ID = T.APPLICATION_ID and B.CONCURRENT_PROGRAM_ID = T.CONCURRENT_PROGRAM_ID and T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.RESOURCE_CONSUMER_GROUP
, B.ROLLBACK_SEGMENT
, B.OPTIMIZER_MODE
, B.SECURITY_GROUP_ID
, B.APPLICATION_ID
, B.CONCURRENT_PROGRAM_ID
, B.CONCURRENT_PROGRAM_NAME
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.EXECUTABLE_APPLICATION_ID
, B.EXECUTABLE_ID
, B.EXECUTION_METHOD_CODE
, B.ARGUMENT_METHOD_CODE
, B.QUEUE_CONTROL_FLAG
, B.QUEUE_METHOD_CODE
, B.REQUEST_SET_FLAG
, B.ENABLED_FLAG
, B.PRINT_FLAG
, B.RUN_ALONE_FLAG
, B.SRS_FLAG
, B.CLASS_APPLICATION_ID
, B.CONCURRENT_CLASS_ID
, B.EXECUTION_OPTIONS
, B.SAVE_OUTPUT_FLAG
, B.REQUIRED_STYLE
, B.OUTPUT_PRINT_STYLE
, B.PRINTER_NAME
, B.MINIMUM_WIDTH
, B.MINIMUM_LENGTH
, B.REQUEST_PRIORITY
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.IPROG_ID
, B.OUTPUT_FILE_TYPE
, B.ENABLE_TRACE
, B.RESTART
, B.NLS_COMPLIANT
, B.ICON_NAME
, B.CD_PARAMETER
, B.INCREMENT_PROC
, B.MLS_EXECUTABLE_APP_ID
, B.MLS_EXECUTABLE_ID
, B.ENABLE_TIME_STATISTICS
, B.REFRESH_PORTLET
, B.PROGRAM_TYPE
, B.ACTIVITY_SUMMARIZER
, B.REQUEST_SCH_INTERVAL
, B.ALLOW_MULTIPLE_PENDING_REQUEST
, B.DELETE_LOG_FILE
, B.TEMPLATE_APPL_SHORT_NAME
, B.TEMPLATE_CODE
, B.MULTI_ORG_CATEGORY
, T.USER_CONCURRENT_PROGRAM_NAME
, T.DESCRIPTION
FROM FND_CONCURRENT_PROGRAMS_TL T
, FND_CONCURRENT_PROGRAMS B
WHERE B.APPLICATION_ID = T.APPLICATION_ID
AND B.CONCURRENT_PROGRAM_ID = T.CONCURRENT_PROGRAM_ID
AND T.LANGUAGE = USERENV('LANG')