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: ViewPMI.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:

SchemaAPPS
ViewGEM_LOOKUPS
SynonymIC_WHSE_MST
SynonymMTL_PARAMETERS
PL/SQL PackagePMI_SECURITY_PKG - show dependent code

APPS.PMITS_WAREHOUSE_MASTER_V is not referenced by any database object