View: PMITS_WAREHOUSE_MASTER_V

Product:	PMI - Process Manufacturing Intelligence
Description:	PMI Warehouse Master view
Implementation/DBA Data:	APPS.PMITS_WAREHOUSE_MASTER_V

View Text

SELECT WHSE.WHSE_CODE
, WHSE.WHSE_NAME
, WHSE.ORGN_CODE
, WHSE.LOCT_CTL
, LOCT_CTL_LKUP.MEANING
, WHSE.ADDR_ID
, WHSE.CONSIGN_IND
, CONSIGN_IND_LKUP.MEANING
, WHSE.REGION_CODE
, WHSE.WHSE_CLASS
, WHSE.WHSE_CONTACT
, WHSE.WHSE_PHONE
, WHSE.TAXLOC_CODE
, WHSE.LAST_UPDATE_DATE
, WHSE.LAST_UPDATED_BY
, WHSE.CREATION_DATE
, WHSE.CREATED_BY
, WHSE.DELETE_MARK
, WHSE.TEXT_CODE
, WHSE.LAST_UPDATE_LOGIN
, WHSE.INGREDIENT_STAGE
, WHSE.PRODUCT_STAGE
, WHSE.RECV_STAGE
, WHSE.SHIP_STAGE
, WHSE.MTL_ORGANIZATION_ID
, MTL_PARAM.ORGANIZATION_CODE
FROM IC_WHSE_MST WHSE
, MTL_PARAMETERS MTL_PARAM
, GEM_LOOKUPS LOCT_CTL_LKUP
, GEM_LOOKUPS CONSIGN_IND_LKUP
WHERE WHSE.MTL_ORGANIZATION_ID = MTL_PARAM.ORGANIZATION_ID
AND LOCT_CTL_LKUP.LOOKUP_TYPE = 'LOCATION_CONTROL'
AND LOCT_CTL_LKUP.LOOKUP_CODE = WHSE.LOCT_CTL
AND CONSIGN_IND_LKUP.LOOKUP_TYPE = 'CONSIGNMENT'
AND CONSIGN_IND_LKUP.LOOKUP_CODE = WHSE.CONSIGN_IND
AND 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(WHSE.ORGN_CODE)

Columns