Product: | ONT - Order Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OE_DEF_AK_ATTR_EXT_V |
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