Oracle Web网页画面查询LastQuery方法

 

Web网页画面查询LastQuery方法

1. 设置Profile： Personalize Self-Service Defn 为 Yes

2. 重新登入系统，如果没有出现Personalize Page & About this Page，则需要重新启动Apache。

3. 在HomePage上，选择About this Page链接

4.  Page Definition Click Expand All，Look for View Object link，Click the link，View Object Details-Query

SELECT TEMPLATESVLEO.TEMPLATE_ID       ,TEMPLATESVLEO.APPLICATION_ID       ,TEMPLATESVLEO.APPLICATION_SHORT_NAME       ,TEMPLATESVLEO.TEMPLATE_CODE       ,TEMPLATESVLEO.DS_APP_SHORT_NAME       ,TEMPLATESVLEO.DATA_SOURCE_CODE       ,TEMPLATESVLEO.TEMPLATE_TYPE_CODE       ,TEMPLATESVLEO.DEFAULT_LANGUAGE       ,TEMPLATESVLEO.DEFAULT_TERRITORY       ,TEMPLATESVLEO.TEMPLATE_STATUS       ,TEMPLATESVLEO.USE_ALIAS_TABLE       ,TEMPLATESVLEO.START_DATE       ,TEMPLATESVLEO.END_DATE       ,TEMPLATESVLEO.TEMPLATE_NAME       ,TEMPLATESVLEO.DESCRIPTION       ,TEMPLATESVLEO.CREATED_BY       ,TEMPLATESVLEO.DEPENDENCY_FLAG       ,(SELECT APPLICATION_NAME           FROM FND_APPLICATION_VL          WHERE APPLICATION_SHORT_NAME =                TEMPLATESVLEO.APPLICATION_SHORT_NAME) APPLICATION_NAME       ,(SELECT MEANING           FROM FND_LOOKUPS          WHERE LOOKUP_TYPE = 'XDO_TEMPLATE_TYPE'            AND LOOKUP_CODE = TEMPLATESVLEO.TEMPLATE_TYPE_CODE) TEMPLATE_TYPE       ,(SELECT DATA_SOURCE_NAME           FROM XDO_DS_DEFINITIONS_VL          WHERE DATA_SOURCE_CODE = TEMPLATESVLEO.DATA_SOURCE_CODE            AND APPLICATION_SHORT_NAME = TEMPLATESVLEO.DS_APP_SHORT_NAME) DATA_SOURCE_NAME       ,USERENV('LANG') LANGUAGE       ,TEMPLATESVLEO.MLS_LANGUAGE       ,TEMPLATESVLEO.MLS_TERRITORY   FROM XDO_TEMPLATES_VL TEMPLATESVLEO