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: HRI.EDW_ORGANIZATION_M

Object Details

Object Name:	EDW_ORGANIZATION_M
Object Type:	TABLE
Owner:	HRI
FND Design Data:	BIS.EDW_ORGANIZATION_M HRI.EDW_ORGANIZATION_M
Subobject Name:
Status:	VALID

This is Internal Organization dimension table. This is a denormalized star table and contains records for lowest level of the dimension and every level above.
Organizations and Organization hierarchies are used to describe the structures that exist within an Enterprise. In addition to particular organizations, the Internal Organization dimension enables you to access Primary organization hierarchies, Operational hierarchies and the relationships between Business Groups, legal entities, operating units, and organizations.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	30
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDW_ORGANIZATION_M_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	ORGA_ORGANIZATION_PK ORGA_ORGANIZATION_PK_KEY
EDW_ORGANIZATION_M_U2	NORMAL	UNIQUE	APPS_TS_SUMMARY	ORGA_ORGANIZATION_PK_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
ORGA_ORGANIZATION_PK	VARCHAR2	(120)		Textual Unique Identifier for the Organization Level
ORGA_BUSINESS_GROUP	VARCHAR2	(240)		Business group containing the organization
ORGA_DATE_TO	DATE			End date of the organization
ORGA_INSTANCE	VARCHAR2	(40)		Identity of Data Source
ORGA_NAME	VARCHAR2	(500)		Organization name for the Organization level
ORGA_ORG_CODE	VARCHAR2	(20)		Hidden code for the organization type from the data source
ORGA_ORG_INT_EXT_FLAG	VARCHAR2	(80)		Whether the organization is internal or external
ORGA_ORG_PRIM_CST_MTHD	VARCHAR2	(120)		Primary cost method for the organization
ORGA_ORG_TYPE	VARCHAR2	(80)		Organization type
ORGA_ORGANIZATION_PK_KEY	NUMBER		Yes	Unique Warehouse Identifier for the Organization Level
ORGA_ORGANIZATION_DP	VARCHAR2	(500)		Reserved for future use
ORGA_DATE_FROM	DATE			Start date of the organization
ORGA_USER_ATTRIBUTE1	VARCHAR2	(240)		User Defined Attribute
ORGA_USER_ATTRIBUTE2	VARCHAR2	(240)		User Defined Attribute
ORGA_USER_ATTRIBUTE3	VARCHAR2	(240)		User Defined Attribute
ORGA_USER_ATTRIBUTE4	VARCHAR2	(240)		User Defined Attribute
ORGA_USER_ATTRIBUTE5	VARCHAR2	(240)		User Defined Attribute
OPER_OPERATING_UNIT_PK	VARCHAR2	(240)		Textual Unique Identifier for the Operating Unit Level
OPER_BUSINESS_GROUP	VARCHAR2	(240)		Business group containing the operating unit
OPER_DATE_TO	DATE			End date of the operating unit
OPER_INSTANCE	VARCHAR2	(40)		Identity of Data Source
OPER_INT_EXT_FLAG	VARCHAR2	(80)		Whether the operating unit is an internal or external organization
OPER_NAME	VARCHAR2	(500)		Operating Unit name for the Operating Unit Level
OPER_OPERATING_UNIT_PK_KEY	NUMBER			Unique Warehouse Identifier for the Operating Unit Level
OPER_ORG_CODE	VARCHAR2	(20)		Hidden code for the operating unit organization type from the data source
OPER_ORG_TYPE	VARCHAR2	(80)		Operating unit organization type
OPER_PRIMARY_CST_MTHD	VARCHAR2	(120)		Primary cost method of the operating unit
OPER_OPERATING_UNIT_DP	VARCHAR2	(500)		Reserved for future use
OPER_DATE_FROM	DATE			Start date of the operating unit
OPER_USER_ATTRIBUTE1	VARCHAR2	(240)		User Defined Attribute
OPER_USER_ATTRIBUTE2	VARCHAR2	(240)		User Defined Attribute
OPER_USER_ATTRIBUTE3	VARCHAR2	(240)		User Defined Attribute
OPER_USER_ATTRIBUTE4	VARCHAR2	(240)		User Defined Attribute
OPER_USER_ATTRIBUTE5	VARCHAR2	(240)		User Defined Attribute
LGET_LEGAL_ENTITY_PK	VARCHAR2	(240)		Textual Unique Identifier for the Legal Entity Level
LGET_DATE_TO	DATE			End date of legal entity
LGET_INSTANCE	VARCHAR2	(40)		Identity of Data Source
LGET_INT_EXT_FLAG	VARCHAR2	(80)		Whether the legal entity is an internal or external organization
LGET_LEGAL_ENTITY_PK_KEY	NUMBER			Unique Warehouse Identifier for the Legal Entity Level
LGET_NAME	VARCHAR2	(500)		Legal Entity name for the Legal Entity Level
LGET_ORG_CODE	VARCHAR2	(20)		Hidden code for the legal entity organization type from the data source
LGET_ORG_TYPE	VARCHAR2	(80)		Legal entity organization type
LGET_PRIMARY_CST_MTHD	VARCHAR2	(120)		Primary cost method of legal entity
LGET_LEGAL_ENTITY_DP	VARCHAR2	(500)		Reserved for future use
LGET_SET_OF_BOOKS	VARCHAR2	(80)		Accounting books name
LGET_DATE_FROM	DATE			Start date of legal entity
LGET_USER_ATTRIBUTE1	VARCHAR2	(240)		User Defined Attribute
LGET_USER_ATTRIBUTE2	VARCHAR2	(240)		User Defined Attribute
LGET_USER_ATTRIBUTE3	VARCHAR2	(240)		User Defined Attribute
LGET_USER_ATTRIBUTE4	VARCHAR2	(240)		User Defined Attribute
LGET_USER_ATTRIBUTE5	VARCHAR2	(240)		User Defined Attribute
BGRP_BUSINESS_GROUP_PK	VARCHAR2	(80)		Textual Unique Identifier for the Business Group Level
BGRP_BUSINESS_GROUP_PK_KEY	NUMBER			Unique Warehouse Identifier for the Business Group Level
BGRP_DATE_TO	DATE			End date of business group
BGRP_INSTANCE	VARCHAR2	(40)		Identity of Data Source
BGRP_INT_EXT_FLAG	VARCHAR2	(80)		Whether the business group is an internal or external organization
BGRP_NAME	VARCHAR2	(240)		Business Group name for the Business Group Level
BGRP_ORG_CODE	VARCHAR2	(20)		Hidden code for the business group organization type from the data source
BGRP_ORG_TYPE	VARCHAR2	(80)		Business group organization type
BGRP_PRIMARY_CST_MTHD	VARCHAR2	(120)		Primary cost method for the business group
BGRP_BUSINESS_GROUP_DP	VARCHAR2	(240)		Reserved for future use
BGRP_DATE_FROM	DATE			Start date of business group
BGRP_USER_ATTRIBUTE1	VARCHAR2	(240)		User Defined Attribute
BGRP_USER_ATTRIBUTE2	VARCHAR2	(240)		User Defined Attribute
BGRP_USER_ATTRIBUTE3	VARCHAR2	(240)		User Defined Attribute
BGRP_USER_ATTRIBUTE4	VARCHAR2	(240)		User Defined Attribute
BGRP_USER_ATTRIBUTE5	VARCHAR2	(240)		User Defined Attribute
ALL_ALL_PK	VARCHAR2	(40)		Textual Unique Identifier for the All Organizations Level
ALL_ALL_PK_KEY	NUMBER			Unique Warehouse Identifier for the All Organizations Level
ALL_NAME	VARCHAR2	(80)		Name for All Level
CREATION_DATE	DATE			Standard who column
LAST_UPDATE_DATE	DATE			Standard who column
ORGA_ORGANIZATION_ID	NUMBER			Hidden Identifier for the Organization from the data source
ORGA_ORG_CAT_1	VARCHAR2	(240)		Reserved for future use
ORGA_ORG_CAT_10	VARCHAR2	(240)		Reserved for future use
ORGA_ORG_CAT_11	VARCHAR2	(240)		Reserved for future use
ORGA_ORG_CAT_12	VARCHAR2	(240)		Reserved for future use
ORGA_ORG_CAT_13	VARCHAR2	(240)		Reserved for future use
ORGA_ORG_CAT_14	VARCHAR2	(240)		Reserved for future use
ORGA_ORG_CAT_15	VARCHAR2	(240)		Reserved for future use
ORGA_ORG_CAT_2	VARCHAR2	(240)		Reserved for future use
ORGA_ORG_CAT_3	VARCHAR2	(240)		Reserved for future use
ORGA_ORG_CAT_4	VARCHAR2	(240)		Reserved for future use
ORGA_ORG_CAT_5	VARCHAR2	(240)		Reserved for future use
ORGA_ORG_CAT_6	VARCHAR2	(240)		Reserved for future use
ORGA_ORG_CAT_7	VARCHAR2	(240)		Reserved for future use
ORGA_ORG_CAT_8	VARCHAR2	(240)		Reserved for future use
ORGA_ORG_CAT_9	VARCHAR2	(240)		Reserved for future use
OPER_OPERATING_UNIT_ID	NUMBER			Hidden Identifier for the Operating Unit from the data source
LGET_LEGAL_ENTITY_ID	NUMBER			Hidden identifier for the Legal Entity from the source database
BGRP_BUSINESS_GROUP_ID	NUMBER			Hidden Identifier for the Business Group from the data source
BGRP_COST_ALLOCATION	VARCHAR2	(30)		Cost Allocation Key Flexfield name used by the business group
BGRP_LEGISLATION	VARCHAR2	(80)		Business group legislation
T1L1_ORG_TREE1_LVL1_PK_KEY	NUMBER			Internal use only
T1L1_BUSINESS_GROUP	VARCHAR2	(240)		Internal use only
T1L1_CREATION_DATE	DATE			Internal use only
T1L1_INSTANCE	VARCHAR2	(40)		Internal use only
T1L1_LAST_UPDATE_DATE	DATE			Internal use only
T1L1_NAME	VARCHAR2	(500)		Internal use only
T1L1_ORGANIZATION_ID	NUMBER			Internal use only
T1L1_ORG_TREE1_LVL1_PK	VARCHAR2	(400)		Internal use only
T1L1_PRIMARY_ORG_DP	VARCHAR2	(500)		Internal use only
T1L2_ORG_TREE1_LVL2_PK_KEY	NUMBER			Internal use only
T1L2_BUSINESS_GROUP	VARCHAR2	(240)		Internal use only
T1L2_CREATION_DATE	DATE			Internal use only
T1L2_INSTANCE	VARCHAR2	(40)		Internal use only
T1L2_LAST_UPDATE_DATE	DATE			Internal use only
T1L2_NAME	VARCHAR2	(500)		Internal use only
T1L2_ORGANIZATION_ID	NUMBER			Internal use only
T1L2_ORG_TREE1_LVL2_PK	VARCHAR2	(400)		Internal use only
T1L2_PRIMARY_ORG_DP	VARCHAR2	(500)		Internal use only
T1L3_ORG_TREE1_LVL3_PK_KEY	NUMBER			Internal use only
T1L3_BUSINESS_GROUP	VARCHAR2	(240)		Internal use only
T1L3_CREATION_DATE	DATE			Internal use only
T1L3_INSTANCE	VARCHAR2	(40)		Internal use only
T1L3_LAST_UPDATE_DATE	DATE			Internal use only
T1L3_NAME	VARCHAR2	(500)		Internal use only
T1L3_ORGANIZATION_ID	NUMBER			Internal use only
T1L3_ORG_TREE1_LVL3_PK	VARCHAR2	(400)		Internal use only
T1L3_PRIMARY_ORG_DP	VARCHAR2	(500)		Internal use only
T1L4_ORG_TREE1_LVL4_PK_KEY	NUMBER			Internal use only
T1L4_BUSINESS_GROUP	VARCHAR2	(240)		Internal use only
T1L4_CREATION_DATE	DATE			Internal use only
T1L4_INSTANCE	VARCHAR2	(40)		Internal use only
T1L4_LAST_UPDATE_DATE	DATE			Internal use only
T1L4_NAME	VARCHAR2	(500)		Internal use only
T1L4_ORGANIZATION_ID	NUMBER			Internal use only
T1L4_ORG_TREE1_LVL4_PK	VARCHAR2	(400)		Internal use only
T1L4_PRIMARY_ORG_DP	VARCHAR2	(500)		Internal use only
T1L5_ORG_TREE1_LVL5_PK_KEY	NUMBER			Internal use only
T1L5_BUSINESS_GROUP	VARCHAR2	(240)		Internal use only
T1L5_CREATION_DATE	DATE			Internal use only
T1L5_INSTANCE	VARCHAR2	(40)		Internal use only
T1L5_LAST_UPDATE_DATE	DATE			Internal use only
T1L5_NAME	VARCHAR2	(500)		Internal use only
T1L5_ORGANIZATION_ID	NUMBER			Internal use only
T1L5_ORG_TREE1_LVL5_PK	VARCHAR2	(400)		Internal use only
T1L5_PRIMARY_ORG_DP	VARCHAR2	(500)		Internal use only
T1L6_ORG_TREE1_LVL6_PK_KEY	NUMBER			Internal use only
T1L6_BUSINESS_GROUP	VARCHAR2	(240)		Internal use only
T1L6_CREATION_DATE	DATE			Internal use only
T1L6_INSTANCE	VARCHAR2	(40)		Internal use only
T1L6_LAST_UPDATE_DATE	DATE			Internal use only
T1L6_NAME	VARCHAR2	(500)		Internal use only
T1L6_ORGANIZATION_ID	NUMBER			Internal use only
T1L6_ORG_TREE1_LVL6_PK	VARCHAR2	(400)		Internal use only
T1L6_PRIMARY_ORG_DP	VARCHAR2	(500)		Internal use only
T1L7_ORG_TREE1_LVL7_PK_KEY	NUMBER			Internal use only
T1L7_BUSINESS_GROUP	VARCHAR2	(240)		Internal use only
T1L7_CREATION_DATE	DATE			Internal use only
T1L7_INSTANCE	VARCHAR2	(40)		Internal use only
T1L7_LAST_UPDATE_DATE	DATE			Internal use only
T1L7_NAME	VARCHAR2	(500)		Internal use only
T1L7_ORGANIZATION_ID	NUMBER			Internal use only
T1L7_ORG_TREE1_LVL7_PK	VARCHAR2	(400)		Internal use only
T1L7_PRIMARY_ORG_DP	VARCHAR2	(500)		Internal use only
T1L8_ORG_TREE1_LVL8_PK_KEY	NUMBER			Internal use only
T1L8_BUSINESS_GROUP	VARCHAR2	(240)		Internal use only
T1L8_CREATION_DATE	DATE			Internal use only
T1L8_INSTANCE	VARCHAR2	(40)		Internal use only
T1L8_LAST_UPDATE_DATE	DATE			Internal use only
T1L8_NAME	VARCHAR2	(500)		Internal use only
T1L8_ORGANIZATION_ID	NUMBER			Internal use only
T1L8_ORG_TREE1_LVL8_PK	VARCHAR2	(400)		Internal use only
T1L8_PRIMARY_ORG_DP	VARCHAR2	(500)		Internal use only
T1L1_USER_ATTRIBUTE1	VARCHAR2	(240)		Internal use only
T1L1_USER_ATTRIBUTE2	VARCHAR2	(240)		Internal use only
T1L1_USER_ATTRIBUTE3	VARCHAR2	(240)		Internal use only
T1L1_USER_ATTRIBUTE4	VARCHAR2	(240)		Internal use only
T1L1_USER_ATTRIBUTE5	VARCHAR2	(240)		Internal use only
T1L2_USER_ATTRIBUTE1	VARCHAR2	(240)		Internal use only
T1L2_USER_ATTRIBUTE2	VARCHAR2	(240)		Internal use only
T1L2_USER_ATTRIBUTE3	VARCHAR2	(240)		Internal use only
T1L2_USER_ATTRIBUTE4	VARCHAR2	(240)		Internal use only
T1L2_USER_ATTRIBUTE5	VARCHAR2	(240)		Internal use only
T1L3_USER_ATTRIBUTE1	VARCHAR2	(240)		Internal use only
T1L3_USER_ATTRIBUTE2	VARCHAR2	(240)		Internal use only
T1L3_USER_ATTRIBUTE3	VARCHAR2	(240)		Internal use only
T1L3_USER_ATTRIBUTE4	VARCHAR2	(240)		Internal use only
T1L3_USER_ATTRIBUTE5	VARCHAR2	(240)		Internal use only
T1L4_USER_ATTRIBUTE1	VARCHAR2	(240)		Internal use only
T1L4_USER_ATTRIBUTE2	VARCHAR2	(240)		Internal use only
T1L4_USER_ATTRIBUTE3	VARCHAR2	(240)		Internal use only
T1L4_USER_ATTRIBUTE4	VARCHAR2	(240)		Internal use only
T1L4_USER_ATTRIBUTE5	VARCHAR2	(240)		Internal use only
T1L5_USER_ATTRIBUTE1	VARCHAR2	(240)		Internal use only
T1L5_USER_ATTRIBUTE2	VARCHAR2	(240)		Internal use only
T1L5_USER_ATTRIBUTE3	VARCHAR2	(240)		Internal use only
T1L5_USER_ATTRIBUTE4	VARCHAR2	(240)		Internal use only
T1L5_USER_ATTRIBUTE5	VARCHAR2	(240)		Internal use only
T1L6_USER_ATTRIBUTE1	VARCHAR2	(240)		Internal use only
T1L6_USER_ATTRIBUTE2	VARCHAR2	(240)		Internal use only
T1L6_USER_ATTRIBUTE3	VARCHAR2	(240)		Internal use only
T1L6_USER_ATTRIBUTE4	VARCHAR2	(240)		Internal use only
T1L6_USER_ATTRIBUTE5	VARCHAR2	(240)		Internal use only
T1L7_USER_ATTRIBUTE1	VARCHAR2	(240)		Internal use only
T1L7_USER_ATTRIBUTE2	VARCHAR2	(240)		Internal use only
T1L7_USER_ATTRIBUTE3	VARCHAR2	(240)		Internal use only
T1L7_USER_ATTRIBUTE4	VARCHAR2	(240)		Internal use only
T1L7_USER_ATTRIBUTE5	VARCHAR2	(240)		Internal use only
T1L8_USER_ATTRIBUTE1	VARCHAR2	(240)		Internal use only
T1L8_USER_ATTRIBUTE2	VARCHAR2	(240)		Internal use only
T1L8_USER_ATTRIBUTE3	VARCHAR2	(240)		Internal use only
T1L8_USER_ATTRIBUTE4	VARCHAR2	(240)		Internal use only
T1L8_USER_ATTRIBUTE5	VARCHAR2	(240)		Internal use only
ORGA_PERSON_MANAGER_ID	NUMBER			Hidden Identifier for the cost centre manager from the data source
ORGA_PERSON_MANAGER_FK	VARCHAR2	(400)		Textual Foreign Key to the Person Dimension
ORGA_PERSON_MANAGER_FK_KEY	NUMBER			Warehouse Foreign Key to the Person Dimension

