Home > Siebel > Finding Applet(List/Form) Name with Given Display Name from GUI on Siebel

Finding Applet(List/Form) Name with Given Display Name from GUI on Siebel

————————-
FOR LIST APPLETS
————————-
SELECT
T10.CONFLICT_ID,
T10.LAST_UPD,
T10.CREATED,
T10.LAST_UPD_BY,
T10.CREATED_BY,
T10.MODIFICATION_NUM,
T10.ROW_ID,
T9.UIFREEZE_FLG,
T9.UIFREEZE_BY,
T10.DET_APPLET_NAME,
T10.DISPLAYFORMAT,
T6.STRING_VALUE,
T8.STRING_VALUE,
T1.DISPLAY_NAME,
T1.APP_CD,
T10.AVAILABLE_FLG,
T1.AVAILABLE_FLG,
T10.BITMAP_COLHEAD_FLG,
T10.CHECKBITMAP,
T10.COMMENTS,
T10.DISPLAY_NAME_REF,
T10.FIELD_NAME,
T10.FIELD_RETRIEVAL_CD,
T5.MODULE_NAME,
T2.APPLET_ID,
T5.NAME,
T10.HTML_ATTR,
T1.LANG_CD,
T10.MVG_APPLET_NAME,
T10.HTML_DISPLAY_MODE,
T10.HTML_HEIGHT,
T1.HTML_HEIGHT,
T10.HTML_ICON_MAP,
T10.MODULE_NAME,
T10.NAME,
T5.OBJ_LOCKED_LANG,
T5.OBJ_LOCKED_FLG,
T5.OBJ_LOCKED_BY,
T5.BUSCOMP_NAME,
T10.LIST_ID,
T2.NAME,
T10.PICK_APPLET_NAME,
T10.POPUP_EDIT_FLG,
T5.PROJECT_ID,
T9.LOCKED_FLG,
T9.LOCKED_BY,
T10.VISIBLE,
T1.VISIBLE_FLG,
T10.SHOW_POPUP_FLG,
T10.TEXT_ALIGNMENT,
T1.TEXT_ALIGNMENT,
T10.LABEL_TXT_ALGNMENT,
T1.LABEL_TXT_ALGNMENT,
T10.HTML_EDIT_FLG,
T10.HTML_MAX_CHAR_DISP,
T1.HTML_MAX_CHAR_DISP,
T10.HTML_ONLY_FLG,
T10.HTML_ROW_SEN_FLG,
T10.HTML_SEQUENCE,
T1.HTML_SEQUENCE,
T10.HTML_TYPE,
T10.HTML_WIDTH,
T1.HTML_WIDTH,
T10.INACTIVE_FLG,
T9.NAME,
T10.TOTAL_CURRCODE,
T10.TOTAL_REQUIRED,
T10.TYPE,
T10.WIDTH,
T1.WIDTH,
T10.REPOSITORY_ID,
T3.NAME,
T10.RUNTIME_FLG,
T10.SEQUENCE,
T1.SEQUENCE,
T7.STRING_VALUE,
T4.STRING_VALUE,
T1.PROMPT_TEXT,
T10.PROMPT_TEXT_REF,
T10.READONLY,
T10.CONTENT_FIXUP_NAME
FROM
SIEBEL.S_LIST_COL_INTL T1,
SIEBEL.S_LIST T2,
SIEBEL.S_REPOSITORY T3,
SIEBEL.S_SYM_STR_INTL T4,
SIEBEL.S_APPLET T5,
SIEBEL.S_SYM_STR_INTL T6,
SIEBEL.S_SYM_STR_INTL T7,
SIEBEL.S_SYM_STR_INTL T8,
SIEBEL.S_PROJECT T9,
SIEBEL.S_LIST_COLUMN T10
WHERE
T5.PROJECT_ID = T9.ROW_ID (+) AND
T10.DISPLAY_NAME_REF = T6.SYM_STR_KEY (+) AND T10.REPOSITORY_ID = T6.REPOSITORY_ID (+) AND T6.APP_CD (+) = ‘STD’ AND T6.LANG_CD (+) = ‘ENU’ AND T6.INACTIVE_FLG (+) = ‘N’ AND
T10.DISPLAY_NAME_REF = T8.SYM_STR_KEY (+) AND T10.REPOSITORY_ID = T8.REPOSITORY_ID (+) AND T8.APP_CD (+) = ‘STD’ AND T8.LANG_CD (+) = ‘ENU’ AND T8.INACTIVE_FLG (+) = ‘N’ AND
T2.APPLET_ID = T5.ROW_ID AND
T10.ROW_ID = T1.LIST_COLUMN_ID (+) AND T1.APP_CD (+) = ‘STD’ AND T1.LANG_CD (+) = ‘ENU’ AND T1.INACTIVE_FLG (+) = ‘N’ AND
T10.PROMPT_TEXT_REF = T7.SYM_STR_KEY (+) AND T10.REPOSITORY_ID = T7.REPOSITORY_ID (+) AND T7.APP_CD (+) = ‘STD’ AND T7.LANG_CD (+) = ‘ENU’ AND T7.INACTIVE_FLG (+) = ‘N’ AND
T10.PROMPT_TEXT_REF = T4.SYM_STR_KEY (+) AND T10.REPOSITORY_ID = T4.REPOSITORY_ID (+) AND T4.APP_CD (+) = ‘STD’ AND T4.LANG_CD (+) = ‘ENU’ AND T4.INACTIVE_FLG (+) = ‘N’ AND
T10.LIST_ID = T2.ROW_ID AND
T10.REPOSITORY_ID = T3.ROW_ID (+) AND
(T10.REPOSITORY_ID IN (SELECT ROW_ID FROM SIEBEL.S_REPOSITORY WHERE NAME = ‘Siebel Repository’)) AND
((NVL (T1.DISPLAY_NAME, NVL (T8.STRING_VALUE, NVL (T6.STRING_VALUE, T6.STRING_VALUE)))) = __ADD_HERE_YOUR_FIELD_NAME_)
ORDER BY
T10.REPOSITORY_ID, T10.NAME;

