Skip to content

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

VIEW: OPI.EDW_MTL_INVENTORY_LOC_M#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ALL_NAME VARCHAR2 (80)
ALL_PK VARCHAR2 (40)
ALL_PK_KEY NUMBER

CREATION_DATE DATE
Yes
INVL_NAME VARCHAR2 (2000)
INVL_DESCRIPTION VARCHAR2 (240)
INVL_ENABLED_FLAG VARCHAR2 (20)
INVL_INSTANCE_CODE VARCHAR2 (40)
INVL_LOCATOR_DP VARCHAR2 (240)
INVL_LOCATOR_NAME VARCHAR2 (240)
INVL_LOCATOR_PK VARCHAR2 (320)
INVL_LOCATOR_PK_KEY NUMBER
Yes
INVL_USER_ATTRIBUTE1 VARCHAR2 (240)
INVL_USER_ATTRIBUTE2 VARCHAR2 (240)
INVL_USER_ATTRIBUTE3 VARCHAR2 (240)
INVL_USER_ATTRIBUTE4 VARCHAR2 (240)
INVL_USER_ATTRIBUTE5 VARCHAR2 (240)
LAST_UPDATE_DATE DATE
Yes
OU_BUSINESS_GROUP VARCHAR2 (120)
OU_DATE_FROM DATE

OU_DATE_TO DATE

OU_INSTANCE_CODE VARCHAR2 (40)
OU_INT_EXT_FLAG VARCHAR2 (120)
OU_NAME VARCHAR2 (320)
OU_OPERATING_UNIT_DP VARCHAR2 (240)
OU_OPERATING_UNIT_PK VARCHAR2 (240)
OU_OPERATING_UNIT_PK_KEY NUMBER

OU_ORG_CODE VARCHAR2 (40)
OU_ORG_TYPE VARCHAR2 (120)
OU_PRIMARY_CST_MTHD VARCHAR2 (120)
OU_USER_ATTRIBUTE1 VARCHAR2 (240)
OU_USER_ATTRIBUTE2 VARCHAR2 (240)
OU_USER_ATTRIBUTE3 VARCHAR2 (240)
OU_USER_ATTRIBUTE4 VARCHAR2 (240)
OU_USER_ATTRIBUTE5 VARCHAR2 (240)
PCMP_DESCRIPTION VARCHAR2 (240)
PCMP_INSTANCE_CODE VARCHAR2 (40)
PCMP_NAME VARCHAR2 (320)
PCMP_OPM_COMPANY_PK VARCHAR2 (120)
PCMP_OPM_COMPANY_CODE VARCHAR2 (40)
PCMP_OPM_COMPANY_DP VARCHAR2 (240)
PCMP_OPM_COMPANY_NAME VARCHAR2 (120)
PCMP_OPM_COMPANY_PK_KEY NUMBER

PCMP_USER_ATTRIBUTE1 VARCHAR2 (240)
PCMP_USER_ATTRIBUTE2 VARCHAR2 (240)
PCMP_USER_ATTRIBUTE3 VARCHAR2 (240)
PCMP_USER_ATTRIBUTE4 VARCHAR2 (240)
PCMP_USER_ATTRIBUTE5 VARCHAR2 (240)
PLNT_NAME VARCHAR2 (2000)
PLNT_ORGANIZATION_NAME VARCHAR2 (240)
PLNT_DESCRIPTION VARCHAR2 (240)
PLNT_INSTANCE_CODE VARCHAR2 (40)
PLNT_ORGANIZATION_CODE VARCHAR2 (40)
PLNT_PLANT_DP VARCHAR2 (240)
PLNT_PLANT_PK VARCHAR2 (120)
PLNT_PLANT_PK_KEY NUMBER

PLNT_USER_ATTRIBUTE1 VARCHAR2 (240)
PLNT_USER_ATTRIBUTE2 VARCHAR2 (240)
PLNT_USER_ATTRIBUTE3 VARCHAR2 (240)
PLNT_USER_ATTRIBUTE4 VARCHAR2 (240)
PLNT_USER_ATTRIBUTE5 VARCHAR2 (240)
PORG_DESCRIPTION VARCHAR2 (240)
PORG_INSTANCE_CODE VARCHAR2 (40)
PORG_NAME VARCHAR2 (320)
PORG_OPM_ORGANIZATION_CODE VARCHAR2 (80)
PORG_OPM_ORGANIZATION_DP VARCHAR2 (240)
PORG_OPM_ORGANIZATION_NAME VARCHAR2 (240)
PORG_OPM_ORGANIZATION_PK VARCHAR2 (120)
PORG_OPM_ORGANIZATION_PK_KEY NUMBER

PORG_USER_ATTRIBUTE1 VARCHAR2 (240)
PORG_USER_ATTRIBUTE2 VARCHAR2 (240)
PORG_USER_ATTRIBUTE3 VARCHAR2 (240)
PORG_USER_ATTRIBUTE4 VARCHAR2 (240)
PORG_USER_ATTRIBUTE5 VARCHAR2 (240)
SUBI_NAME VARCHAR2 (2000)
SUBI_DESCRIPTION VARCHAR2 (240)
SUBI_INSTANCE_CODE VARCHAR2 (40)
SUBI_STOCK_ROOM VARCHAR2 (80)
SUBI_STOCK_ROOM_DP VARCHAR2 (240)
SUBI_STOCK_ROOM_PK VARCHAR2 (240)
SUBI_STOCK_ROOM_PK_KEY NUMBER

