Product: | FND - Application Object Library |
---|---|
Description: | View of FND_REQUEST_SETS and FND_REQUEST_SETS_TL |
Implementation/DBA Data: | APPS.FND_REQUEST_SETS_VL |
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')