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

VIEW: MRP.MRP_AD_OPR_NETWORKS#

Object Details
Object Name: MRP_AD_OPR_NETWORKS#
Object Type: VIEW
Owner: MRP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
FROM_OP_SEQ_ID NUMBER

ORIGINAL_SYSTEM_REFERENCE NUMBER

TO_OP_SEQ_ID NUMBER

TRANSITION_TYPE NUMBER

RN NUMBER

PLANNING_PCT NUMBER

CUMMULATIVE_PCT NUMBER

EFFECTIVITY_DATE DATE

DISABLE_DATE DATE

CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
ORGANIZATION_ID NUMBER

Query Text

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


SELECT FROM_OP_SEQ_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      TO_OP_SEQ_ID
,      TRANSITION_TYPE
,      RN
,      PLANNING_PCT
,      CUMMULATIVE_PCT
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
FROM MRP.MRP_AD_OPR_NETWORKS#;

Dependencies

[top of page]

MRP.MRP_AD_OPR_NETWORKS# references the following:

SchemaMRP
TableMRP_AD_OPR_NETWORKS
MRP.MRP_AD_OPR_NETWORKS# is referenced by following:

SchemaAPPS
SynonymMRP_AD_OPR_NETWORKS