APPS.ENI_DBI_PCO_LOAD_PKG dependencies on BOM_EXPLOSION_TEMP

Line 641: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||g_bom_schema||'.BOM_EXPLOSION_TEMP';

637: IF(FND_INSTALLATION.GET_APP_INFO('ENI', l_status, l_industry, g_eni_schema))
638: THEN NULL;
639: END IF;
640:
641: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||g_bom_schema||'.BOM_EXPLOSION_TEMP';
642: FOR r_bom_enabled_items IN c_bom_enabled_items(p_worker_id) LOOP
643: l_org_id := r_bom_enabled_items.organization_id;
644: l_inventory_item_id := r_bom_enabled_items.assembly_item_id;
645: l_grp_id := l_grp_id + 1;

Line 720: bom_explosion_temp b1,mtl_system_items_b i

716: trunc(NVL(b1.disable_date,to_date('1-1-2085','dd-mm-yyyy'))),
717: b1.plan_level,
718: -1
719: FROM
720: bom_explosion_temp b1,mtl_system_items_b i
721: WHERE
722: b1.component_sequence_id IS NOT NULL and
723: b1.bom_item_type <> 2 and
724: -- Filtering out the Option classes items which

Line 761: bom_explosion_temp b1,mtl_system_items_b i

757: trunc(b1.effectivity_date),
758: trunc(NVL(b1.disable_date,to_date('1-1-2085','dd-mm-yyyy'))),
759: b1.plan_level
760: FROM
761: bom_explosion_temp b1,mtl_system_items_b i
762: WHERE
763: b1.component_sequence_id IS NOT NULL and
764: b1.bom_item_type <> 2 and
765: -- Filtering out the Option classes items which