eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: GMP.MR_SIZE_TBL

Object Details

Object Name:	MR_SIZE_TBL
Object Type:	TABLE
Owner:	GMP
FND Design Data:	GMP.MR_SIZE_TBL
Subobject Name:
Status:	VALID

Sizing table. Stores info about the maximum number of rows required by mrp to run for a schedule. Use for allocating memory to subsequent MRP runs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MR_SIZE_TBL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SCHEDULE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SCHEDULE_ID	NUMBER	(10)	Yes	Surrogate key identifying the schedule.
MAX_FM_FORM_EFF	NUMBER	(10)	Yes	Maximum number of formula effectivity rows selected.
MAX_FM_MATL_DTL	NUMBER	(10)	Yes	Maximum number of formula material records selected.
MAX_FORMULA	NUMBER	(10)	Yes	Maximum number of formula rows selected.
MAX_IC_PLNT_INV	NUMBER	(10)	Yes	Maximum number of production rules rows selected.
MAX_IC_SUMM_INV	NUMBER	(10)	Yes	Maximum number of ic_summ_inv rows selected.
MAX_IC_TRAN_PND	NUMBER	(10)	Yes	Maximum number of pending transaction rows selected.
MAX_IC_WHSE_INV	NUMBER	(10)	Yes	Maximum number of warehouse rules rows selected.
MAX_IC_WHSE_REL	NUMBER	(10)	Yes	Maximum number of transfer rule rows selected.
MAX_ITEM	NUMBER	(10)	Yes	Maximum number of item rows selected from ic_item_mst.
MAX_MR_SHCL_DTL	NUMBER	(10)	Yes	Maximum number of shop calendar detail rows selected.
MAX_MR_SHDY_DTL	NUMBER	(10)	Yes	Maximum number of shop day detail rows selected.
MAX_PS_SCHD_DTL	NUMBER	(10)	Yes	Maximum number of schedule detail rows selected.
MAX_PS_WHSE_EFF	NUMBER	(10)	Yes	Maximum number of warehouse effectivity rows selected.
RESIZE_PERCENT	NUMBER	(10)	Yes	Percentage by which memory is resized when a call to central memory resize function is made in code- during MRP Run.
MAX_PO_BPOS_DTL	NUMBER	(10)	Yes	Maximum number of blanket purchase order detail rows selected.
MAX_PO_BPOS_HDR	NUMBER	(10)	Yes	Maximum number of blanket purchase order header rows selected.
MAX_PO_ORDR_DTL	NUMBER	(10)	Yes	Maximum number of purchase order detail rows selected.
MAX_PO_RELS_SCH	NUMBER	(10)	Yes	Maximum number of BPO release schedule rows selected.
MAX_PS_SCHD_FOR	NUMBER	(10)	Yes	Maximum number of schedule/forecast association rows selected.
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
REQUEST_ID	NUMBER	(15)		Concurrent who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column

Query Text

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


SELECT SCHEDULE_ID
,      MAX_FM_FORM_EFF
,      MAX_FM_MATL_DTL
,      MAX_FORMULA
,      MAX_IC_PLNT_INV
,      MAX_IC_SUMM_INV
,      MAX_IC_TRAN_PND
,      MAX_IC_WHSE_INV
,      MAX_IC_WHSE_REL
,      MAX_ITEM
,      MAX_MR_SHCL_DTL
,      MAX_MR_SHDY_DTL
,      MAX_PS_SCHD_DTL
,      MAX_PS_WHSE_EFF
,      RESIZE_PERCENT
,      MAX_PO_BPOS_DTL
,      MAX_PO_BPOS_HDR
,      MAX_PO_ORDR_DTL
,      MAX_PO_RELS_SCH
,      MAX_PS_SCHD_FOR
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM GMP.MR_SIZE_TBL;

Dependencies

[top of page]

GMP.MR_SIZE_TBL does not reference any database object

GMP.MR_SIZE_TBL is referenced by following:

GMP: MR_SIZE_TBL#