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

VIEW: APPS.BEN_CM_TYP_F_VL

Object Details
Object Name: BEN_CM_TYP_F_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BEN_CM_TYP_F_VL
Subobject Name:
Status: VALID

View Type

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
CM_TYP_ID NUMBER (15) Yes
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
NAME VARCHAR2 (240) Yes
DESC_TXT VARCHAR2 (240)
CM_TYP_RL NUMBER (15)
CM_USG_CD VARCHAR2 (30)
WHNVR_TRGRD_FLAG VARCHAR2 (30) Yes
SHRT_NAME VARCHAR2 (90)
PC_KIT_CD VARCHAR2 (30)
TRK_MLG_FLAG VARCHAR2 (30) Yes
MX_NUM_AVLBL_VAL NUMBER (15)
TO_BE_SENT_DT_CD VARCHAR2 (30) Yes
TO_BE_SENT_DT_RL NUMBER (15)
INSPN_RQD_FLAG VARCHAR2 (30) Yes
INSPN_RQD_RL NUMBER (15)
RCPENT_CD VARCHAR2 (30)
PARNT_CM_TYP_ID NUMBER (15)
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign Key to HR_ORGANIZATION_UNITS
CCT_ATTRIBUTE_CATEGORY VARCHAR2 (30)
CCT_ATTRIBUTE1 VARCHAR2 (150)
CCT_ATTRIBUTE10 VARCHAR2 (150)
CCT_ATTRIBUTE11 VARCHAR2 (150)
CCT_ATTRIBUTE12 VARCHAR2 (150)
CCT_ATTRIBUTE13 VARCHAR2 (150)
CCT_ATTRIBUTE14 VARCHAR2 (150)
CCT_ATTRIBUTE15 VARCHAR2 (150)
CCT_ATTRIBUTE16 VARCHAR2 (150)
CCT_ATTRIBUTE17 VARCHAR2 (150)
CCT_ATTRIBUTE18 VARCHAR2 (150)
CCT_ATTRIBUTE19 VARCHAR2 (150)
CCT_ATTRIBUTE2 VARCHAR2 (150)
CCT_ATTRIBUTE20 VARCHAR2 (150)
CCT_ATTRIBUTE21 VARCHAR2 (150)
CCT_ATTRIBUTE22 VARCHAR2 (150)
CCT_ATTRIBUTE23 VARCHAR2 (150)
CCT_ATTRIBUTE24 VARCHAR2 (150)
CCT_ATTRIBUTE25 VARCHAR2 (150)
CCT_ATTRIBUTE26 VARCHAR2 (150)
CCT_ATTRIBUTE27 VARCHAR2 (150)
CCT_ATTRIBUTE28 VARCHAR2 (150)
CCT_ATTRIBUTE29 VARCHAR2 (150)
CCT_ATTRIBUTE3 VARCHAR2 (150)
CCT_ATTRIBUTE30 VARCHAR2 (150)
CCT_ATTRIBUTE4 VARCHAR2 (150)
CCT_ATTRIBUTE5 VARCHAR2 (150)
CCT_ATTRIBUTE6 VARCHAR2 (150)
CCT_ATTRIBUTE7 VARCHAR2 (150)
CCT_ATTRIBUTE8 VARCHAR2 (150)
CCT_ATTRIBUTE9 VARCHAR2 (150)
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated primary key. Increments by one each update.
Query Text

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


SELECT CM_TYP_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      NAME
,      DESC_TXT
,      CM_TYP_RL
,      CM_USG_CD
,      WHNVR_TRGRD_FLAG
,      SHRT_NAME
,      PC_KIT_CD
,      TRK_MLG_FLAG
,      MX_NUM_AVLBL_VAL
,      TO_BE_SENT_DT_CD
,      TO_BE_SENT_DT_RL
,      INSPN_RQD_FLAG
,      INSPN_RQD_RL
,      RCPENT_CD
,      PARNT_CM_TYP_ID
,      BUSINESS_GROUP_ID
,      CCT_ATTRIBUTE_CATEGORY
,      CCT_ATTRIBUTE1
,      CCT_ATTRIBUTE10
,      CCT_ATTRIBUTE11
,      CCT_ATTRIBUTE12
,      CCT_ATTRIBUTE13
,      CCT_ATTRIBUTE14
,      CCT_ATTRIBUTE15
,      CCT_ATTRIBUTE16
,      CCT_ATTRIBUTE17
,      CCT_ATTRIBUTE18
,      CCT_ATTRIBUTE19
,      CCT_ATTRIBUTE2
,      CCT_ATTRIBUTE20
,      CCT_ATTRIBUTE21
,      CCT_ATTRIBUTE22
,      CCT_ATTRIBUTE23
,      CCT_ATTRIBUTE24
,      CCT_ATTRIBUTE25
,      CCT_ATTRIBUTE26
,      CCT_ATTRIBUTE27
,      CCT_ATTRIBUTE28
,      CCT_ATTRIBUTE29
,      CCT_ATTRIBUTE3
,      CCT_ATTRIBUTE30
,      CCT_ATTRIBUTE4
,      CCT_ATTRIBUTE5
,      CCT_ATTRIBUTE6
,      CCT_ATTRIBUTE7
,      CCT_ATTRIBUTE8
,      CCT_ATTRIBUTE9
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
FROM APPS.BEN_CM_TYP_F_VL;

Dependencies

[top of page]

APPS.BEN_CM_TYP_F_VL references the following:

SchemaAPPS
SynonymBEN_CM_TYP_F
SynonymBEN_CM_TYP_F_TL

APPS.BEN_CM_TYP_F_VL is not referenced by any database object