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

TABLE: BEN.BEN_PL_R_OIPL_ASSET_F

Object Details
Object Name: BEN_PL_R_OIPL_ASSET_F
Object Type: TABLE
Owner: BEN
FND Design Data: TableBEN.BEN_PL_R_OIPL_ASSET_F
Subobject Name:
Status: VALID


BEN_PL_R_OIPL_ASSET_F identifies the assets held by a plan or option in plan. For example, investments, such as stocks, bonds or mutual funds.
BEN_PL_R_OIPL_ASSET_F is the intersection of BEN_PL_F or BEN_OIPL_F and and BEN_COMP_ASSET.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: BEN_PL_R_OIPL_ASSET_F_PK
  1. ColumnPL_R_OIPL_ASSET_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Indexes
Index Type Uniqueness Tablespace Column
BEN_PL_R_OIPL_ASSET_F_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPL_R_OIPL_ASSET_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
BEN_PL_R_OIPL_ASSET_F_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMP_ASSET_ID
BEN_PL_R_OIPL_ASSET_F_FK4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
BEN_PL_R_OIPL_ASSET_F_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPL_ID
BEN_PL_R_OIPL_ASSET_F_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOIPL_ID
Columns
Name Datatype Length Mandatory Comments
PL_R_OIPL_ASSET_ID NUMBER (15) Yes System generated primary key column.
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign Key to HR_ORGANIZATION_UNITS
COMP_ASSET_ID NUMBER (15)
Foreign key to BEN_COMP_ASSET_F.
PL_ID NUMBER (15)
Foreign Key to BEN_PL_F.
OIPL_ID NUMBER (15)
Foreign Key to BEN_OIPL_F.
POA_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column.
POA_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield segment column.
POA_ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flexfield segment column.
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.
QNTY_NUM NUMBER (15)
Quantity.
QNTY_UOM VARCHAR2 (30)
Quantity unit of measure.
MKT_VAL NUMBER

Market value.
MKT_VAL_UOM VARCHAR2 (30)
Market value unit of measure.
MKT_VAL_AS_OF_DT DATE

Market value as of date.
Query Text

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


SELECT PL_R_OIPL_ASSET_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      COMP_ASSET_ID
,      PL_ID
,      OIPL_ID
,      POA_ATTRIBUTE_CATEGORY
,      POA_ATTRIBUTE1
,      POA_ATTRIBUTE2
,      POA_ATTRIBUTE3
,      POA_ATTRIBUTE4
,      POA_ATTRIBUTE5
,      POA_ATTRIBUTE6
,      POA_ATTRIBUTE7
,      POA_ATTRIBUTE8
,      POA_ATTRIBUTE9
,      POA_ATTRIBUTE10
,      POA_ATTRIBUTE11
,      POA_ATTRIBUTE12
,      POA_ATTRIBUTE13
,      POA_ATTRIBUTE14
,      POA_ATTRIBUTE15
,      POA_ATTRIBUTE16
,      POA_ATTRIBUTE17
,      POA_ATTRIBUTE18
,      POA_ATTRIBUTE19
,      POA_ATTRIBUTE20
,      POA_ATTRIBUTE21
,      POA_ATTRIBUTE22
,      POA_ATTRIBUTE23
,      POA_ATTRIBUTE24
,      POA_ATTRIBUTE25
,      POA_ATTRIBUTE26
,      POA_ATTRIBUTE27
,      POA_ATTRIBUTE28
,      POA_ATTRIBUTE29
,      POA_ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      QNTY_NUM
,      QNTY_UOM
,      MKT_VAL
,      MKT_VAL_UOM
,      MKT_VAL_AS_OF_DT
FROM BEN.BEN_PL_R_OIPL_ASSET_F;

Dependencies

[top of page]

BEN.BEN_PL_R_OIPL_ASSET_F does not reference any database object

BEN.BEN_PL_R_OIPL_ASSET_F is referenced by following:

SchemaAPPS
SynonymBEN_PL_R_OIPL_ASSET_F
TriggerBEN_PL_R_OIPL_ASSET_F_WHO