APPS.MSD_SPF_COLLECT_HISTORY_DATA dependencies on MSC_SYSTEM_ITEMS

Line 3591: ' from msd_spf_mfg_bom_temp tbom, msc_system_items msib, msc_boms mb, msc_bom_components mbc, msc_system_items msis ' ||

3587: x_sql := 'INSERT into MSD_SPF_MFG_BOM_TEMP ' ||
3588: ' (EBS_BASE_MODEL_SR_PK, DM_ITEM_SR_PK, EFFECTIVE_DATE, DISABLE_DATE, RETAIN_RECORD, SEQUENCE_ID) ' ||
3589: ' (select tbom.ebs_base_model_sr_pk base, msis.sr_inventory_item_id spare, mbc.effectivity_date, ' ||
3590: ' mbc.disable_date, 0 retain_record, ' || x_run_seq || ' sequence_id ' ||
3591: ' from msd_spf_mfg_bom_temp tbom, msc_system_items msib, msc_boms mb, msc_bom_components mbc, msc_system_items msis ' ||
3592: ' where tbom.sequence_id = ' || (x_run_seq - 1) ||
3593: ' and msib.plan_id = -1 and msib.sr_instance_id = ' || p_sr_instance_id ||
3594: ' and msib.organization_id = ' || x_spf_master_org || ' and msib.sr_inventory_item_id = tbom.dm_item_sr_pk ' ||
3595: ' and mb.plan_id = -1 and mb.organization_id = ' || x_spf_master_org || ' and mb.sr_instance_id = ' || p_sr_instance_id ||

Line 3609: ' and not exists (select 1 from msc_system_items msi, msc_item_categories mic ' ||

3605: end loop;
3606:
3607: -- remove records for non serviceable spares in msd_spf_mfg_bom_temp -- Bug#12675064
3608: x_sql := 'DELETE from MSD_SPF_MFG_BOM_TEMP tbom where retain_record <> 1 ' ||
3609: ' and not exists (select 1 from msc_system_items msi, msc_item_categories mic ' ||
3610: ' where msi.plan_id = -1 and ' || ' msi.sr_instance_id = '|| p_sr_instance_id ||
3611: ' and msi.organization_id = ' || x_spf_master_org || ' and msi.sr_inventory_item_id = dm_item_sr_pk ' ||
3612: ' and mic.organization_id = msi.organization_id and mic.sr_instance_id = msi.sr_instance_id and msi.inventory_item_id = mic.inventory_item_id ' ||
3613: ' and mic.category_set_id = ' || x_category_set_id || ')';

Line 4174: SET dm_item_sr_pk = NVL((SELECT sr_inventory_item_id FROM msc_system_items msi

4170:
4171: msd_dem_common_utilities.log_message ('Update Source Inventory Item Id for Service Parts...');
4172: msd_dem_common_utilities.log_debug('Update DM_ITEM_SR_PK Query Start Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4173: UPDATE msd_spf_st_spare_usage su
4174: SET dm_item_sr_pk = NVL((SELECT sr_inventory_item_id FROM msc_system_items msi
4175: WHERE msi.plan_id = -1
4176: AND msi.sr_instance_id = p_sr_instance_id
4177: AND msi.organization_id = su.dm_org_sr_pk
4178: AND msi.item_name = su.dm_item_code), su.dm_item_sr_pk)

Line 4196: SET ebs_base_model_sr_pk = NVL((SELECT sr_inventory_item_id FROM msc_system_items msi

4192:
4193: msd_dem_common_utilities.log_message ('Update Source Inventory Item Id for Finished Goods...');
4194: msd_dem_common_utilities.log_debug('Update EBS_BASE_MODEL_SR_PK Query Start Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4195: UPDATE msd_spf_st_spare_usage su
4196: SET ebs_base_model_sr_pk = NVL((SELECT sr_inventory_item_id FROM msc_system_items msi
4197: WHERE msi.plan_id = -1
4198: AND msi.sr_instance_id = p_sr_instance_id
4199: AND msi.organization_id = var_spf_master_org -- Bug#12675064
4200: AND msi.item_name = su.ebs_base_model_code), su.ebs_base_model_sr_pk)

Line 4243: and not exists (select 1 from msc_system_items msi, msc_item_categories mic -- Bug#12675064

4239: SET process_flag = -1,
4240: error_text = 'Spare not assigned to Spare Cat Set ' || x_category_set_id || ', for - '
4241: || ' DM_ITEM_CODE = ' || dm_item_code || ''
4242: WHERE (process_flag is null or process_flag <> -1)
4243: and not exists (select 1 from msc_system_items msi, msc_item_categories mic -- Bug#12675064
4244: where msi.sr_inventory_item_id = su.dm_item_sr_pk and msi.plan_id = -1 and
4245: msi.sr_instance_id = p_sr_instance_id and msi.organization_id = su.dm_org_sr_pk
4246: and mic.organization_id = var_spf_master_org -- Bug#12675064
4247: and mic.sr_instance_id = msi.sr_instance_id