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: POR_TEMPLATE_ATTRIBUTES_V

Product:	ICX - Oracle iProcurement
Description:	Information Template Attributes View
Implementation/DBA Data:	APPS.POR_TEMPLATE_ATTRIBUTES_V

View Text

SELECT ARI.ROWID ROW_ID
, ARI.REGION_CODE REGION_CODE
, ARI.DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, ARI.ATTRIBUTE_CODE ATTRIBUTE_CODE
, ARIT.ATTRIBUTE_LABEL_SHORT ATTRIBUTE_LABEL_SHORT
, ARIT.ATTRIBUTE_LABEL_LONG ATTRIBUTE_LABEL_LONG
, ARI.DEFAULT_VALUE_VARCHAR2 DEFAULT_VALUE_VARCHAR2
, ARI.LOV_REGION_CODE LOV_REGION_CODE
, ARI.REQUIRED_FLAG REQUIRED_FLAG
, ARI.NODE_DISPLAY_FLAG NODE_DISPLAY_FLAG
, ARI.CREATED_BY CREATED_BY
, ARI.CREATION_DATE CREATION_DATE
, ARI.LAST_UPDATED_BY LAST_UPDATED_BY
, ARI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ARI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM AK_REGION_ITEMS_VL ARIT
, AK_REGION_ITEMS ARI
WHERE ARI.REGION_CODE = ARIT.REGION_CODE
AND ARI.ATTRIBUTE_CODE = ARIT.ATTRIBUTE_CODE
AND ARI.REGION_CODE LIKE 'IFT_%'
AND ARI.ATTRIBUTE_CODE LIKE 'IFT%'

Columns

Name
ROW_ID
REGION_CODE
DISPLAY_SEQUENCE
ATTRIBUTE_CODE
ATTRIBUTE_LABEL_SHORT
ATTRIBUTE_LABEL_LONG
DEFAULT_VALUE_VARCHAR2
LOV_REGION_CODE
REQUIRED_FLAG
NODE_DISPLAY_FLAG
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN