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

VIEW: DDR.DDR_B_GOAL_TARGET#

Object Details
Object Name: DDR_B_GOAL_TARGET#
Object Type: VIEW
Owner: DDR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
MFG_ORG_CD VARCHAR2 (30) Yes
ORG_HCHY_CD VARCHAR2 (30) Yes
ORG_HCHY_LVL VARCHAR2 (30) Yes
MFG_ITEM_HCHY_CD VARCHAR2 (30) Yes
MFG_ITEM_HCHY_LVL VARCHAR2 (30) Yes
TIME_HCHY_CD VARCHAR2 (30) Yes
TIME_HCHY_LVL VARCHAR2 (30) Yes
RTL_ITEM_HCHY_CD VARCHAR2 (30) Yes
RTL_ITEM_HCHY_LVL VARCHAR2 (30) Yes
MEASURE_NAME VARCHAR2 (50) Yes
MEASURE_NAME_TYPE VARCHAR2 (30) Yes
MEASURE_VALUE NUMBER

MEASURE_VALUE_TYPE_FLAG VARCHAR2 (1)
SRC_SYS_IDNT VARCHAR2 (40) Yes
SRC_SYS_DT DATE
Yes
CRTD_BY_DSR VARCHAR2 (30) Yes
LAST_UPDT_BY_DSR VARCHAR2 (30) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
ORG_CD VARCHAR2 (30)
CLNDR_TYP VARCHAR2 (30)
Query Text

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


SELECT MFG_ORG_CD
,      ORG_HCHY_CD
,      ORG_HCHY_LVL
,      MFG_ITEM_HCHY_CD
,      MFG_ITEM_HCHY_LVL
,      TIME_HCHY_CD
,      TIME_HCHY_LVL
,      RTL_ITEM_HCHY_CD
,      RTL_ITEM_HCHY_LVL
,      MEASURE_NAME
,      MEASURE_NAME_TYPE
,      MEASURE_VALUE
,      MEASURE_VALUE_TYPE_FLAG
,      SRC_SYS_IDNT
,      SRC_SYS_DT
,      CRTD_BY_DSR
,      LAST_UPDT_BY_DSR
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_CD
,      CLNDR_TYP
FROM DDR.DDR_B_GOAL_TARGET#;

Dependencies

[top of page]

DDR.DDR_B_GOAL_TARGET# references the following:

SchemaDDR
TableDDR_B_GOAL_TARGET
DDR.DDR_B_GOAL_TARGET# is referenced by following:

SchemaAPPS
SynonymDDR_B_GOAL_TARGET