[Home] [Help]
339: 0,1,null,1,
340: sum (decode (planning_factor, 0, null, quantity_per * 100 /planning_factor)))) planning_factor,
341: min(optional_flag) optional_flag
342: FROM
343: msd_dem_bom_components
344: GROUP BY
345: sr_instance_id,
346: sr_organization_id,
347: sr_assembly_item_id,
377: retcode := 0;
378: RETURN;
379: END IF;
380:
381: msd_dem_common_utilities.log_message ('Truncating table MSD_DEM_BOM_COMPONENTS');
382: msd_dem_query_utilities.truncate_table (
383: errbuf,
384: retcode,
385: 'MSD_DEM_BOM_COMPONENTS',
381: msd_dem_common_utilities.log_message ('Truncating table MSD_DEM_BOM_COMPONENTS');
382: msd_dem_query_utilities.truncate_table (
383: errbuf,
384: retcode,
385: 'MSD_DEM_BOM_COMPONENTS',
386: 2,
387: 1);
388: IF (retcode = -1)
389: THEN
624: ELSE
625:
626: -- INSERT THE DATA
627: FORALL k IN 1..C_INSTANCE.LAST
628: INSERT INTO MSD_DEM_BOM_COMPONENTS (
629: sr_instance_id,
630: sr_organization_id,
631: sr_assembly_item_id,
632: sr_component_item_id,
670: || to_char(c_token.sr_organization_id) || '/'
671: || to_char(c_token.sr_assembly_item_id) || '/'
672: || to_char(c_token.sr_component_item_id));
673:
674: DELETE FROM MSD_DEM_BOM_COMPONENTS
675: WHERE sr_instance_id = c_token.sr_instance_id
676: AND sr_organization_id = c_token.sr_organization_id
677: AND sr_assembly_item_id = c_token.sr_assembly_item_id
678: AND sr_component_item_id = c_token.sr_component_item_id;
678: AND sr_component_item_id = c_token.sr_component_item_id;
679:
680: msd_dem_common_utilities.log_debug ('Number of rows deleted : ' || to_char(SQL%ROWCOUNT));
681:
682: INSERT INTO MSD_DEM_BOM_COMPONENTS (
683: sr_instance_id,
684: sr_organization_id,
685: sr_assembly_item_id,
686: sr_component_item_id,
716:
717: COMMIT;
718:
719: -- Analyze the table
720: msd_dem_collect_history_data.analyze_table(x_errbuf, x_retcode, 'MSD_DEM_BOM_COMPONENTS');
721:
722: END IF;
723:
724: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_collect_bom_data.collect_bom_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));