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

Product:	ONT - Order Management
Description:	This view stores the attributes of sales order entities.
Implementation/DBA Data:	APPS.OE_PC_ATTRIBUTES_V

View Text

SELECT OEATTR.ROWID
, AKOAT.ATTRIBUTE_APPLICATION_ID
, OEOBJ.ENTITY_ID
, OEATTR.DATABASE_OBJECT_NAME
, 'VIEW'
, OEATTR.ATTRIBUTE_CODE
, OEATTR.ATTRIBUTE_ID
, AKOAT.ATTRIBUTE_CODE
, AKATTRTL.ATTRIBUTE_LABEL_LONG
, OEATTR.CONSTRAINTS_ENABLED_FLAG
, OEATTR.CONSTRAINT_CONDN_REF_FLAG
, OEATTR.STATE_ATTRIBUTE_FLAG
, AKOAT.ATTRIBUTE_LABEL_LENGTH
, AKATTR.DATA_TYPE
, AKOAT.DATA_SOURCE_TYPE
, AKOAT.DATA_STORAGE_TYPE
, AKOAT.TABLE_NAME
, AKOAT.BASE_TABLE_COLUMN_NAME
FROM AK_OBJECT_ATTRIBUTES AKOAT
, AK_ATTRIBUTES AKATTR
, AK_ATTRIBUTES_TL AKATTRTL
, OE_AK_OBJ_ATTR_EXT OEATTR
, OE_AK_OBJECTS_EXT OEOBJ
WHERE AKOAT.DATABASE_OBJECT_NAME = OEOBJ.DATABASE_OBJECT_NAME
AND AKOAT.ATTRIBUTE_CODE = OEATTR.ATTRIBUTE_CODE
AND AKOAT.ATTRIBUTE_APPLICATION_ID = OEATTR.ATTRIBUTE_APPLICATION_ID
AND OEOBJ.DATABASE_OBJECT_NAME = OEATTR.DATABASE_OBJECT_NAME
AND AKATTR.ATTRIBUTE_CODE = AKOAT.ATTRIBUTE_CODE
AND AKATTR.ATTRIBUTE_APPLICATION_ID = AKOAT.ATTRIBUTE_APPLICATION_ID
AND AKATTRTL.ATTRIBUTE_CODE = AKOAT.ATTRIBUTE_CODE
AND AKATTRTL.ATTRIBUTE_APPLICATION_ID = AKOAT.ATTRIBUTE_APPLICATION_ID
AND AKATTRTL.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
APPLICATION_ID
ENTITY_ID
DB_OBJECT_NAME
DB_OBJECT_TYPE
ATTRIBUTE_CODE
ATTRIBUTE_ID
COLUMN_NAME
ATTRIBUTE_DISPLAY_NAME
CONSTRAINTS_ENABLED_FLAG
CONSTRAINTS_CONDN_REF_FLAG
STATE_ATTRIBUTE_FLAG
ATTRIBUTE_LABEL_LENGTH
DATA_TYPE
DATA_SOURCE_TYPE
DATA_STORAGE_TYPE
TABLE_NAME
BASE_TABLE_COLUMN_NAME