——————————————————————————————————————

————————-
FOR FORM APPLETS
————————-
SELECT
T11.CONFLICT_ID,
T11.LAST_UPD,
T11.CREATED,
T11.LAST_UPD_BY,
T11.CREATED_BY,
T11.MODIFICATION_NUM,
T11.ROW_ID,
T11.BKGRND_COLOR,
T11.BITMAP_NAME,
T10.STRING_VALUE,
T1.STRING_VALUE,
T6.CAPTION,
T11.CAPTION_REF,
T11.CLASS_NAME,
T11.COMMENTS,
T11.LEFT_COORD,
T6.LEFT_COORD,
T11.LEFT_TEXT,
T11.MVG_APPLET_NAME,
T11.METHOD_INVOKED,
T11.MODULE_NAME,
T11.MULTI_LINE,
T11.NAME,
T7.OBJ_LOCKED_LANG,
T7.OBJ_LOCKED_FLG,
T7.OBJ_LOCKED_BY,
T11.OWNER_DRAW,
T7.BUSCOMP_NAME,
T11.APPLET_ID,
T8.NAME,
T2.STRING_VALUE,
T9.STRING_VALUE,
T6.TOOLTIP_TEXT,
T11.HTML_ICON_MAP,
T11.HTML_MAX_CHAR_DISP,
T6.HTML_MAX_CHAR_DISP,
T11.HTML_ONLY_FLG,
T11.HTML_ROW_SEN_FLG,
T11.HTML_SEQUENCE,
T6.HTML_SEQUENCE,
T11.HTML_TYPE,
T11.HTML_WIDTH,
T6.HTML_WIDTH,
T11.HEIGHT,
T6.HEIGHT,
T11.INACTIVE_FLG,
T11.RUNTIME_FLG,
T11.SEQUENCE,
T6.SEQUENCE,
T11.SHOW_POPUP_FLG,
T11.SORT,
T11.TAB_STOP,
T11.TARGET_VIEW_FRAME,
T11.TEXT_ALIGNMENT,
T6.TEXT_ALIGNMENT,
T11.LABEL_TXT_ALGNMENT,
T6.LABEL_TXT_ALGNMENT,
T11.TEXT_STYLE_NAME,
T11.ACTIVEX_BIND_PROP,
T11.ACTIVEX_PROPS,
T6.APP_CD,
T11.AUTO_HSCROLL,
T11.AUTO_VSCROLL,
T7.NAME,
T5.LOCKED_FLG,
T5.LOCKED_BY,
T5.NAME,
T5.UIFREEZE_FLG,
T5.UIFREEZE_BY,
T11.PROMPT_FLG,
T4.STRING_VALUE,
T3.STRING_VALUE,
T6.PROMPT_TEXT,
T11.PROMPT_TEXT_REF,
T11.READONLY,
T11.REPOSITORY_ID,
T11.HTML_DISPLAY_MODE,
T11.HTML_HEIGHT,
T6.HTML_HEIGHT,
T11.CONTENT_FIXUP_NAME,
T11.DEFAULT_BUTTON,
T11.DET_APPLET_NAME,
T11.DISPLAY_FORMAT,
T11.FIELD_NAME,
T11.FIELD_RETRIEVAL_CD,
T7.MODULE_NAME,
T11.FRGRND_COLOR,
T11.ISGROUP,
T11.HTML_ATTR,
T11.HTML_BITMAP,
T11.HTML_DEFAULT_FLG,
T11.TOOLTIP_TEXT_REF,
T11.TOP_COORD,
T6.TOP_COORD,
T11.TYPE,
T11.VERTICAL_SCROLL,
T11.VISIBLE,
T6.VISIBLE_FLG,
T11.WANT_RETURN,
T11.WIDTH,
T6.WIDTH,
T11.FIELD_TYPE_CD,
T7.TASK_NAME,
T7.TYPE,
T11.HTML_DISA_BITMAP,
T6.LANG_CD,
T11.PICK_APPLET_NAME,
T11.POPUP_EDIT_FLG,
T7.PROJECT_ID
FROM
SIEBEL.S_SYM_STR_INTL T1,
SIEBEL.S_SYM_STR_INTL T2,
SIEBEL.S_SYM_STR_INTL T3,
SIEBEL.S_SYM_STR_INTL T4,
SIEBEL.S_PROJECT T5,
SIEBEL.S_CONTROL_INTL T6,
SIEBEL.S_APPLET T7,
SIEBEL.S_REPOSITORY T8,
SIEBEL.S_SYM_STR_INTL T9,
SIEBEL.S_SYM_STR_INTL T10,
SIEBEL.S_CONTROL T11
WHERE
T11.CAPTION_REF = T10.SYM_STR_KEY (+) AND T11.REPOSITORY_ID = T10.REPOSITORY_ID (+) AND T10.APP_CD (+) = ‘STD’ AND T10.INACTIVE_FLG (+) = ‘N’ AND T10.LANG_CD (+) = ‘ENU’ AND
T11.REPOSITORY_ID = T1.REPOSITORY_ID (+) AND T11.CAPTION_REF = T1.SYM_STR_KEY (+) AND T1.APP_CD (+) = ‘STD’ AND T1.INACTIVE_FLG (+) = ‘N’ AND T1.LANG_CD (+) = ‘ENU’ AND
T11.REPOSITORY_ID = T8.ROW_ID (+) AND
T11.ROW_ID = T6.CONTROL_ID (+) AND T6.APP_CD (+) = ‘STD’ AND T6.INACTIVE_FLG (+) = ‘N’ AND T6.LANG_CD (+) = ‘ENU’ AND
T11.APPLET_ID = T7.ROW_ID AND
T11.PROMPT_TEXT_REF = T4.SYM_STR_KEY (+) AND T11.REPOSITORY_ID = T4.REPOSITORY_ID (+) AND T4.APP_CD (+) = ‘STD’ AND T4.INACTIVE_FLG (+) = ‘N’ AND T4.LANG_CD (+) = ‘ENU’ AND
T11.PROMPT_TEXT_REF = T3.SYM_STR_KEY (+) AND T11.REPOSITORY_ID = T3.REPOSITORY_ID (+) AND T3.APP_CD (+) = ‘STD’ AND T3.INACTIVE_FLG (+) = ‘N’ AND T3.LANG_CD (+) = ‘ENU’ AND
T11.REPOSITORY_ID = T2.REPOSITORY_ID (+) AND T11.TOOLTIP_TEXT_REF = T2.SYM_STR_KEY (+) AND T2.APP_CD (+) = ‘STD’ AND T2.INACTIVE_FLG (+) = ‘N’ AND T2.LANG_CD (+) = ‘ENU’ AND
T11.REPOSITORY_ID = T9.REPOSITORY_ID (+) AND T11.TOOLTIP_TEXT_REF = T9.SYM_STR_KEY (+) AND T9.APP_CD (+) = ‘STD’ AND T9.INACTIVE_FLG (+) = ‘N’ AND T9.LANG_CD (+) = ‘ENU’ AND
T7.PROJECT_ID = T5.ROW_ID (+) AND
(T11.REPOSITORY_ID = IN (SELECT ROW_ID FROM SIEBEL.S_REPOSITORY WHERE NAME = ‘Siebel Repository’)) AND
((NVL (T6.CAPTION, NVL (T1.STRING_VALUE, NVL (T10.STRING_VALUE, T10.STRING_VALUE)))) = __ADD_HERE_YOUR_FIELD_NAME_)
ORDER BY
T11.REPOSITORY_ID, T11.NAME;

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: