DBA Data[Home] [Help] [Dependency Information]

TABLE: OSM.AS_OBJECT_ATTRIBUTES

Object Details
Object Name: AS_OBJECT_ATTRIBUTES
Object Type: TABLE
Owner: OSM
FND Design Data: TableAS.AS_OBJECT_ATTRIBUTES
Subobject Name:
Status: VALID


For PRM use.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
OBJECT_ATTRIBUTE_ID NUMBER
Yes Primary Key
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Application identifier of last concurrent program to update record
PROGRAM_ID NUMBER

Identifier of last concurrent program to update record
PROGRAM_UPDATE_DATE DATE

Last date concurrent program updated record
OBJECT_NAME VARCHAR2 (30)
Object name
OBJECT_ID NUMBER

Unique identifier of object
ATTRIBUTE_NAME VARCHAR2 (80)
Name of the attribute
ATTRIBUTE_VALUE VARCHAR2 (150)
value of the attribute
ATTRIBUTE_VALUE_TYPE VARCHAR2 (30)
Datatype of value
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OBJECT_ATTRIBUTE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OBJECT_NAME
,      OBJECT_ID
,      ATTRIBUTE_NAME
,      ATTRIBUTE_VALUE
,      ATTRIBUTE_VALUE_TYPE
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM OSM.AS_OBJECT_ATTRIBUTES;

Dependencies

[top of page]

OSM.AS_OBJECT_ATTRIBUTES does not reference any database object

OSM.AS_OBJECT_ATTRIBUTES is referenced by following:

SchemaAPPS
SynonymAS_OBJECT_ATTRIBUTES