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: BIM.EDW_BIM_TGSMT_M#

Object Details

Object Name:	EDW_BIM_TGSMT_M#
Object Type:	VIEW
Owner:	BIM
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
L9_TGTSGMT_PK_KEY	NUMBER		Yes
L8_TGTSGMT_PK_KEY	NUMBER
L7_TGTSGMT_PK_KEY	NUMBER
L6_TGTSGMT_PK_KEY	NUMBER
L5_TGTSGMT_PK_KEY	NUMBER
L4_TGTSGMT_PK_KEY	NUMBER
L3_TGTSGMT_PK_KEY	NUMBER
L2_TGTSGMT_PK_KEY	NUMBER
L1_TGTSGMT_PK_KEY	NUMBER
L0_ALL_PK_KEY	NUMBER
L0_ALL_PK	VARCHAR2	(40)
L0_NAME	VARCHAR2	(80)
L1_TGTSGMT_PK	VARCHAR2	(120)
L1_TGTSGMT_DP	VARCHAR2	(240)
L1_NAME	VARCHAR2	(240)
L1_TGTSGMT_ID	NUMBER
L1_TGTSGMT_CODE	VARCHAR2	(40)
L1_MARKET_SEGMENT_FLAG	VARCHAR2	(20)
L1_ENABLED_FLAG	VARCHAR2	(20)
L1_ORIGINAL_SIZE	NUMBER
L1_TGTSGMT_NAME	VARCHAR2	(240)
L1_DESCRIPTION	VARCHAR2	(4000)
L1_INSTANCE	VARCHAR2	(40)
L1_USER_ATTRIBUTE1	VARCHAR2	(240)
L1_USER_ATTRIBUTE2	VARCHAR2	(240)
L1_USER_ATTRIBUTE3	VARCHAR2	(240)
L1_USER_ATTRIBUTE4	VARCHAR2	(240)
L1_USER_ATTRIBUTE5	VARCHAR2	(240)
L2_TGTSGMT_PK	VARCHAR2	(120)
L2_TGTSGMT_DP	VARCHAR2	(240)
L2_NAME	VARCHAR2	(240)
L2_TGTSGMT_ID	NUMBER
L2_TGTSGMT_CODE	VARCHAR2	(40)
L2_MARKET_SEGMENT_FLAG	VARCHAR2	(20)
L2_ENABLED_FLAG	VARCHAR2	(20)
L2_ORIGINAL_SIZE	NUMBER
L2_TGTSGMT_NAME	VARCHAR2	(240)
L2_DESCRIPTION	VARCHAR2	(4000)
L2_INSTANCE	VARCHAR2	(40)
L2_USER_ATTRIBUTE1	VARCHAR2	(240)
L2_USER_ATTRIBUTE2	VARCHAR2	(240)
L2_USER_ATTRIBUTE3	VARCHAR2	(240)
L2_USER_ATTRIBUTE4	VARCHAR2	(240)
L2_USER_ATTRIBUTE5	VARCHAR2	(240)
L3_TGTSGMT_PK	VARCHAR2	(120)
L3_TGTSGMT_DP	VARCHAR2	(240)
L3_NAME	VARCHAR2	(240)
L3_TGTSGMT_ID	NUMBER
L3_TGTSGMT_CODE	VARCHAR2	(40)
L3_MARKET_SEGMENT_FLAG	VARCHAR2	(20)
L3_ENABLED_FLAG	VARCHAR2	(20)
L3_ORIGINAL_SIZE	NUMBER
L3_TGTSGMT_NAME	VARCHAR2	(240)
L3_DESCRIPTION	VARCHAR2	(4000)
L3_INSTANCE	VARCHAR2	(40)
L3_USER_ATTRIBUTE1	VARCHAR2	(240)
L3_USER_ATTRIBUTE2	VARCHAR2	(240)
L3_USER_ATTRIBUTE3	VARCHAR2	(240)
L3_USER_ATTRIBUTE4	VARCHAR2	(240)
L3_USER_ATTRIBUTE5	VARCHAR2	(240)
L4_TGTSGMT_PK	VARCHAR2	(120)
L4_TGTSGMT_DP	VARCHAR2	(240)
L4_NAME	VARCHAR2	(240)
L4_TGTSGMT_ID	NUMBER
L4_TGTSGMT_CODE	VARCHAR2	(40)
L4_MARKET_SEGMENT_FLAG	VARCHAR2	(20)
L4_ENABLED_FLAG	VARCHAR2	(20)
L4_ORIGINAL_SIZE	NUMBER
L4_TGTSGMT_NAME	VARCHAR2	(240)
L4_DESCRIPTION	VARCHAR2	(4000)
L4_INSTANCE	VARCHAR2	(40)
L4_USER_ATTRIBUTE1	VARCHAR2	(240)
L4_USER_ATTRIBUTE2	VARCHAR2	(240)
L4_USER_ATTRIBUTE3	VARCHAR2	(240)
L4_USER_ATTRIBUTE4	VARCHAR2	(240)
L4_USER_ATTRIBUTE5	VARCHAR2	(240)
L5_TGTSGMT_PK	VARCHAR2	(120)
L5_TGTSGMT_DP	VARCHAR2	(240)
L5_NAME	VARCHAR2	(240)
L5_TGTSGMT_ID	NUMBER
L5_TGTSGMT_CODE	VARCHAR2	(40)
L5_MARKET_SEGMENT_FLAG	VARCHAR2	(20)
L5_ENABLED_FLAG	VARCHAR2	(20)
L5_ORIGINAL_SIZE	NUMBER
L5_TGTSGMT_NAME	VARCHAR2	(240)
L5_DESCRIPTION	VARCHAR2	(4000)
L5_INSTANCE	VARCHAR2	(40)
L5_USER_ATTRIBUTE1	VARCHAR2	(240)
L5_USER_ATTRIBUTE2	VARCHAR2	(240)
L5_USER_ATTRIBUTE3	VARCHAR2	(240)
L5_USER_ATTRIBUTE4	VARCHAR2	(240)
L5_USER_ATTRIBUTE5	VARCHAR2	(240)
L6_TGTSGMT_PK	VARCHAR2	(120)
L6_TGTSGMT_DP	VARCHAR2	(240)
L6_NAME	VARCHAR2	(240)
L6_TGTSGMT_ID	NUMBER
L6_TGTSGMT_CODE	VARCHAR2	(40)
L6_MARKET_SEGMENT_FLAG	VARCHAR2	(20)
L6_ENABLED_FLAG	VARCHAR2	(20)
L6_ORIGINAL_SIZE	NUMBER
L6_TGTSGMT_NAME	VARCHAR2	(240)
L6_DESCRIPTION	VARCHAR2	(4000)
L6_INSTANCE	VARCHAR2	(40)
L6_USER_ATTRIBUTE1	VARCHAR2	(240)
L6_USER_ATTRIBUTE2	VARCHAR2	(240)
L6_USER_ATTRIBUTE3	VARCHAR2	(240)
L6_USER_ATTRIBUTE4	VARCHAR2	(240)
L6_USER_ATTRIBUTE5	VARCHAR2	(240)
L7_TGTSGMT_PK	VARCHAR2	(120)
L7_TGTSGMT_DP	VARCHAR2	(240)
L7_NAME	VARCHAR2	(240)
L7_TGTSGMT_ID	NUMBER
L7_TGTSGMT_CODE	VARCHAR2	(40)
L7_MARKET_SEGMENT_FLAG	VARCHAR2	(20)
L7_ENABLED_FLAG	VARCHAR2	(20)
L7_ORIGINAL_SIZE	NUMBER
L7_TGTSGMT_NAME	VARCHAR2	(240)
L7_DESCRIPTION	VARCHAR2	(4000)
L7_INSTANCE	VARCHAR2	(40)
L7_USER_ATTRIBUTE1	VARCHAR2	(240)
L7_USER_ATTRIBUTE2	VARCHAR2	(240)
L7_USER_ATTRIBUTE3	VARCHAR2	(240)
L7_USER_ATTRIBUTE4	VARCHAR2	(240)
L7_USER_ATTRIBUTE5	VARCHAR2	(240)
L8_TGTSGMT_PK	VARCHAR2	(120)
L8_TGTSGMT_DP	VARCHAR2	(240)
L8_NAME	VARCHAR2	(240)
L8_TGTSGMT_ID	NUMBER
L8_TGTSGMT_CODE	VARCHAR2	(40)
L8_MARKET_SEGMENT_FLAG	VARCHAR2	(20)
L8_ENABLED_FLAG	VARCHAR2	(20)
L8_ORIGINAL_SIZE	NUMBER
L8_TGTSGMT_NAME	VARCHAR2	(240)
L8_DESCRIPTION	VARCHAR2	(4000)
L8_INSTANCE	VARCHAR2	(40)
L8_USER_ATTRIBUTE1	VARCHAR2	(4000)
L8_USER_ATTRIBUTE2	VARCHAR2	(4000)
L8_USER_ATTRIBUTE3	VARCHAR2	(4000)
L8_USER_ATTRIBUTE4	VARCHAR2	(4000)
L8_USER_ATTRIBUTE5	VARCHAR2	(4000)
L9_TGTSGMT_PK	VARCHAR2	(120)
L9_TGTSGMT_DP	VARCHAR2	(240)
L9_NAME	VARCHAR2	(240)
L9_TGTSGMT_ID	NUMBER
L9_TGTSGMT_CODE	VARCHAR2	(40)
L9_MARKET_SEGMENT_FLAG	VARCHAR2	(20)
L9_ENABLED_FLAG	VARCHAR2	(20)
L9_ORIGINAL_SIZE	NUMBER
L9_TGTSGMT_NAME	VARCHAR2	(240)
L9_DESCRIPTION	VARCHAR2	(4000)
L9_INSTANCE	VARCHAR2	(40)
L9_USER_ATTRIBUTE1	VARCHAR2	(240)
L9_USER_ATTRIBUTE2	VARCHAR2	(240)
L9_USER_ATTRIBUTE3	VARCHAR2	(240)
L9_USER_ATTRIBUTE4	VARCHAR2	(240)
L9_USER_ATTRIBUTE5	VARCHAR2	(240)
L9_LAST_UPDATE_DATE	DATE
L9_CREATION_DATE	DATE
SECURITY_GROUP_ID	NUMBER
LAST_UPDATE_DATE	DATE		Yes
CREATION_DATE	DATE		Yes

