MATERIALIZED VIEW: APPS.DDR_R_ORG_BU_DN_MV

Source

SELECT "A2".ROWID "BU_DN_ROWID","A1".ROWID "MKT_AREA_ROWID","A2"."MFG_ORG_CD" "MFG_ORG_CD","A2"."ORG_CD" "ORG_CD","A2"."ORG_TYP" "ORG_TYP","A2"."ORG_NAME" "ORG_NAME","A2"."ORG_BSNS_UNIT_ID" "ORG_BSNS_UNIT_ID","A2"."BSNS_UNIT_CD" "BSNS_UNIT_CD","A2"."BSNS_UNIT_NAME" "BSNS_UNIT_NAME","A2"."BSNS_UNIT_TYP" "BSNS_UNIT_TYP","A2"."CHNL_TYP_CD" "CHNL_TYP_CD","A2"."CHNL_TYP_DESC" "CHNL_TYP_DESC","A2"."STORE_MGR" "STORE_MGR","A2"."STORE_OPEN_DT" "STORE_OPEN_DT","A2"."STORE_CLOSE_DT" "STORE_CLOSE_DT","A2"."STORE_TYP" "STORE_TYP","A2"."NEW_STORE_IND" "NEW_STORE_IND","A2"."GLBL_LOC_ID" "GLBL_LOC_ID","A2"."GLBL_LOC_ID_TYP" "GLBL_LOC_ID_TYP","A2"."BSNS_UNIT_CNCPT" "BSNS_UNIT_CNCPT","A2"."MKT_AREA_ID_1" "MKT_AREA_ID","A2"."MKT_AREA_CD_1" "MKT_AREA_CD","A2"."MKT_AREA_TYP_1" "MKT_AREA_TYP","A1"."MKT_AREA_NAME" "MKT_AREA_NAME","A1"."MKT_AREA_DESC" "MKT_AREA_DESC","A2"."ORG_DSTRCT_ID" "ORG_DSTRCT_ID","A2"."DSTRCT_CD" "DSTRCT_CD","A2"."DSTRCT_NAME" "DSTRCT_NAME","A2"."DSTRCT_MGR_NAME" "DSTRCT_MGR_NAME","A2"."ORG_RGN_ID" "ORG_RGN_ID","A2"."RGN_CD" "RGN_CD","A2"."RGN_NAME" "RGN_NAME","A2"."RGN_MGR_NAME" "RGN_MGR_NAME","A2"."ORG_AREA_ID" "ORG_AREA_ID","A2"."AREA_CD" "AREA_CD","A2"."AREA_NAME" "AREA_NAME","A2"."AREA_MGR_NAME" "AREA_MGR_NAME","A2"."ORG_CHAIN_ID" "ORG_CHAIN_ID","A2"."CHAIN_CD" "CHAIN_CD","A2"."CHAIN_NAME" "CHAIN_NAME","A2"."CHAIN_MGR_NAME" "CHAIN_MGR_NAME","A2"."GEO_SUB_RGN_ID" "GEO_SUB_RGN_ID","A2"."STORE_VOL" "STORE_VOL",DECODE("A2"."BSNS_UNIT_TYP",'RTLSTORE',1,0) "NO_OF_RTL_STORES" FROM "APPS"."DDR_R_ORG_BU_CHNLTYP_DN_MV" "A2","DDR"."DDR_R_MKT_AREA" "A1" WHERE "A2"."MFG_ORG_CD"="A1"."MFG_ORG_CD"(+) AND "A2"."MKT_AREA_ID_1"="A1"."MKT_AREA_ID"(+)