DBA Data[Home] [Help]

APPS.CSP_SUPPLY_DEMAND_PVT dependencies on INV_CONVERT

Line 777: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,

773: csi.hierarchy_node_id,
774: csi.secondary_inventory_name,
775: cpp.planning_parameters_id,
776: cpp.level_id,
777: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,
778: null,
779: greatest(greatest(nvl(mtrl.quantity_detailed,0),nvl(mtrl.quantity,0))-nvl(mtrl.quantity_delivered,0),0),
780: mtrl.uom_code,
781: msib.primary_uom_code,

Line 818: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,

814: mtrl.inventory_item_id,
815: cpp.organization_id,
816: cpp.planning_parameters_id,
817: cpp.level_id,
818: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,
819: null,
820: greatest(greatest(nvl(mtrl.quantity_detailed,0),nvl(mtrl.quantity,0))-nvl(mtrl.quantity_delivered,0),0),
821: mtrl.uom_code,
822: msib.primary_uom_code,

Line 860: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,

856: csi.hierarchy_node_id,
857: csi.secondary_inventory_name,
858: cpp.planning_parameters_id,
859: cpp.level_id,
860: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,
861: null,
862: greatest(greatest(nvl(mtrl.quantity_detailed,0),nvl(mtrl.quantity,0))-nvl(mtrl.quantity_delivered,0),0),
863: mtrl.uom_code,
864: msib.primary_uom_code,

Line 903: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,

899: cpp.organization_id,
900: cpp.secondary_inventory,
901: cpp.planning_parameters_id,
902: cpp.level_id,
903: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,
904: null,
905: greatest(greatest(nvl(mtrl.quantity_detailed,0),nvl(mtrl.quantity,0))-nvl(mtrl.quantity_delivered,0),0),
906: mtrl.uom_code,
907: msib.primary_uom_code,

Line 940: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,

936: mtrl.inventory_item_id,
937: cpp.organization_id,
938: cpp.planning_parameters_id,
939: cpp.level_id,
940: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,
941: null,
942: nvl(mtrl.quantity,0)-nvl(mtrl.quantity_delivered,0),
943: mtrl.uom_code,
944: msib.primary_uom_code,

Line 947: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,

943: mtrl.uom_code,
944: msib.primary_uom_code,
945: null,
946: null)),
947: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,
948: null,
949: nvl(mtrl.quantity,0)-nvl(mtrl.quantity_delivered,0),
950: mtrl.uom_code,
951: msib.primary_uom_code,

Line 983: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,

979: mtrl.inventory_item_id,
980: cpp.organization_id,
981: cpp.planning_parameters_id,
982: cpp.level_id,
983: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,
984: null,
985: nvl(mtrl.quantity,0)-nvl(mtrl.quantity_delivered,0),
986: mtrl.uom_code,
987: msib.primary_uom_code,

Line 990: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,

986: mtrl.uom_code,
987: msib.primary_uom_code,
988: null,
989: null)),
990: sum(inv_convert.inv_um_convert(mtrl.inventory_item_id,
991: null,
992: nvl(mtrl.quantity,0)-nvl(mtrl.quantity_delivered,0),
993: mtrl.uom_code,
994: msib.primary_uom_code,