Skip to content

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

TABLE: OPI.EDW_OPI_OPRN_OPRC_LTC

Object Details
Object Name: EDW_OPI_OPRN_OPRC_LTC
Object Type: TABLE
Owner: OPI
FND Design Data: TableOPI.EDW_OPI_OPRN_OPRC_LTC
Subobject Name:
Status: VALID


Operation Class Level Table


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_OPI_OPRN_OPRC_LTC_P NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnOPRC_PK
ColumnOPRC_PK_KEY
EDW_OPI_OPRN_OPRC_LTC_U NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnOPRC_PK_KEY
Columns
Name Datatype Length Mandatory Comments
ALL_FK_KEY NUMBER

All FK Key Surrogate Key
CREATION_DATE DATE

Who Column
DESCRIPTION VARCHAR2 (80)
Operation Class Description
LAST_UPDATE_DATE DATE

Who Column
NAME VARCHAR2 (80)
Operation Class Name
OPRC_DP VARCHAR2 (240)
Discovere Operation Class Name
OPRC_PK VARCHAR2 (40)
Operation Class PK
OPRC_PK_KEY NUMBER

Operation PK Key Generated by OWB
USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute1
USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute2
USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute3
USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute4
USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute5
Query Text

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


SELECT ALL_FK_KEY
,      CREATION_DATE
,      DESCRIPTION
,      LAST_UPDATE_DATE
,      NAME
,      OPRC_DP
,      OPRC_PK
,      OPRC_PK_KEY
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
FROM OPI.EDW_OPI_OPRN_OPRC_LTC;

Dependencies

[top of page]

OPI.EDW_OPI_OPRN_OPRC_LTC does not reference any database object

OPI.EDW_OPI_OPRN_OPRC_LTC is referenced by following:

SchemaOPI
ViewEDW_OPI_OPRN_OPRC_LTC#