FND Design Data [Home] [Help]

View: FND_REQUEST_SETS_VL

Product: FND - Application Object Library
Description: View of FND_REQUEST_SETS and FND_REQUEST_SETS_TL
Implementation/DBA Data: ViewAPPS.FND_REQUEST_SETS_VL
View Text

SELECT B.ROWID ROW_ID
, B.APPLICATION_ID
, B.REQUEST_SET_ID
, B.REQUEST_SET_NAME
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.ALLOW_CONSTRAINTS_FLAG
, B.PRINT_TOGETHER_FLAG
, B.START_DATE_ACTIVE
, B.START_STAGE
, B.END_DATE_ACTIVE
, B.CONCURRENT_PROGRAM_ID
, B.OWNER
, B.PRINTER
, B.PRINT_STYLE
, B.ICON_NAME
, T.USER_REQUEST_SET_NAME
, T.DESCRIPTION
FROM FND_REQUEST_SETS_TL T
, FND_REQUEST_SETS B
WHERE B.REQUEST_SET_ID = T.REQUEST_SET_ID
AND B.APPLICATION_ID = T.APPLICATION_ID
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
APPLICATION_ID
REQUEST_SET_ID
REQUEST_SET_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
ALLOW_CONSTRAINTS_FLAG
PRINT_TOGETHER_FLAG
START_DATE_ACTIVE
START_STAGE
END_DATE_ACTIVE
CONCURRENT_PROGRAM_ID
OWNER
PRINTER
PRINT_STYLE
ICON_NAME
USER_REQUEST_SET_NAME
DESCRIPTION