774: csi.hierarchy_node_id,
775: csi.secondary_inventory_name,
776: cpp.planning_parameters_id,
777: cpp.level_id,
778: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,
779: null,
780: greatest(greatest(nvl(mtrl.quantity_detailed,0),nvl(mtrl.quantity,0))-nvl(mtrl.quantity_delivered,0),0),
781: mtrl.uom_code,
782: msib.primary_uom_code,
815: mtrl.inventory_item_id,
816: cpp.organization_id,
817: cpp.planning_parameters_id,
818: cpp.level_id,
819: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,
820: null,
821: greatest(greatest(nvl(mtrl.quantity_detailed,0),nvl(mtrl.quantity,0))-nvl(mtrl.quantity_delivered,0),0),
822: mtrl.uom_code,
823: msib.primary_uom_code,
857: csi.hierarchy_node_id,
858: csi.secondary_inventory_name,
859: cpp.planning_parameters_id,
860: cpp.level_id,
861: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,
862: null,
863: greatest(greatest(nvl(mtrl.quantity_detailed,0),nvl(mtrl.quantity,0))-nvl(mtrl.quantity_delivered,0),0),
864: mtrl.uom_code,
865: msib.primary_uom_code,
900: cpp.organization_id,
901: cpp.secondary_inventory,
902: cpp.planning_parameters_id,
903: cpp.level_id,
904: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,
905: null,
906: greatest(greatest(nvl(mtrl.quantity_detailed,0),nvl(mtrl.quantity,0))-nvl(mtrl.quantity_delivered,0),0),
907: mtrl.uom_code,
908: msib.primary_uom_code,
937: mtrl.inventory_item_id,
938: cpp.organization_id,
939: cpp.planning_parameters_id,
940: cpp.level_id,
941: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,
942: null,
943: nvl(mtrl.quantity,0)-nvl(mtrl.quantity_delivered,0),
944: mtrl.uom_code,
945: msib.primary_uom_code,
944: mtrl.uom_code,
945: msib.primary_uom_code,
946: null,
947: null)),
948: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,
949: null,
950: nvl(mtrl.quantity,0)-nvl(mtrl.quantity_delivered,0),
951: mtrl.uom_code,
952: msib.primary_uom_code,
980: mtrl.inventory_item_id,
981: cpp.organization_id,
982: cpp.planning_parameters_id,
983: cpp.level_id,
984: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,
985: null,
986: nvl(mtrl.quantity,0)-nvl(mtrl.quantity_delivered,0),
987: mtrl.uom_code,
988: msib.primary_uom_code,
987: mtrl.uom_code,
988: msib.primary_uom_code,
989: null,
990: null)),
991: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,
992: null,
993: nvl(mtrl.quantity,0)-nvl(mtrl.quantity_delivered,0),
994: mtrl.uom_code,
995: msib.primary_uom_code,