Use this query to run report to list planograms even Planograms have not been implemented the first time.
SELECT fp.dbkey "Floorplan DBKEY", fp.name "Floorplan Name",
fp.status1 "Floorplan Status", s.name "Store name",
s.storenumber,decode(i.implemented,1,'Yes','No') Implemented,
dbms_lob.substr(i.statuslog,dbms_lob.getlength(i.statuslog),1) "Implementation Comments",
p.name "Planogram Name", decode(p.dbstatus,1,'Live','Other') "Planogram Status",
p.dbdateeffectivefrom "Planogram Date Live",
p.dbdateeffectiveto "Planogram Date To", p.date1 "Planogram Set By Date",
k.description "DBKey 1", k2.description "DbKey 2"
FROM ix_spc_planogram_store p, ix_spc_planogram_key k, ix_spc_planogram_key k2,
ix_str_store_floorplan f, ix_flr_floorplan fp, ix_str_store s, ix_net_str_pln_imp i, ix_net_document d
WHERE p.dbparentfloorplankey = f.dbparentfloorplankey
AND p.dbstatus = 1
AND p.dbkey1 = k.dbkey
AND k.keylevel = 1
AND p.dbkey2 = k2.dbkey
AND k2.keylevel = 2
AND k2.dbparentkey = p.dbkey1
AND f.dbparentstorekey is not null
AND f.dbparentstorekey = s.dbkey
AND f.dbparentfloorplankey = fp.dbkey
AND p.dbkey = d.dbparentplanogramkey
AND p.dbkey = i.dbparentplanogramkey(+)
AND p.dbparentstorekey = i.dbparentstorekey(+)
|