Query Text

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


SELECT L9_TGTSGMT_PK_KEY
,      L8_TGTSGMT_PK_KEY
,      L7_TGTSGMT_PK_KEY
,      L6_TGTSGMT_PK_KEY
,      L5_TGTSGMT_PK_KEY
,      L4_TGTSGMT_PK_KEY
,      L3_TGTSGMT_PK_KEY
,      L2_TGTSGMT_PK_KEY
,      L1_TGTSGMT_PK_KEY
,      L0_ALL_PK_KEY
,      L0_ALL_PK
,      L0_NAME
,      L1_TGTSGMT_PK
,      L1_TGTSGMT_DP
,      L1_NAME
,      L1_TGTSGMT_ID
,      L1_TGTSGMT_CODE
,      L1_MARKET_SEGMENT_FLAG
,      L1_ENABLED_FLAG
,      L1_ORIGINAL_SIZE
,      L1_TGTSGMT_NAME
,      L1_DESCRIPTION
,      L1_INSTANCE
,      L1_USER_ATTRIBUTE1
,      L1_USER_ATTRIBUTE2
,      L1_USER_ATTRIBUTE3
,      L1_USER_ATTRIBUTE4
,      L1_USER_ATTRIBUTE5
,      L2_TGTSGMT_PK
,      L2_TGTSGMT_DP
,      L2_NAME
,      L2_TGTSGMT_ID
,      L2_TGTSGMT_CODE
,      L2_MARKET_SEGMENT_FLAG
,      L2_ENABLED_FLAG
,      L2_ORIGINAL_SIZE
,      L2_TGTSGMT_NAME
,      L2_DESCRIPTION
,      L2_INSTANCE
,      L2_USER_ATTRIBUTE1
,      L2_USER_ATTRIBUTE2
,      L2_USER_ATTRIBUTE3
,      L2_USER_ATTRIBUTE4
,      L2_USER_ATTRIBUTE5
,      L3_TGTSGMT_PK
,      L3_TGTSGMT_DP
,      L3_NAME
,      L3_TGTSGMT_ID
,      L3_TGTSGMT_CODE
,      L3_MARKET_SEGMENT_FLAG
,      L3_ENABLED_FLAG
,      L3_ORIGINAL_SIZE
,      L3_TGTSGMT_NAME
,      L3_DESCRIPTION
,      L3_INSTANCE
,      L3_USER_ATTRIBUTE1
,      L3_USER_ATTRIBUTE2
,      L3_USER_ATTRIBUTE3
,      L3_USER_ATTRIBUTE4
,      L3_USER_ATTRIBUTE5
,      L4_TGTSGMT_PK
,      L4_TGTSGMT_DP
,      L4_NAME
,      L4_TGTSGMT_ID
,      L4_TGTSGMT_CODE
,      L4_MARKET_SEGMENT_FLAG
,      L4_ENABLED_FLAG
,      L4_ORIGINAL_SIZE
,      L4_TGTSGMT_NAME
,      L4_DESCRIPTION
,      L4_INSTANCE
,      L4_USER_ATTRIBUTE1
,      L4_USER_ATTRIBUTE2
,      L4_USER_ATTRIBUTE3
,      L4_USER_ATTRIBUTE4
,      L4_USER_ATTRIBUTE5
,      L5_TGTSGMT_PK
,      L5_TGTSGMT_DP
,      L5_NAME
,      L5_TGTSGMT_ID
,      L5_TGTSGMT_CODE
,      L5_MARKET_SEGMENT_FLAG
,      L5_ENABLED_FLAG
,      L5_ORIGINAL_SIZE
,      L5_TGTSGMT_NAME
,      L5_DESCRIPTION
,      L5_INSTANCE
,      L5_USER_ATTRIBUTE1
,      L5_USER_ATTRIBUTE2
,      L5_USER_ATTRIBUTE3
,      L5_USER_ATTRIBUTE4
,      L5_USER_ATTRIBUTE5
,      L6_TGTSGMT_PK
,      L6_TGTSGMT_DP
,      L6_NAME
,      L6_TGTSGMT_ID
,      L6_TGTSGMT_CODE
,      L6_MARKET_SEGMENT_FLAG
,      L6_ENABLED_FLAG
,      L6_ORIGINAL_SIZE
,      L6_TGTSGMT_NAME
,      L6_DESCRIPTION
,      L6_INSTANCE
,      L6_USER_ATTRIBUTE1
,      L6_USER_ATTRIBUTE2
,      L6_USER_ATTRIBUTE3
,      L6_USER_ATTRIBUTE4
,      L6_USER_ATTRIBUTE5
,      L7_TGTSGMT_PK
,      L7_TGTSGMT_DP
,      L7_NAME
,      L7_TGTSGMT_ID
,      L7_TGTSGMT_CODE
,      L7_MARKET_SEGMENT_FLAG
,      L7_ENABLED_FLAG
,      L7_ORIGINAL_SIZE
,      L7_TGTSGMT_NAME
,      L7_DESCRIPTION
,      L7_INSTANCE
,      L7_USER_ATTRIBUTE1
,      L7_USER_ATTRIBUTE2
,      L7_USER_ATTRIBUTE3
,      L7_USER_ATTRIBUTE4
,      L7_USER_ATTRIBUTE5
,      L8_TGTSGMT_PK
,      L8_TGTSGMT_DP
,      L8_NAME
,      L8_TGTSGMT_ID
,      L8_TGTSGMT_CODE
,      L8_MARKET_SEGMENT_FLAG
,      L8_ENABLED_FLAG
,      L8_ORIGINAL_SIZE
,      L8_TGTSGMT_NAME
,      L8_DESCRIPTION
,      L8_INSTANCE
,      L8_USER_ATTRIBUTE1
,      L8_USER_ATTRIBUTE2
,      L8_USER_ATTRIBUTE3
,      L8_USER_ATTRIBUTE4
,      L8_USER_ATTRIBUTE5
,      L9_TGTSGMT_PK
,      L9_TGTSGMT_DP
,      L9_NAME
,      L9_TGTSGMT_ID
,      L9_TGTSGMT_CODE
,      L9_MARKET_SEGMENT_FLAG
,      L9_ENABLED_FLAG
,      L9_ORIGINAL_SIZE
,      L9_TGTSGMT_NAME
,      L9_DESCRIPTION
,      L9_INSTANCE
,      L9_USER_ATTRIBUTE1
,      L9_USER_ATTRIBUTE2
,      L9_USER_ATTRIBUTE3
,      L9_USER_ATTRIBUTE4
,      L9_USER_ATTRIBUTE5
,      L9_LAST_UPDATE_DATE
,      L9_CREATION_DATE
,      SECURITY_GROUP_ID
,      LAST_UPDATE_DATE
,      CREATION_DATE
FROM BIM.EDW_BIM_TGSMT_M#;

Dependencies

[top of page]

BIM.EDW_BIM_TGSMT_M# references the following:

BIM: EDW_BIM_TGSMT_M

BIM.EDW_BIM_TGSMT_M# is referenced by following:

APPS: EDW_BIM_TGSMT_M