eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AZ_SELECTION_SETS_VL

Product:	AZ - Application Implementation
Description:	AZ_SELECTION_SETS_VL
Implementation/DBA Data:	APPS.AZ_SELECTION_SETS_VL

View Text

SELECT B.ROWID ROW_ID
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.SELECTION_SET_CODE
, B.USER_ID
, B.STRUCTURE_CODE
, B.REF_SELECTION_SET_CODE
, B.ACTIVE
, B.HIERARCHICAL_FLAG
, B.PARTIAL_SELECTION
, B.CREATED_BY
, B.SOURCE_INSTANCE
, B.PREDEFINED_FLAG
, T.SELECTION_SET_NAME
, T.SELECTION_SET_DESC
FROM AZ_SELECTION_SETS_TL T
, AZ_SELECTION_SETS_B B
WHERE B.SELECTION_SET_CODE = T.SELECTION_SET_CODE
AND B.USER_ID = T.USER_ID
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
SELECTION_SET_CODE
USER_ID
STRUCTURE_CODE
REF_SELECTION_SET_CODE
ACTIVE
HIERARCHICAL_FLAG
PARTIAL_SELECTION
CREATED_BY
SOURCE_INSTANCE
PREDEFINED_FLAG
SELECTION_SET_NAME
SELECTION_SET_DESC