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


VIEW: APPS.OE_DEF_AK_ATTR_EXT_V

Object Details
Object Name: OE_DEF_AK_ATTR_EXT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_DEF_AK_ATTR_EXT_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ATTRIBUTE_CODE VARCHAR2 (30) Yes
DATABASE_OBJECT_NAME VARCHAR2 (30) Yes
DEFAULTING_ENABLED_FLAG VARCHAR2 (1) Yes
DEFAULTING_SEQUENCE NUMBER
Yes
DEFAULTING_CONDN_REF_FLAG VARCHAR2 (1) Yes
DEFAULTING_SOURCE_FLAG VARCHAR2 (1) Yes
DEPENDENT_API_PKG VARCHAR2 (30)
DEPENDENT_API_PROC VARCHAR2 (30)
SECURITY_API_PKG VARCHAR2 (30)
SECURITY_API_PROC VARCHAR2 (30)
ATTRIBUTE_APPLICATION_ID NUMBER (15) Yes
COLUMN_NAME VARCHAR2 (30)
ATTRIBUTE_LABEL_LENGTH NUMBER (15) Yes
BOLD VARCHAR2 (1) Yes
ITALIC VARCHAR2 (1) Yes
VERTICAL_ALIGNMENT VARCHAR2 (30) Yes
HORIZONTAL_ALIGNMENT VARCHAR2 (30) 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)
REQUIRED_FLAG VARCHAR2 (1) Yes
DISPLAY_VALUE_LENGTH NUMBER (15) Yes
LOV_REGION_CODE VARCHAR2 (30)
LOV_REGION_APPLICATION_ID NUMBER (15)
LOV_FOREIGN_KEY_NAME VARCHAR2 (30)
LOV_ATTRIBUTE_CODE VARCHAR2 (30)
LOV_ATTRIBUTE_APPLICATION_ID NUMBER (15)
DEFAULTING_API_PKG VARCHAR2 (30)
DEFAULTING_API_PROC VARCHAR2 (30)
VALIDATION_API_PKG VARCHAR2 (30)
VALIDATION_API_PROC VARCHAR2 (30)
DEFAULT_VALUE_VARCHAR2 VARCHAR2 (240)
DEFAULT_VALUE_NUMBER NUMBER (15)
DEFAULT_VALUE_DATE DATE

NAME VARCHAR2 (80)
APPLICATION_DISPLAY_NAME VARCHAR2 (240) Yes
DATABASE_OBJECT_DISPLAY_NAME VARCHAR2 (30)
ATTRIBUTE_DISPLAY_NAME VARCHAR2 (80)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Query Text

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


SELECT ROW_ID
,      ATTRIBUTE_CODE
,      DATABASE_OBJECT_NAME
,      DEFAULTING_ENABLED_FLAG
,      DEFAULTING_SEQUENCE
,      DEFAULTING_CONDN_REF_FLAG
,      DEFAULTING_SOURCE_FLAG
,      DEPENDENT_API_PKG
,      DEPENDENT_API_PROC
,      SECURITY_API_PKG
,      SECURITY_API_PROC
,      ATTRIBUTE_APPLICATION_ID
,      COLUMN_NAME
,      ATTRIBUTE_LABEL_LENGTH
,      BOLD
,      ITALIC
,      VERTICAL_ALIGNMENT
,      HORIZONTAL_ALIGNMENT
,      DATA_TYPE
,      DATA_SOURCE_TYPE
,      DATA_STORAGE_TYPE
,      TABLE_NAME
,      BASE_TABLE_COLUMN_NAME
,      REQUIRED_FLAG
,      DISPLAY_VALUE_LENGTH
,      LOV_REGION_CODE
,      LOV_REGION_APPLICATION_ID
,      LOV_FOREIGN_KEY_NAME
,      LOV_ATTRIBUTE_CODE
,      LOV_ATTRIBUTE_APPLICATION_ID
,      DEFAULTING_API_PKG
,      DEFAULTING_API_PROC
,      VALIDATION_API_PKG
,      VALIDATION_API_PROC
,      DEFAULT_VALUE_VARCHAR2
,      DEFAULT_VALUE_NUMBER
,      DEFAULT_VALUE_DATE
,      NAME
,      APPLICATION_DISPLAY_NAME
,      DATABASE_OBJECT_DISPLAY_NAME
,      ATTRIBUTE_DISPLAY_NAME
,      ATTRIBUTE_CATEGORY
FROM APPS.OE_DEF_AK_ATTR_EXT_V;

Dependencies

[top of page]

APPS.OE_DEF_AK_ATTR_EXT_V references the following:

SchemaAPPS
ViewAK_OBJECT_ATTRIBUTES_VL
SynonymOE_AK_OBJ_ATTR_EXT
APPS.OE_DEF_AK_ATTR_EXT_V is referenced by following:

SchemaAPPS
Package BodyOE_DEFAULTING_FWK_PUB - show dependent code
Package BodyONT_OEXDERUL_XMLP_PKG - show dependent code