[Home] [Help] [Dependency Information]
Object Name: | MRP_CRITERIA# |
---|---|
Object Type: | VIEW |
Owner: | MRP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FOLDER_OBJECT | VARCHAR2 | (30) | Yes | |
FIELD_NAME | VARCHAR2 | (30) | Yes | |
FIELD_TYPE | VARCHAR2 | (10) | Yes | |
LOV_NAME | VARCHAR2 | (30) | ||
SQL_STATEMENT | VARCHAR2 | (2000) | ||
FIELD_PROMPT | VARCHAR2 | (80) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
APP_SHORT_NAME | VARCHAR2 | (30) | ||
FLEX_NUM | VARCHAR2 | (30) | ||
DATA_SET | VARCHAR2 | (80) | ||
FLEX_CODE | VARCHAR2 | (30) | ||
LOV_TYPE | NUMBER | (10) | ||
LONG_LIST | VARCHAR2 | (2) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT FOLDER_OBJECT
, FIELD_NAME
, FIELD_TYPE
, LOV_NAME
, SQL_STATEMENT
, FIELD_PROMPT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, APP_SHORT_NAME
, FLEX_NUM
, DATA_SET
, FLEX_CODE
, LOV_TYPE
, LONG_LIST
, ZD_EDITION_NAME
FROM MRP.MRP_CRITERIA#;
|
|
|