Product: | GMI - Process Manufacturing Inventory |
---|---|
Description: | View for pre migration UI mapping of warehouse |
Implementation/DBA Data: | APPS.IC_WHSE_MST_VW |
SELECT W.WHSE_CODE
, W.WHSE_NAME
, W.ORGN_CODE
, W.LOCT_CTL
, W.ADDR_ID
, W.CONSIGN_IND
, W.REGION_CODE
, W.WHSE_CLASS
, W.WHSE_CONTACT
, W.WHSE_PHONE
, W.TAXLOC_CODE
, W.LAST_UPDATE_DATE
, W.LAST_UPDATED_BY
, W.CREATION_DATE
, W.CREATED_BY
, W.DELETE_MARK
, W.TEXT_CODE
, W.LAST_UPDATE_LOGIN
, W.INGREDIENT_STAGE
, W.PRODUCT_STAGE
, W.RECV_STAGE
, W.SHIP_STAGE
, W.MTL_ORGANIZATION_ID
, W.SUBINVENTORY_IND_FLAG
, W.DISABLE_WAREHOUSE_IND
, W.MIGRATED_IND
, C.COST_WHSE_CODE
, S.ORGANIZATION_ID
FROM IC_WHSE_MST W
, CM_WHSE_ASC C
, SY_ORGN_MST S
WHERE C.WHSE_CODE (+) = W.WHSE_CODE
AND S.ORGN_CODE = W.ORGN_CODE