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


VIEW: MRP.MRP_SELECTION_CRITERIA#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
SEQUENCE NUMBER
Yes
FOLDER_ID NUMBER
Yes
FIELD_NAME VARCHAR2 (30) Yes
FIELD_TYPE VARCHAR2 (10) Yes
HIDDEN_FROM_FIELD VARCHAR2 (250)
CONDITION NUMBER

FROM_FIELD VARCHAR2 (250)
TO_FIELD VARCHAR2 (250)
FOLDER_OBJECT VARCHAR2 (30) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

AND_OR NUMBER

COUNT_BY NUMBER

Query Text

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


SELECT SEQUENCE
,      FOLDER_ID
,      FIELD_NAME
,      FIELD_TYPE
,      HIDDEN_FROM_FIELD
,      CONDITION
,      FROM_FIELD
,      TO_FIELD
,      FOLDER_OBJECT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      AND_OR
,      COUNT_BY
FROM MRP.MRP_SELECTION_CRITERIA#;

Dependencies

[top of page]

MRP.MRP_SELECTION_CRITERIA# references the following:

SchemaMRP
TableMRP_SELECTION_CRITERIA
MRP.MRP_SELECTION_CRITERIA# is referenced by following:

SchemaAPPS
SynonymMRP_SELECTION_CRITERIA