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]

VIEW: APPS.EDW_MTL_ILDM_OU_LCV

Object Details

Object Name:	EDW_MTL_ILDM_OU_LCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OPI.EDW_MTL_ILDM_OU_LCV
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Source View for the Operating Unit level of the Inventory Locator Dimension

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OPERATING_UNIT_PK	VARCHAR2	(71)		Primary key on the operating unit.
OPERATING_UNIT_DP	VARCHAR2	(483)		EDW-internal Identifier for the operating unit.
NAME	VARCHAR2	(483)		Operating unit name.
BUSINESS_GROUP	VARCHAR2	(240)	Yes	Business group that the operating unit belongs to.
DATE_FROM	DATE		Yes	Beginning validity date for the operating unit.
DATE_TO	DATE			Ending validity date for the operating unit.
INT_EXT_FLAG	VARCHAR2	(4000)		Flag indicates if operating unit is internal or external.
ORG_TYPE	VARCHAR2	(4000)		Organization type of operating unit.
ORG_CODE	VARCHAR2	(3)		Operating unit code.
PRIMARY_CST_MTHD	NUMBER			Cost method for the operating unit.
INSTANCE	VARCHAR2	(30)		Instance from which this row was pushed.
ALL_FK	CHAR	(3)		Foriegn key on the All Level.
USER_ATTRIBUTE1	VARCHAR2	(0)		User Defined Attribute1.
USER_ATTRIBUTE2	VARCHAR2	(0)		User Defined Attribute2.
USER_ATTRIBUTE3	VARCHAR2	(0)		User Defined Attribute3.
USER_ATTRIBUTE4	VARCHAR2	(0)		User Defined Attribute4.
USER_ATTRIBUTE5	VARCHAR2	(0)		User Defined Attribute5.
CREATION_DATE	DATE			Standard WHO column.
LAST_UPDATE_DATE	DATE			Standard WHO column.

Query Text

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


SELECT OPERATING_UNIT_PK
,      OPERATING_UNIT_DP
,      NAME
,      BUSINESS_GROUP
,      DATE_FROM
,      DATE_TO
,      INT_EXT_FLAG
,      ORG_TYPE
,      ORG_CODE
,      PRIMARY_CST_MTHD
,      INSTANCE
,      ALL_FK
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM APPS.EDW_MTL_ILDM_OU_LCV;

Dependencies

[top of page]

APPS.EDW_MTL_ILDM_OU_LCV references the following:

APPS: EDW_ORGA_OPER_UNIT_LCV; HR_GENERAL - show dependent code

APPS.EDW_MTL_ILDM_OU_LCV is referenced by following:

APPS: EDW_MTL_ILDM_LOCATOR_LCV; EDW_MTL_ILDM_PCMP_LCV; EDW_MTL_ILDM_PLANT_LCV; EDW_MTL_ILDM_PORG_LCV; EDW_MTL_ILDM_SUB_INV_LCV