[Home] [Help]
[Dependency Information]
| Object Name: | OE_PC_ATTRIBUTES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | ONT.OE_PC_ATTRIBUTES_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| APPLICATION_ID | NUMBER | (15) | Yes | |
| ENTITY_ID | NUMBER | Yes | ||
| DB_OBJECT_NAME | VARCHAR2 | (30) | Yes | |
| DB_OBJECT_TYPE | CHAR | (4) | ||
| ATTRIBUTE_CODE | VARCHAR2 | (30) | Yes | |
| ATTRIBUTE_ID | NUMBER | Yes | ||
| COLUMN_NAME | VARCHAR2 | (30) | Yes | |
| ATTRIBUTE_DISPLAY_NAME | VARCHAR2 | (80) | ||
| CONSTRAINTS_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| CONSTRAINTS_CONDN_REF_FLAG | VARCHAR2 | (1) | Yes | |
| STATE_ATTRIBUTE_FLAG | VARCHAR2 | (1) | ||
| ATTRIBUTE_LABEL_LENGTH | NUMBER | (15) | Yes | |
| DATA_TYPE | VARCHAR2 | (30) | Yes | |
| DATA_SOURCE_TYPE | VARCHAR2 | (30) | Yes | |
| DATA_STORAGE_TYPE | VARCHAR2 | (30) | ||
| TABLE_NAME | VARCHAR2 | (30) | ||
| BASE_TABLE_COLUMN_NAME | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM APPS.OE_PC_ATTRIBUTES_V;
APPS
AK_ATTRIBUTES
AK_ATTRIBUTES_TL
AK_OBJECT_ATTRIBUTES
OE_AK_OBJECTS_EXT
OE_AK_OBJ_ATTR_EXT
APPS
OE_AUDIT_HISTORY_PVT
- show dependent code
OE_PC_CONSTRAINTS_ADMIN_PVT
- show dependent code
OE_PC_CONSTRAINTS_V
ONT_OEXAUDHR_XMLP_PKG
- show dependent code
ONT_OEXOEPCL_XMLP_PKG
- show dependent code
|
|
|
|