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]

VIEW: APPS.PMITS_WAREHOUSE_MASTER_V

Object Details

Object Name:	PMITS_WAREHOUSE_MASTER_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PMI.PMITS_WAREHOUSE_MASTER_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

PMI Warehouse Master view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
WHSE_CODE	VARCHAR2	(4)	Yes	Code for the warehouse.
WHSE_NAME	VARCHAR2	(40)	Yes	Name of the warehouse.
ORGN_CODE	VARCHAR2	(4)	Yes	Organization that owns the warehouse.
LOCT_CTL	NUMBER	(5)	Yes	Location control indicator. 0=Warehouse is not location controlled,1=Validated location control, 2=Non-validated location control.
LOCT_CTL_DISP	VARCHAR2	(80)	Yes	Location control indicator code resolved using lookup
ADDR_ID	NUMBER	(10)		Surrogate key to the address of the warehouse.
CONSIGN_IND	NUMBER	(5)	Yes	Consignment indicator. 0=Not a consigment warehouse, 1=Consignment warehouse.
CONSIGN_IND_DISP	VARCHAR2	(80)	Yes	Consignment indicator code resolved using lookup.
REGION_CODE	VARCHAR2	(8)		Region code
WHSE_CLASS	VARCHAR2	(8)		Warehouse class.
WHSE_CONTACT	VARCHAR2	(40)		Contact person at the warehouse.
WHSE_PHONE	VARCHAR2	(20)		Phone number
TAXLOC_CODE	VARCHAR2	(10)		Tax location of warehouse.
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
INGREDIENT_STAGE	VARCHAR2	(16)		Staging location for ingredients
PRODUCT_STAGE	VARCHAR2	(16)		Staging location for products
RECV_STAGE	VARCHAR2	(16)		Staging location for receiving. Acts as default location for receiving allocations
SHIP_STAGE	VARCHAR2	(16)		Staging location for shipping. Acts as default location for shipment allocations
MTL_ORGANIZATION_ID	NUMBER			MTL Parameters Table Organization ID
MTL_ORGANIZATION_CODE	VARCHAR2	(3)		MTL Parameters Table Organization Code

Query Text

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


SELECT WHSE_CODE
,      WHSE_NAME
,      ORGN_CODE
,      LOCT_CTL
,      LOCT_CTL_DISP
,      ADDR_ID
,      CONSIGN_IND
,      CONSIGN_IND_DISP
,      REGION_CODE
,      WHSE_CLASS
,      WHSE_CONTACT
,      WHSE_PHONE
,      TAXLOC_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      DELETE_MARK
,      TEXT_CODE
,      LAST_UPDATE_LOGIN
,      INGREDIENT_STAGE
,      PRODUCT_STAGE
,      RECV_STAGE
,      SHIP_STAGE
,      MTL_ORGANIZATION_ID
,      MTL_ORGANIZATION_CODE
FROM APPS.PMITS_WAREHOUSE_MASTER_V;

Dependencies

[top of page]

APPS.PMITS_WAREHOUSE_MASTER_V references the following:

APPS: GEM_LOOKUPS; IC_WHSE_MST; MTL_PARAMETERS; PMI_SECURITY_PKG - show dependent code

APPS.PMITS_WAREHOUSE_MASTER_V is not referenced by any database object