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

TABLE: OPI.EDW_OPI_OPRN_OPRC_LSTG

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


Operations Class Staging Table


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ALL_FK VARCHAR2 (40)
All FK
ALL_FK_KEY NUMBER

All FK Surrogate Key Generated by OWB
COLLECTION_STATUS VARCHAR2 (30)
EDW Collection Status
CREATION_DATE DATE

Who column
DESCRIPTION VARCHAR2 (80)
Operation Class Description
EDW_COLLECTION_DATE DATE

EDW Collection Date
ERROR_CODE VARCHAR2 (2000)
EDW Error Code
LAST_UPDATE_DATE DATE

Who column
NAME VARCHAR2 (80)
Operation Class Name
OPERATION_CODE VARCHAR2 (30)
EDW Operation Code (not Related to Operation Dimension)
OPRC_DP VARCHAR2 (240)
Discovere Operation Class Name
OPRC_PK VARCHAR2 (40)
Operation Class Pk
OPRC_PK_KEY NUMBER

Operation Class PK Key
REQUEST_ID NUMBER

EDW Request ID
ROW_ID VARCHAR2 (20)
EDW Row-Id
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
,      ALL_FK_KEY
,      COLLECTION_STATUS
,      CREATION_DATE
,      DESCRIPTION
,      EDW_COLLECTION_DATE
,      ERROR_CODE
,      LAST_UPDATE_DATE
,      NAME
,      OPERATION_CODE
,      OPRC_DP
,      OPRC_PK
,      OPRC_PK_KEY
,      REQUEST_ID
,      ROW_ID
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
FROM OPI.EDW_OPI_OPRN_OPRC_LSTG;

Dependencies

[top of page]

OPI.EDW_OPI_OPRN_OPRC_LSTG does not reference any database object

OPI.EDW_OPI_OPRN_OPRC_LSTG is referenced by following:

SchemaAPPS
SynonymEDW_OPI_OPRN_OPRC_LSTG