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

VIEW: APPS.AK_ATTRIBUTES_VL

Object Details
Object Name: AK_ATTRIBUTES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAK.AK_ATTRIBUTES_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


View of AK_ATTRIBUTES table


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)

ATTRIBUTE_APPLICATION_ID NUMBER (15) Yes
APPLICATION_SHORT_NAME VARCHAR2 (50) Yes
APPLICATION_NAME VARCHAR2 (240) Yes
ATTRIBUTE_CODE VARCHAR2 (30) Yes
NAME VARCHAR2 (80) Yes Name of the attribute
DESCRIPTION VARCHAR2 (2000)

ATTRIBUTE_LABEL_LONG VARCHAR2 (80)

ATTRIBUTE_LABEL_SHORT VARCHAR2 (40)

ATTRIBUTE_LABEL_LENGTH NUMBER (15)

ATTRIBUTE_VALUE_LENGTH NUMBER (15)

BOLD VARCHAR2 (1) Yes
ITALIC VARCHAR2 (1) Yes
HORIZONTAL_ALIGNMENT VARCHAR2 (30) Yes
VERTICAL_ALIGNMENT VARCHAR2 (30) Yes
DATA_TYPE VARCHAR2 (30) Yes
UPPER_CASE_FLAG VARCHAR2 (1)
DEFAULT_VALUE_VARCHAR2 VARCHAR2 (240)
DEFAULT_VALUE_NUMBER NUMBER (15)
DEFAULT_VALUE_DATE DATE

LOV_REGION_CODE VARCHAR2 (30)
LOV_REGION_APPLICATION_ID NUMBER (15)
LOV_REGION_NAME VARCHAR2 (80)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
ITEM_STYLE VARCHAR2 (30) Yes
DISPLAY_HEIGHT NUMBER

CSS_CLASS_NAME VARCHAR2 (80)
POPLIST_VIEWOBJECT VARCHAR2 (240)
POPLIST_DISPLAY_ATTRIBUTE VARCHAR2 (80)
POPLIST_VALUE_ATTRIBUTE VARCHAR2 (80)
CSS_LABEL_CLASS_NAME VARCHAR2 (80)
EXPANSION NUMBER (15)
ALS_MAX_LENGTH NUMBER (15)
PRECISION NUMBER (15)
Query Text

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


SELECT ROW_ID
,      ATTRIBUTE_APPLICATION_ID
,      APPLICATION_SHORT_NAME
,      APPLICATION_NAME
,      ATTRIBUTE_CODE
,      NAME
,      DESCRIPTION
,      ATTRIBUTE_LABEL_LONG
,      ATTRIBUTE_LABEL_SHORT
,      ATTRIBUTE_LABEL_LENGTH
,      ATTRIBUTE_VALUE_LENGTH
,      BOLD
,      ITALIC
,      HORIZONTAL_ALIGNMENT
,      VERTICAL_ALIGNMENT
,      DATA_TYPE
,      UPPER_CASE_FLAG
,      DEFAULT_VALUE_VARCHAR2
,      DEFAULT_VALUE_NUMBER
,      DEFAULT_VALUE_DATE
,      LOV_REGION_CODE
,      LOV_REGION_APPLICATION_ID
,      LOV_REGION_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ITEM_STYLE
,      DISPLAY_HEIGHT
,      CSS_CLASS_NAME
,      POPLIST_VIEWOBJECT
,      POPLIST_DISPLAY_ATTRIBUTE
,      POPLIST_VALUE_ATTRIBUTE
,      CSS_LABEL_CLASS_NAME
,      EXPANSION
,      ALS_MAX_LENGTH
,      PRECISION
FROM APPS.AK_ATTRIBUTES_VL;

Dependencies

[top of page]

APPS.AK_ATTRIBUTES_VL references the following:

SchemaAPPS
SynonymAK_ATTRIBUTES
SynonymAK_ATTRIBUTES_TL
SynonymAK_REGIONS_TL
ViewFND_APPLICATION_VL
APPS.AK_ATTRIBUTES_VL is referenced by following:

SchemaAPPS
Package BodyAME_UTIL - show dependent code
Package BodyAMS_UTILITY_PVT - show dependent code
Package BodyICX_PAGE_WIDGET - show dependent code
Package BodyOE_ORDER_UTIL - show dependent code
Package BodyOKL_AM_CALCULATE_QUOTE_PVT - show dependent code
Package BodyOKL_AM_UTIL_PVT - show dependent code
Package BodyOKL_CONTRACT_LINE_ITEM_PVT - show dependent code
Package BodyOKL_CONTRACT_TOP_LINE_PVT - show dependent code
Package BodyOKL_DEAL_CREATE_PUB - show dependent code
Package BodyOKL_DEAL_CREAT_PVT - show dependent code
Package BodyOKL_JTOT_CONTACT_EXTRACT_PUB - show dependent code
Package BodyOKL_LA_PAYMENTS_PVT - show dependent code
Package BodyOKL_LA_TRADEIN_PVT - show dependent code
Package BodyOKL_LA_VALIDATION_UTIL_PVT - show dependent code
Package BodyOKL_MAINTAIN_FEE_PVT - show dependent code
Package BodyOKL_MLA_CREATE_UPDATE_PUB - show dependent code
PL/SQL PackageOKL_POL_PVT - show dependent code
Package BodyOKL_SEC_INVESTOR_PVT - show dependent code
Package BodyOKL_SEC_INVESTOR_REVENUE_PVT - show dependent code
Package BodyOZF_UTILITY_PVT - show dependent code
Package BodyPV_BENFT_STATUS_CHANGE - show dependent code
Package BodyQP_PRC_UTIL - show dependent code