eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OPI.EDW_MTL_INVENTORY_LOC_M

Object Details

Object Name:	EDW_MTL_INVENTORY_LOC_M
Object Type:	TABLE
Owner:	OPI
FND Design Data:	BIS.EDW_MTL_INVENTORY_LOC_M OPI.EDW_MTL_INVENTORY_LOC_M
Subobject Name:
Status:	VALID

Dimension Table for the Inventory Locator Dimension

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDW_MTL_INVENTORY_LOC_M_P	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	INVL_LOCATOR_PK_KEY
EDW_MTL_INVENTORY_LOC_M_U	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	INVL_LOCATOR_PK

Columns

Name	Datatype	Length	Mandatory	Comments
ALL_NAME	VARCHAR2	(80)		Name of the All Level
ALL_PK	VARCHAR2	(40)		Primary Key of the All Level
ALL_PK_KEY	NUMBER			EDW-Internal Surrogate key to the All Level
CREATION_DATE	DATE		Yes	Creation Date
INVL_NAME	VARCHAR2	(2000)		Locator Name
INVL_DESCRIPTION	VARCHAR2	(240)		Description of Inventory Location
INVL_ENABLED_FLAG	VARCHAR2	(20)		Indicates whether Locator is active
INVL_INSTANCE_CODE	VARCHAR2	(40)		Instance from which this Locator was pushed
INVL_LOCATOR_DP	VARCHAR2	(240)		EDW-internal ID for Locator
INVL_LOCATOR_NAME	VARCHAR2	(240)		Locator Name
INVL_LOCATOR_PK	VARCHAR2	(320)		Primary Key for Location (unique across instances and source-types)
INVL_LOCATOR_PK_KEY	NUMBER		Yes	EDW-assigned surrogate for Locator
INVL_USER_ATTRIBUTE1	VARCHAR2	(240)		1st Flexfield from Inventory Location record on OLTP
INVL_USER_ATTRIBUTE2	VARCHAR2	(240)		2nd Flexfield from Inventory Location record on OLTP
INVL_USER_ATTRIBUTE3	VARCHAR2	(240)		3rd Flexfield from Inventory Location record on OLTP
INVL_USER_ATTRIBUTE4	VARCHAR2	(240)		4th Flexfield from Inventory Location record on OLTP
INVL_USER_ATTRIBUTE5	VARCHAR2	(240)		5th Flexfield from Inventory Location record on OLTP
LAST_UPDATE_DATE	DATE		Yes	Last Update Date
OU_BUSINESS_GROUP	VARCHAR2	(120)		Business Group attribute of Operating Unit Level
OU_DATE_FROM	DATE			Beginning Effective Date for Operating Unit
OU_DATE_TO	DATE			Ending Effective Date for Operating Unit
OU_INSTANCE_CODE	VARCHAR2	(40)		Instance from which this Operating Unit was pushed
OU_INT_EXT_FLAG	VARCHAR2	(120)		Flag indicates if Operating Unit is Internal or External
OU_NAME	VARCHAR2	(320)		Operating Unit Name
OU_OPERATING_UNIT_DP	VARCHAR2	(240)		EDW-internal ID for Operating Unit
OU_OPERATING_UNIT_PK	VARCHAR2	(240)		Primary Key of Operating Unit
OU_OPERATING_UNIT_PK_KEY	NUMBER			EDW-internal Surrogate Key for Operating Unit
OU_ORG_CODE	VARCHAR2	(40)		Operating Unit Code
OU_ORG_TYPE	VARCHAR2	(120)		Organization Type of Operating Unit
OU_PRIMARY_CST_MTHD	VARCHAR2	(120)		Cost Method for Operating Unit
OU_USER_ATTRIBUTE1	VARCHAR2	(240)		1st Flexfield from Operating Unit record on OLTP
OU_USER_ATTRIBUTE2	VARCHAR2	(240)		2nd Flexfield from Operating Unit record on OLTP
OU_USER_ATTRIBUTE3	VARCHAR2	(240)		3rd Flexfield from Operating Unit record on OLTP
OU_USER_ATTRIBUTE4	VARCHAR2	(240)		4th Flexfield from Operating Unit record on OLTP
OU_USER_ATTRIBUTE5	VARCHAR2	(240)		5th Flexfield from Operating Unit record on OLTP
PCMP_DESCRIPTION	VARCHAR2	(240)		Description of Inventory Organization Parent Group
PCMP_INSTANCE_CODE	VARCHAR2	(40)		Instance from which this Parent Group was pushed
PCMP_NAME	VARCHAR2	(320)		Name of Inventory Organization Parent Group
PCMP_OPM_COMPANY_PK	VARCHAR2	(120)		Inventory Org Parent Group Primary Key (Includes Instance)
PCMP_OPM_COMPANY_CODE	VARCHAR2	(40)		Organization Code of the Inventory Organization Parent Group
PCMP_OPM_COMPANY_DP	VARCHAR2	(240)		EDW-internal ID for Parent Group
PCMP_OPM_COMPANY_NAME	VARCHAR2	(120)		Name of Inventory Organization Parent Group
PCMP_OPM_COMPANY_PK_KEY	NUMBER			Primary Key of Parent Group, unique across instances and system types
PCMP_USER_ATTRIBUTE1	VARCHAR2	(240)		1st Flexfield from Inventory Org Parent Group record on OLTP
PCMP_USER_ATTRIBUTE2	VARCHAR2	(240)		2nd Flexfield from Inventory Org Parent Group record on OLTP
PCMP_USER_ATTRIBUTE3	VARCHAR2	(240)		3rd Flexfield from Inventory Org Parent Group record on OLTP
PCMP_USER_ATTRIBUTE4	VARCHAR2	(240)		4th Flexfield from Inventory Org Parent Group record on OLTP
PCMP_USER_ATTRIBUTE5	VARCHAR2	(240)		5th Flexfield from Inventory Org Parent Group record on OLTP
PLNT_NAME	VARCHAR2	(2000)		Name of Inventory Organization
PLNT_ORGANIZATION_NAME	VARCHAR2	(240)		Name of Inventory Organization
PLNT_DESCRIPTION	VARCHAR2	(240)		Description of Inventory Organization
PLNT_INSTANCE_CODE	VARCHAR2	(40)		Instance from which this Inventory Organization was pushed
PLNT_ORGANIZATION_CODE	VARCHAR2	(40)		Organization Code of the Inventory Organization
PLNT_PLANT_DP	VARCHAR2	(240)		EDW-internal ID for Inventory Organization
PLNT_PLANT_PK	VARCHAR2	(120)		Primary Key of Inventory Organization, unique across instances and system types
PLNT_PLANT_PK_KEY	NUMBER			EDW-internal Surrogate Key for Inventory Organization
PLNT_USER_ATTRIBUTE1	VARCHAR2	(240)		1st Flexfield from Inventory Organization record on OLTP
PLNT_USER_ATTRIBUTE2	VARCHAR2	(240)		2nd Flexfield from Inventory Organization record on OLTP
PLNT_USER_ATTRIBUTE3	VARCHAR2	(240)		3rd Flexfield from Inventory Organization record on OLTP
PLNT_USER_ATTRIBUTE4	VARCHAR2	(240)		4th Flexfield from Inventory Organization record on OLTP
PLNT_USER_ATTRIBUTE5	VARCHAR2	(240)		5th Flexfield from Inventory Organization record on OLTP
PORG_DESCRIPTION	VARCHAR2	(240)		Description of Inventory Organization Group
PORG_INSTANCE_CODE	VARCHAR2	(40)		Instance from which this Inventory Organization Group was pushed
PORG_NAME	VARCHAR2	(320)		Name of Inventory Organization Group
PORG_OPM_ORGANIZATION_CODE	VARCHAR2	(80)		Organization Code of Inventory Organization Group
PORG_OPM_ORGANIZATION_DP	VARCHAR2	(240)		EDW-internal ID for Inventory Organization Group
PORG_OPM_ORGANIZATION_NAME	VARCHAR2	(240)		Name of the Inventory Organization Group
PORG_OPM_ORGANIZATION_PK	VARCHAR2	(120)		Primary Key of Inventory Organization Group, unique across instances and system types
PORG_OPM_ORGANIZATION_PK_KEY	NUMBER			EDW-internal ID for Inventory Organization Group
PORG_USER_ATTRIBUTE1	VARCHAR2	(240)		1st Flexfield from Inventory Organization Group record on OLTP
PORG_USER_ATTRIBUTE2	VARCHAR2	(240)		2nd Flexfield from Inventory Organization Group record on OLTP
PORG_USER_ATTRIBUTE3	VARCHAR2	(240)		3rd Flexfield from Inventory Organization Group record on OLTP
PORG_USER_ATTRIBUTE4	VARCHAR2	(240)		4th Flexfield from Inventory Organization Group record on OLTP
PORG_USER_ATTRIBUTE5	VARCHAR2	(240)		5th Flexfield from Inventory Organization Group record on OLTP
SUBI_NAME	VARCHAR2	(2000)		Name of SubInventory
SUBI_DESCRIPTION	VARCHAR2	(240)		Description of SubInventory
SUBI_INSTANCE_CODE	VARCHAR2	(40)		Instance from which this SubInventory was pushed
SUBI_STOCK_ROOM	VARCHAR2	(80)		SubInventory Name
SUBI_STOCK_ROOM_DP	VARCHAR2	(240)		EDW-internal ID for SubInventory
SUBI_STOCK_ROOM_PK	VARCHAR2	(240)		Primary Key of SubInventory, unique across instances and system types
SUBI_STOCK_ROOM_PK_KEY	NUMBER			EDW-internal ID for SubInventory
SUBI_USER_ATTRIBUTE1	VARCHAR2	(240)		1st Flexfield from SubInventory record on OLTP
SUBI_USER_ATTRIBUTE2	VARCHAR2	(240)		2nd Flexfield from SubInventory record on OLTP
SUBI_USER_ATTRIBUTE3	VARCHAR2	(240)		3rd Flexfield from SubInventory record on OLTP
SUBI_USER_ATTRIBUTE4	VARCHAR2	(240)		4th Flexfield from SubInventory record on OLTP
SUBI_USER_ATTRIBUTE5	VARCHAR2	(240)		5th Flexfield from SubInventory record on OLTP

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 does not reference any database object

OPI.EDW_MTL_INVENTORY_LOC_M is referenced by following:

APPS: EDW_MTL_INVENTORY_LOC_M