View: FND_REQ_SET_RUN_FORM_V

Product:	FND - Application Object Library
Description:	- Retrofitted
Implementation/DBA Data:	APPS.FND_REQ_SET_RUN_FORM_V

View Text

SELECT FRSP.ROWID ROW_ID
, FRSP.SET_APPLICATION_ID
, FRSP.REQUEST_SET_ID
, FRSP.REQUEST_SET_STAGE_ID
, FRSP.REQUEST_SET_PROGRAM_ID
, FRSP.SEQUENCE
, FRSP.LAST_UPDATE_DATE
, FRSP.LAST_UPDATED_BY
, FRSP.CREATION_DATE
, FRSP.CREATED_BY
, FRSP.LAST_UPDATE_LOGIN
, FRSP.PROGRAM_APPLICATION_ID
, FRSP.CONCURRENT_PROGRAM_ID
, FRSP.NUMBER_OF_COPIES
, FRSP.PRINTER
, FRSP.PRINT_STYLE
, FRSP.SAVE_OUTPUT_FLAG
, FRSP.NLS_LANGUAGE
, FRSP.NLS_TERRITORY
, FRSP.CRITICAL
, FCP.USER_CONCURRENT_PROGRAM_NAME
, A.APPLICATION_SHORT_NAME
, FCP.CONCURRENT_PROGRAM_NAME
, '$SRS$.'||FCP.CONCURRENT_PROGRAM_NAME DESCRIPTIVE_FLEXFIELD_NAME
, FCP.PRINTER_NAME FCP_PRINTER
, FCP.OUTPUT_PRINT_STYLE FCP_PRINT_STYLE
, FCP.REQUIRED_STYLE
, FCP.SAVE_OUTPUT_FLAG FCP_SAVE_OUTPUT_FLAG
, FCP.SRS_FLAG
, FCP.MULTI_ORG_CATEGORY
, FRSS.USER_STAGE_NAME
, FRSS.DISPLAY_SEQUENCE
, FCP.NLS_COMPLIANT
, FLT.DESCRIPTION LANGUAGE
, FCP.EXECUTION_METHOD_CODE
FROM FND_CONCURRENT_PROGRAMS_VL FCP
, FND_APPLICATION_VL A
, FND_REQUEST_SET_PROGRAMS FRSP
, FND_REQUEST_SET_STAGES_VL FRSS
, FND_LANGUAGES_TL FLT
, FND_LANGUAGES FL
WHERE A.APPLICATION_ID = FRSP.PROGRAM_APPLICATION_ID
AND FCP.APPLICATION_ID = FRSP.PROGRAM_APPLICATION_ID
AND FCP.CONCURRENT_PROGRAM_ID = FRSP.CONCURRENT_PROGRAM_ID
AND FRSS.SET_APPLICATION_ID = FRSP.SET_APPLICATION_ID
AND FRSS.REQUEST_SET_ID = FRSP.REQUEST_SET_ID
AND FRSS.REQUEST_SET_STAGE_ID = FRSP.REQUEST_SET_STAGE_ID
AND FL.NLS_LANGUAGE(+) = FRSP.NLS_LANGUAGE
AND FLT.LANGUAGE_CODE(+) = FL.LANGUAGE_CODE
AND FLT.LANGUAGE(+) = USERENV('LANG')

Columns