VIEW: APPS.OE_DEF_AK_ATTR_EXT_V

Source

View Text - Preformatted

SELECT o.rowid, o.attribute_code, o.database_object_name, O.DEFAULTING_ENABLED_FLAG, o.defaulting_sequence, o.defaulting_condn_ref_flag, o.defaulting_source_flag, o.dependent_api_pkg, o.dependent_api_proc, o.security_api_pkg, o.security_api_proc, a.ATTRIBUTE_APPLICATION_ID, a.COLUMN_NAME, a.ATTRIBUTE_LABEL_LENGTH, a.BOLD, a.ITALIC, a.VERTICAL_ALIGNMENT, a.HORIZONTAL_ALIGNMENT, a.DATA_TYPE, a.data_source_type, a.data_storage_type, a.TABLE_NAME , a.BASE_TABLE_COLUMN_NAME, a.REQUIRED_FLAG , a.DISPLAY_VALUE_LENGTH, a.LOV_REGION_CODE , a.LOV_REGION_APPLICATION_ID , a.LOV_FOREIGN_KEY_NAME , a.LOV_ATTRIBUTE_CODE, a.LOV_ATTRIBUTE_APPLICATION_ID , a.DEFAULTING_API_PKG, a.DEFAULTING_API_PROC , a.VALIDATION_API_PKG , a.VALIDATION_API_PROC , a.DEFAULT_VALUE_VARCHAR2 , a.DEFAULT_VALUE_NUMBER , a.DEFAULT_VALUE_DATE , a.attribute_label_long, a.application_name, a.object_name, a.attribute_label_long, a.ATTRIBUTE_CATEGORY from ak_object_attributes_vl a, oe_ak_obj_attr_ext o WHERE a.database_object_name = o.database_object_name and a.attribute_code = o.attribute_code and a.attribute_application_id = o.attribute_application_id

View Text - HTML Formatted

SELECT O.ROWID
, O.ATTRIBUTE_CODE
, O.DATABASE_OBJECT_NAME
, O.DEFAULTING_ENABLED_FLAG
, O.DEFAULTING_SEQUENCE
, O.DEFAULTING_CONDN_REF_FLAG
, O.DEFAULTING_SOURCE_FLAG
, O.DEPENDENT_API_PKG
, O.DEPENDENT_API_PROC
, O.SECURITY_API_PKG
, O.SECURITY_API_PROC
, A.ATTRIBUTE_APPLICATION_ID
, A.COLUMN_NAME
, A.ATTRIBUTE_LABEL_LENGTH
, A.BOLD
, A.ITALIC
, A.VERTICAL_ALIGNMENT
, A.HORIZONTAL_ALIGNMENT
, A.DATA_TYPE
, A.DATA_SOURCE_TYPE
, A.DATA_STORAGE_TYPE
, A.TABLE_NAME
, A.BASE_TABLE_COLUMN_NAME
, A.REQUIRED_FLAG
, A.DISPLAY_VALUE_LENGTH
, A.LOV_REGION_CODE
, A.LOV_REGION_APPLICATION_ID
, A.LOV_FOREIGN_KEY_NAME
, A.LOV_ATTRIBUTE_CODE
, A.LOV_ATTRIBUTE_APPLICATION_ID
, A.DEFAULTING_API_PKG
, A.DEFAULTING_API_PROC
, A.VALIDATION_API_PKG
, A.VALIDATION_API_PROC
, A.DEFAULT_VALUE_VARCHAR2
, A.DEFAULT_VALUE_NUMBER
, A.DEFAULT_VALUE_DATE
, A.ATTRIBUTE_LABEL_LONG
, A.APPLICATION_NAME
, A.OBJECT_NAME
, A.ATTRIBUTE_LABEL_LONG
, A.ATTRIBUTE_CATEGORY
FROM AK_OBJECT_ATTRIBUTES_VL A
, OE_AK_OBJ_ATTR_EXT O
WHERE A.DATABASE_OBJECT_NAME = O.DATABASE_OBJECT_NAME
AND A.ATTRIBUTE_CODE = O.ATTRIBUTE_CODE
AND A.ATTRIBUTE_APPLICATION_ID = O.ATTRIBUTE_APPLICATION_ID