select v.item_no, max(v.opm_kg), max(v.odm_kg)
\nfrom
\n(
\nselect m.ITEM_NO, mic.SEGMENT1 opm_kg, ” odm_kg
\n\t\u00a0 from apps.gmi_item_categories_v1 gic,
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 apps.mtl_categories_vl\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 mic,
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 apps.ic_item_mst\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 m
\n\t\u00a0where mic.STRUCTURE_ID = gic.STRUCTURE_ID
\n\t\u00a0\t\u00a0 and mic.CATEGORY_ID = gic.CATEGORY_ID
\n\t\u00a0\t\u00a0 and m.ITEM_ID = gic.ITEM_ID
\n\t\u00a0\t\u00a0 and upper(gic.CATEGORY_SET_NAME) = 'KLASA KG POZYCJI’
\nunion all<\/p>\n
select msi.segment1, ”opm_kg, t.CATEGORY_CONCAT_SEGS odm_kg
\n\t\u00a0 from apps.mtl_item_categories_v t, mtl_system_items_b msi
\n\t\u00a0where msi.inventory_item_id = t.INVENTORY_ITEM_ID
\n\t\u00a0\t\u00a0 and msi.organization_id = t.ORGANIZATION_ID
\n\t\u00a0\t\u00a0 and msi.organization_id = 115
\n\t\u00a0\t\u00a0 and t.CATEGORY_SET_NAME=’Klasa KG pozycji’
\n) v
\nwhere nvl(v.opm_kg,’BRAK’)|| (nvl(v.odm_kg,’BRAK’))<>'BRAKBRAK'\ngroup by v.item_no\n<\/p>\n","protected":false},"excerpt":{"rendered":"
select v.item_no, max(v.opm_kg), max(v.odm_kg) from ( select m.ITEM_NO, mic.SEGMENT1 opm_kg, ” odm_kg \u00a0 from apps.gmi_item_categories_v1 gic, \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 apps.mtl_categories_vl \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 mic, \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 apps.ic_item_mst \u00a0 \u00a0 \u00a0 \u00a0 … Czytaj dalej