[Home] [Help] [Dependency Information]
Object Name: | MRP_CRITERIA |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.MRP_CRITERIA |
Subobject Name: | |
Status: | VALID |
MRP_CRITERIA stores the criteria that can be selected by the user in
the Find Blocks for Planner Workbench form. This table includes a
row for every seeded criteria for the Items window and Supply/Demand
window.
FOLDER_OBJECT identifies the window for which the criteria is
available. FIELD_NAME and FIELD_TYPE identify the field for which the
criteria is seeded. FIELD_PROMPT is the prompt for the field that is
displayed in the form.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_CRITERIA_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
FOLDER_OBJECT
FIELD_NAME ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FOLDER_OBJECT | VARCHAR2 | (30) | Yes | Unique folder object identifier |
FIELD_NAME | VARCHAR2 | (30) | Yes | Field name |
FIELD_TYPE | VARCHAR2 | (10) | Yes | Field type |
LOV_NAME | VARCHAR2 | (30) | List of Value name | |
SQL_STATEMENT | VARCHAR2 | (2000) | SQL Statement for creating the list of values | |
FIELD_PROMPT | VARCHAR2 | (80) | Yes | Field prompt |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
APP_SHORT_NAME | VARCHAR2 | (30) | Flexfield owning application | |
FLEX_NUM | VARCHAR2 | (30) | Flexfield identifier | |
DATA_SET | VARCHAR2 | (80) | Flexfield data set | |
FLEX_CODE | VARCHAR2 | (30) | Flexfield code | |
LOV_TYPE | NUMBER | (10) | Type of LOV | |
LONG_LIST | VARCHAR2 | (2) | Long list indicator for flexfields | |
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;
MRP.MRP_CRITERIA does not reference any database object
MRP.MRP_CRITERIA is referenced by following:
|
|
|