VIEW: APPS.IC_WHSE_MST_VW

Source

View Text - Preformatted

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 , NVL(c.COST_WHSE_CODE, w.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 and c.eff_start_date (+) <= sysdate and c.eff_end_date (+) >= sysdate and c.delete_mark (+) = 0

View Text - HTML Formatted

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
, NVL(C.COST_WHSE_CODE
, W.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
AND C.EFF_START_DATE (+) <= SYSDATE
AND C.EFF_END_DATE (+) >= SYSDATE
AND C.DELETE_MARK (+) = 0