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

TABLE: MRP.MRP_FORM_QUERY

Object Details
Object Name: MRP_FORM_QUERY
Object Type: TABLE
Owner: MRP
FND Design Data: TableMRP.MRP_FORM_QUERY
Subobject Name:
Status: VALID


MRP_FORM_QUERY is a generic table used by forms for querying data
populated by PL/SQL stored procedures.
.
This table is used to display material and capacity horizontal plan
information in the Planner Workbench. QUERY_ID is the query
identifier used while populating the table. The DATE, CHAR, and
NUMBER columns contain generic data used in the PL/SQL procedure to
select data. For example, in the material horizontal plan:
.
=
Column Name Stored information Description
--------------------- --------------------------- -----------------
CHAR1 COMPILE_DESIGNATOR MPS, MRP or DRP plan identifier
NUMBER1 INVENTORY_ITEM_ID Inventory item identifier
NUMBER2 ORGANIZATION_ID Organization identifier
=
.


Storage Details
Tablespace: TablespaceAPPS_TS_NOLOGGING
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_FORM_QUERY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_NOLOGGING ColumnQUERY_ID
ColumnDATE1
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Yes Query identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
DATE1 DATE

Generic date column
DATE2 DATE

Generic date column
DATE3 DATE

Generic date column
DATE4 DATE

Generic date column
DATE5 DATE

Generic date column
DATE6 DATE

Generic date column
DATE7 DATE

Generic date column
DATE8 DATE

Generic date column
NUMBER1 NUMBER

Generic number column
NUMBER2 NUMBER

Generic number column
NUMBER3 NUMBER

Generic number column
NUMBER4 NUMBER

Generic number column
NUMBER5 NUMBER

Generic number column
NUMBER6 NUMBER

Generic number column
NUMBER7 NUMBER

Generic number column
NUMBER8 NUMBER

Generic number column
NUMBER9 NUMBER

Generic number column
NUMBER10 NUMBER

Generic number column
NUMBER11 NUMBER

Generic number column
NUMBER12 NUMBER

Generic number column
NUMBER13 NUMBER

Generic number column
NUMBER14 NUMBER

Generic number column
NUMBER15 NUMBER

Generic number column
REQUEST_ID NUMBER

Concurrent Who column
CHAR1 VARCHAR2 (80)
Generic character column
CHAR2 VARCHAR2 (80)
Generic character column
CHAR3 VARCHAR2 (80)
Generic character column
CHAR4 VARCHAR2 (80)
Generic character column
CHAR5 VARCHAR2 (80)
Generic character column
CHAR6 VARCHAR2 (80)
Generic character column
CHAR7 VARCHAR2 (80)
Generic character column
CHAR8 VARCHAR2 (80)
Generic character column
CHAR9 VARCHAR2 (250)
Generic character column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
Query Text

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


SELECT QUERY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      DATE5
,      DATE6
,      DATE7
,      DATE8
,      NUMBER1
,      NUMBER2
,      NUMBER3
,      NUMBER4
,      NUMBER5
,      NUMBER6
,      NUMBER7
,      NUMBER8
,      NUMBER9
,      NUMBER10
,      NUMBER11
,      NUMBER12
,      NUMBER13
,      NUMBER14
,      NUMBER15
,      REQUEST_ID
,      CHAR1
,      CHAR2
,      CHAR3
,      CHAR4
,      CHAR5
,      CHAR6
,      CHAR7
,      CHAR8
,      CHAR9
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
FROM MRP.MRP_FORM_QUERY;

Dependencies

[top of page]

MRP.MRP_FORM_QUERY does not reference any database object

MRP.MRP_FORM_QUERY is referenced by following:

SchemaMRP
ViewMRP_FORM_QUERY#