Skip to content

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

VIEW: OPI.EDW_MTL_ILDM_OU_LSTG#

Object Details
Object Name: EDW_MTL_ILDM_OU_LSTG#
Object Type: VIEW
Owner: OPI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ALL_FK VARCHAR2 (40)
ALL_FK_KEY NUMBER

BUSINESS_GROUP VARCHAR2 (500)
COLLECTION_STATUS VARCHAR2 (30)
CREATION_DATE DATE

DATE_FROM DATE

DATE_TO DATE

ERROR_CODE VARCHAR2 (2000)
INSTANCE VARCHAR2 (40)
INT_EXT_FLAG VARCHAR2 (120)
LAST_UPDATE_DATE DATE

NAME VARCHAR2 (500)
OPERATING_UNIT_DP VARCHAR2 (500)
OPERATING_UNIT_PK VARCHAR2 (240)
OPERATING_UNIT_PK_KEY NUMBER

OPERATION_CODE VARCHAR2 (30)
ORG_CODE VARCHAR2 (120)
ORG_TYPE VARCHAR2 (80)
PRIMARY_CST_MTHD VARCHAR2 (120)
REQUEST_ID NUMBER

ROW_ID VARCHAR2 (40)
USER_ATTRIBUTE1 VARCHAR2 (240)
USER_ATTRIBUTE2 VARCHAR2 (240)
USER_ATTRIBUTE3 VARCHAR2 (240)
USER_ATTRIBUTE4 VARCHAR2 (240)
USER_ATTRIBUTE5 VARCHAR2 (240)
Query Text

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


SELECT ALL_FK
,      ALL_FK_KEY
,      BUSINESS_GROUP
,      COLLECTION_STATUS
,      CREATION_DATE
,      DATE_FROM
,      DATE_TO
,      ERROR_CODE
,      INSTANCE
,      INT_EXT_FLAG
,      LAST_UPDATE_DATE
,      NAME
,      OPERATING_UNIT_DP
,      OPERATING_UNIT_PK
,      OPERATING_UNIT_PK_KEY
,      OPERATION_CODE
,      ORG_CODE
,      ORG_TYPE
,      PRIMARY_CST_MTHD
,      REQUEST_ID
,      ROW_ID
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
FROM OPI.EDW_MTL_ILDM_OU_LSTG#;

Dependencies

[top of page]

OPI.EDW_MTL_ILDM_OU_LSTG# references the following:

SchemaOPI
TableEDW_MTL_ILDM_OU_LSTG
OPI.EDW_MTL_ILDM_OU_LSTG# is referenced by following:

SchemaAPPS
SynonymEDW_MTL_ILDM_OU_LSTG