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.PS_MATL_HDR

Object Details

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

Temporary data about the report

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PS_MATL_HDR_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	MATL_REP_ID ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MATL_REP_ID	NUMBER	(10)	Yes	Surrogate id of the report
PLANNING_CLASS	VARCHAR2	(8)		Planning class of the item
ITEM_ID	NUMBER	(10)		Surrogate id of the item
PLANNING_CATEGORY_ID	NUMBER			Category Id for PLANNING_CLASS
INVENTORY_ITEM_ID	NUMBER			Inventory Item ID
ORGANIZATION_ID	NUMBER			Organization ID
CATEGORY_ID	NUMBER			Category ID

Query Text

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


SELECT MATL_REP_ID
,      PLANNING_CLASS
,      ITEM_ID
,      PLANNING_CATEGORY_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      CATEGORY_ID
FROM GMP.PS_MATL_HDR;

Dependencies

[top of page]

GMP.PS_MATL_HDR does not reference any database object

GMP.PS_MATL_HDR is referenced by following:

GMP: PS_MATL_HDR#