APPS.ENI_DBI_PCO_LOAD_PKG dependencies on ENI_DBI_PART_COUNT_INCR_TEMP

Line 368: FROM ENI_DBI_PART_COUNT_INCR_TEMP);

364: effectivity_date,
365: disable_date,
366: bom_level,
367: -1
368: FROM ENI_DBI_PART_COUNT_INCR_TEMP);
369: COMMIT;
370: BEGIN
371: DBMS_MVIEW.REFRESH('ENI_DBI_PART_COUNT_MV','F');
372: /* Bug 5130157

Line 398: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||g_eni_schema||'.ENI_DBI_PART_COUNT_INCR_TEMP';

394: END IF;
395:
396: -- Truncate all the temporary tables used.
397: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||g_eni_schema||'.ENI_DBI_PCO_WORKER_ASSIGNMENTS';
398: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||g_eni_schema||'.ENI_DBI_PART_COUNT_INCR_TEMP';
399: -- DELETE FROM mlog$_bom_components_b;
400: -- DELETE FROM mlog$_bom_structures_b;
401:
402: end cleanup;

Line 478: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_part_count_incr_temp';

474: END IF;
475: END IF;
476:
477: ELSE
478: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_part_count_incr_temp';
479: IF (BIS_COLLECTION_UTILITIES.SETUP(p_object_name => 'ENI_DBI_PART_COUNT_F') = false) then
480: RAISE_APPLICATION_ERROR(-20000,l_error_msg);
481: END IF;
482: END IF;

Line 744: INSERT /*+ APPEND */ INTO eni_dbi_part_count_incr_temp

740: from mtl_system_items_b i2
741: where i2.inventory_item_id = b1.assembly_item_id and
742: i2.organization_id = b1.organization_id))));
743: ELSE
744: INSERT /*+ APPEND */ INTO eni_dbi_part_count_incr_temp
745: (
746: assembly_item_id,
747: organization_id,
748: component_item_id,