SUBI_USER_ATTRIBUTE1 VARCHAR2 (240)
SUBI_USER_ATTRIBUTE2 VARCHAR2 (240)
SUBI_USER_ATTRIBUTE3 VARCHAR2 (240)
SUBI_USER_ATTRIBUTE4 VARCHAR2 (240)
SUBI_USER_ATTRIBUTE5 VARCHAR2 (240)
Query Text

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


SELECT ALL_NAME
,      ALL_PK
,      ALL_PK_KEY
,      CREATION_DATE
,      INVL_NAME
,      INVL_DESCRIPTION
,      INVL_ENABLED_FLAG
,      INVL_INSTANCE_CODE
,      INVL_LOCATOR_DP
,      INVL_LOCATOR_NAME
,      INVL_LOCATOR_PK
,      INVL_LOCATOR_PK_KEY
,      INVL_USER_ATTRIBUTE1
,      INVL_USER_ATTRIBUTE2
,      INVL_USER_ATTRIBUTE3
,      INVL_USER_ATTRIBUTE4
,      INVL_USER_ATTRIBUTE5
,      LAST_UPDATE_DATE
,      OU_BUSINESS_GROUP
,      OU_DATE_FROM
,      OU_DATE_TO
,      OU_INSTANCE_CODE
,      OU_INT_EXT_FLAG
,      OU_NAME
,      OU_OPERATING_UNIT_DP
,      OU_OPERATING_UNIT_PK
,      OU_OPERATING_UNIT_PK_KEY
,      OU_ORG_CODE
,      OU_ORG_TYPE
,      OU_PRIMARY_CST_MTHD
,      OU_USER_ATTRIBUTE1
,      OU_USER_ATTRIBUTE2
,      OU_USER_ATTRIBUTE3
,      OU_USER_ATTRIBUTE4
,      OU_USER_ATTRIBUTE5
,      PCMP_DESCRIPTION
,      PCMP_INSTANCE_CODE
,      PCMP_NAME
,      PCMP_OPM_COMPANY_PK
,      PCMP_OPM_COMPANY_CODE
,      PCMP_OPM_COMPANY_DP
,      PCMP_OPM_COMPANY_NAME
,      PCMP_OPM_COMPANY_PK_KEY
,      PCMP_USER_ATTRIBUTE1
,      PCMP_USER_ATTRIBUTE2
,      PCMP_USER_ATTRIBUTE3
,      PCMP_USER_ATTRIBUTE4
,      PCMP_USER_ATTRIBUTE5
,      PLNT_NAME
,      PLNT_ORGANIZATION_NAME
,      PLNT_DESCRIPTION
,      PLNT_INSTANCE_CODE
,      PLNT_ORGANIZATION_CODE
,      PLNT_PLANT_DP
,      PLNT_PLANT_PK
,      PLNT_PLANT_PK_KEY
,      PLNT_USER_ATTRIBUTE1
,      PLNT_USER_ATTRIBUTE2
,      PLNT_USER_ATTRIBUTE3
,      PLNT_USER_ATTRIBUTE4
,      PLNT_USER_ATTRIBUTE5
,      PORG_DESCRIPTION
,      PORG_INSTANCE_CODE
,      PORG_NAME
,      PORG_OPM_ORGANIZATION_CODE
,      PORG_OPM_ORGANIZATION_DP
,      PORG_OPM_ORGANIZATION_NAME
,      PORG_OPM_ORGANIZATION_PK
,      PORG_OPM_ORGANIZATION_PK_KEY
,      PORG_USER_ATTRIBUTE1
,      PORG_USER_ATTRIBUTE2
,      PORG_USER_ATTRIBUTE3
,      PORG_USER_ATTRIBUTE4
,      PORG_USER_ATTRIBUTE5
,      SUBI_NAME
,      SUBI_DESCRIPTION
,      SUBI_INSTANCE_CODE
,      SUBI_STOCK_ROOM
,      SUBI_STOCK_ROOM_DP
,      SUBI_STOCK_ROOM_PK
,      SUBI_STOCK_ROOM_PK_KEY
,      SUBI_USER_ATTRIBUTE1
,      SUBI_USER_ATTRIBUTE2
,      SUBI_USER_ATTRIBUTE3
,      SUBI_USER_ATTRIBUTE4
,      SUBI_USER_ATTRIBUTE5
FROM OPI.EDW_MTL_INVENTORY_LOC_M#;

Dependencies

[top of page]

OPI.EDW_MTL_INVENTORY_LOC_M# references the following:

SchemaOPI
TableEDW_MTL_INVENTORY_LOC_M
OPI.EDW_MTL_INVENTORY_LOC_M# is referenced by following:

SchemaAPPS
SynonymEDW_MTL_INVENTORY_LOC_M