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

VIEW: MTH.MTH_PROD_SUB_SEGMENTS_F#

Object Details
Object Name: MTH_PROD_SUB_SEGMENTS_F#
Object Type: VIEW
Owner: MTH
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SUB_SEGMENT_PK_KEY NUMBER
Yes
SEGMENT_FK_KEY NUMBER
Yes
SUB_SEGMENT_PK VARCHAR2 (120) Yes
SYSTEM_FK_KEY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
CREATION_SYSTEM_ID NUMBER
Yes
LAST_UPDATE_SYSTEM_ID NUMBER
Yes
DESCRIPTION VARCHAR2 (240)
ACTUAL_START_DATE DATE

ACTUAL_COMPLETION_DATE DATE

PLANNED_START_DATE DATE

PLANNED_COMPLETION_DATE DATE

USER_ATTR1 VARCHAR2 (150)
USER_ATTR2 VARCHAR2 (150)
USER_ATTR3 VARCHAR2 (150)
USER_ATTR4 VARCHAR2 (150)
USER_ATTR5 VARCHAR2 (150)
USER_MEASURE1 NUMBER

USER_MEASURE2 NUMBER

USER_MEASURE3 NUMBER

USER_MEASURE4 NUMBER

USER_MEASURE5 NUMBER

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATED_BY NUMBER (15)
Query Text

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


SELECT SUB_SEGMENT_PK_KEY
,      SEGMENT_FK_KEY
,      SUB_SEGMENT_PK
,      SYSTEM_FK_KEY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATION_SYSTEM_ID
,      LAST_UPDATE_SYSTEM_ID
,      DESCRIPTION
,      ACTUAL_START_DATE
,      ACTUAL_COMPLETION_DATE
,      PLANNED_START_DATE
,      PLANNED_COMPLETION_DATE
,      USER_ATTR1
,      USER_ATTR2
,      USER_ATTR3
,      USER_ATTR4
,      USER_ATTR5
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
FROM MTH.MTH_PROD_SUB_SEGMENTS_F#;

Dependencies

[top of page]

MTH.MTH_PROD_SUB_SEGMENTS_F# references the following:

SchemaMTH
TableMTH_PROD_SUB_SEGMENTS_F
MTH.MTH_PROD_SUB_SEGMENTS_F# is referenced by following:

SchemaAPPS
SynonymMTH_PROD_SUB_SEGMENTS_F