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_WHSE_EFF

Object Details

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

Plant-warehouse relationship (effectivity) table. Specifies the warehouses items are consumed from and replenished by plants. Used MRP, and by Production for determining default warehouse for
transactions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PS_WHSE_EFF_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PSWHSE_EFF_ID
PS_WHSE_EFF_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PLANT_CODE WHSE_CODE WHSE_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PSWHSE_EFF_ID	NUMBER	(15)	Yes	Surrogate id for the effectivity
PLANT_CODE	VARCHAR2	(4)	Yes	Plant for which consumption and replenishment warehouses are defined.
WHSE_CODE	VARCHAR2	(4)	Yes	Warehouse associated with the plant.
WHSE_ITEM_ID	NUMBER	(10)		Surrogate key for a warehouse item. Warehouse items are used to group together items having similar consumption-replenishment characteristics
CONSUM_IND	NUMBER	(5)	Yes	Consumption indicator. 0=Item is not consumed from this warehouse,
REPLEN_IND	NUMBER	(5)	Yes	Replenishment indicator. 0=Item is not replenished into this warehouse; 1= Item can be replenished into this warehouse
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
TRANS_CNT	NUMBER	(10)		Not currently used
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column

Query Text

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


SELECT PSWHSE_EFF_ID
,      PLANT_CODE
,      WHSE_CODE
,      WHSE_ITEM_ID
,      CONSUM_IND
,      REPLEN_IND
,      TEXT_CODE
,      TRANS_CNT
,      DELETE_MARK
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM GMP.PS_WHSE_EFF;

Dependencies

[top of page]

GMP.PS_WHSE_EFF does not reference any database object

GMP.PS_WHSE_EFF is referenced by following:

APPS: PS_WHSE_EFF