Query Text

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


SELECT ORGA_ORGANIZATION_PK
,      ORGA_BUSINESS_GROUP
,      ORGA_DATE_TO
,      ORGA_INSTANCE
,      ORGA_NAME
,      ORGA_ORG_CODE
,      ORGA_ORG_INT_EXT_FLAG
,      ORGA_ORG_PRIM_CST_MTHD
,      ORGA_ORG_TYPE
,      ORGA_ORGANIZATION_PK_KEY
,      ORGA_ORGANIZATION_DP
,      ORGA_DATE_FROM
,      ORGA_USER_ATTRIBUTE1
,      ORGA_USER_ATTRIBUTE2
,      ORGA_USER_ATTRIBUTE3
,      ORGA_USER_ATTRIBUTE4
,      ORGA_USER_ATTRIBUTE5
,      OPER_OPERATING_UNIT_PK
,      OPER_BUSINESS_GROUP
,      OPER_DATE_TO
,      OPER_INSTANCE
,      OPER_INT_EXT_FLAG
,      OPER_NAME
,      OPER_OPERATING_UNIT_PK_KEY
,      OPER_ORG_CODE
,      OPER_ORG_TYPE
,      OPER_PRIMARY_CST_MTHD
,      OPER_OPERATING_UNIT_DP
,      OPER_DATE_FROM
,      OPER_USER_ATTRIBUTE1
,      OPER_USER_ATTRIBUTE2
,      OPER_USER_ATTRIBUTE3
,      OPER_USER_ATTRIBUTE4
,      OPER_USER_ATTRIBUTE5
,      LGET_LEGAL_ENTITY_PK
,      LGET_DATE_TO
,      LGET_INSTANCE
,      LGET_INT_EXT_FLAG
,      LGET_LEGAL_ENTITY_PK_KEY
,      LGET_NAME
,      LGET_ORG_CODE
,      LGET_ORG_TYPE
,      LGET_PRIMARY_CST_MTHD
,      LGET_LEGAL_ENTITY_DP
,      LGET_SET_OF_BOOKS
,      LGET_DATE_FROM
,      LGET_USER_ATTRIBUTE1
,      LGET_USER_ATTRIBUTE2
,      LGET_USER_ATTRIBUTE3
,      LGET_USER_ATTRIBUTE4
,      LGET_USER_ATTRIBUTE5
,      BGRP_BUSINESS_GROUP_PK
,      BGRP_BUSINESS_GROUP_PK_KEY
,      BGRP_DATE_TO
,      BGRP_INSTANCE
,      BGRP_INT_EXT_FLAG
,      BGRP_NAME
,      BGRP_ORG_CODE
,      BGRP_ORG_TYPE
,      BGRP_PRIMARY_CST_MTHD
,      BGRP_BUSINESS_GROUP_DP
,      BGRP_DATE_FROM
,      BGRP_USER_ATTRIBUTE1
,      BGRP_USER_ATTRIBUTE2
,      BGRP_USER_ATTRIBUTE3
,      BGRP_USER_ATTRIBUTE4
,      BGRP_USER_ATTRIBUTE5
,      ALL_ALL_PK
,      ALL_ALL_PK_KEY
,      ALL_NAME
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      ORGA_ORGANIZATION_ID
,      ORGA_ORG_CAT_1
,      ORGA_ORG_CAT_10
,      ORGA_ORG_CAT_11
,      ORGA_ORG_CAT_12
,      ORGA_ORG_CAT_13
,      ORGA_ORG_CAT_14
,      ORGA_ORG_CAT_15
,      ORGA_ORG_CAT_2
,      ORGA_ORG_CAT_3
,      ORGA_ORG_CAT_4
,      ORGA_ORG_CAT_5
,      ORGA_ORG_CAT_6
,      ORGA_ORG_CAT_7
,      ORGA_ORG_CAT_8
,      ORGA_ORG_CAT_9
,      OPER_OPERATING_UNIT_ID
,      LGET_LEGAL_ENTITY_ID
,      BGRP_BUSINESS_GROUP_ID
,      BGRP_COST_ALLOCATION
,      BGRP_LEGISLATION
,      T1L1_ORG_TREE1_LVL1_PK_KEY
,      T1L1_BUSINESS_GROUP
,      T1L1_CREATION_DATE
,      T1L1_INSTANCE
,      T1L1_LAST_UPDATE_DATE
,      T1L1_NAME
,      T1L1_ORGANIZATION_ID
,      T1L1_ORG_TREE1_LVL1_PK
,      T1L1_PRIMARY_ORG_DP
,      T1L2_ORG_TREE1_LVL2_PK_KEY
,      T1L2_BUSINESS_GROUP
,      T1L2_CREATION_DATE
,      T1L2_INSTANCE
,      T1L2_LAST_UPDATE_DATE
,      T1L2_NAME
,      T1L2_ORGANIZATION_ID
,      T1L2_ORG_TREE1_LVL2_PK
,      T1L2_PRIMARY_ORG_DP
,      T1L3_ORG_TREE1_LVL3_PK_KEY
,      T1L3_BUSINESS_GROUP
,      T1L3_CREATION_DATE
,      T1L3_INSTANCE
,      T1L3_LAST_UPDATE_DATE
,      T1L3_NAME
,      T1L3_ORGANIZATION_ID
,      T1L3_ORG_TREE1_LVL3_PK
,      T1L3_PRIMARY_ORG_DP
,      T1L4_ORG_TREE1_LVL4_PK_KEY
,      T1L4_BUSINESS_GROUP
,      T1L4_CREATION_DATE
,      T1L4_INSTANCE
,      T1L4_LAST_UPDATE_DATE
,      T1L4_NAME
,      T1L4_ORGANIZATION_ID
,      T1L4_ORG_TREE1_LVL4_PK
,      T1L4_PRIMARY_ORG_DP
,      T1L5_ORG_TREE1_LVL5_PK_KEY
,      T1L5_BUSINESS_GROUP
,      T1L5_CREATION_DATE
,      T1L5_INSTANCE
,      T1L5_LAST_UPDATE_DATE
,      T1L5_NAME
,      T1L5_ORGANIZATION_ID
,      T1L5_ORG_TREE1_LVL5_PK
,      T1L5_PRIMARY_ORG_DP
,      T1L6_ORG_TREE1_LVL6_PK_KEY
,      T1L6_BUSINESS_GROUP
,      T1L6_CREATION_DATE
,      T1L6_INSTANCE
,      T1L6_LAST_UPDATE_DATE
,      T1L6_NAME
,      T1L6_ORGANIZATION_ID
,      T1L6_ORG_TREE1_LVL6_PK
,      T1L6_PRIMARY_ORG_DP
,      T1L7_ORG_TREE1_LVL7_PK_KEY
,      T1L7_BUSINESS_GROUP
,      T1L7_CREATION_DATE
,      T1L7_INSTANCE
,      T1L7_LAST_UPDATE_DATE
,      T1L7_NAME
,      T1L7_ORGANIZATION_ID
,      T1L7_ORG_TREE1_LVL7_PK
,      T1L7_PRIMARY_ORG_DP
,      T1L8_ORG_TREE1_LVL8_PK_KEY
,      T1L8_BUSINESS_GROUP
,      T1L8_CREATION_DATE
,      T1L8_INSTANCE
,      T1L8_LAST_UPDATE_DATE
,      T1L8_NAME
,      T1L8_ORGANIZATION_ID
,      T1L8_ORG_TREE1_LVL8_PK
,      T1L8_PRIMARY_ORG_DP
,      T1L1_USER_ATTRIBUTE1
,      T1L1_USER_ATTRIBUTE2
,      T1L1_USER_ATTRIBUTE3
,      T1L1_USER_ATTRIBUTE4
,      T1L1_USER_ATTRIBUTE5
,      T1L2_USER_ATTRIBUTE1
,      T1L2_USER_ATTRIBUTE2
,      T1L2_USER_ATTRIBUTE3
,      T1L2_USER_ATTRIBUTE4
,      T1L2_USER_ATTRIBUTE5
,      T1L3_USER_ATTRIBUTE1
,      T1L3_USER_ATTRIBUTE2
,      T1L3_USER_ATTRIBUTE3
,      T1L3_USER_ATTRIBUTE4
,      T1L3_USER_ATTRIBUTE5
,      T1L4_USER_ATTRIBUTE1
,      T1L4_USER_ATTRIBUTE2
,      T1L4_USER_ATTRIBUTE3
,      T1L4_USER_ATTRIBUTE4
,      T1L4_USER_ATTRIBUTE5
,      T1L5_USER_ATTRIBUTE1
,      T1L5_USER_ATTRIBUTE2
,      T1L5_USER_ATTRIBUTE3
,      T1L5_USER_ATTRIBUTE4
,      T1L5_USER_ATTRIBUTE5
,      T1L6_USER_ATTRIBUTE1
,      T1L6_USER_ATTRIBUTE2
,      T1L6_USER_ATTRIBUTE3
,      T1L6_USER_ATTRIBUTE4
,      T1L6_USER_ATTRIBUTE5
,      T1L7_USER_ATTRIBUTE1
,      T1L7_USER_ATTRIBUTE2
,      T1L7_USER_ATTRIBUTE3
,      T1L7_USER_ATTRIBUTE4
,      T1L7_USER_ATTRIBUTE5
,      T1L8_USER_ATTRIBUTE1
,      T1L8_USER_ATTRIBUTE2
,      T1L8_USER_ATTRIBUTE3
,      T1L8_USER_ATTRIBUTE4
,      T1L8_USER_ATTRIBUTE5
,      ORGA_PERSON_MANAGER_ID
,      ORGA_PERSON_MANAGER_FK
,      ORGA_PERSON_MANAGER_FK_KEY
FROM HRI.EDW_ORGANIZATION_M;

Dependencies

[top of page]

HRI.EDW_ORGANIZATION_M does not reference any database object

HRI.EDW_ORGANIZATION_M is referenced by following:

APPS: EDW_ORGANIZATION_M