APPS.MSC_CL_MISCELLANEOUS dependencies on MSC_SOURCING_HISTORY

Line 363: then the table msc_sourcing_history would have been deleted and relcalculation will be

359:
360: /* if the profile option is set and the effectivity date of the Sourcing rule is
361: greater than the new start date (based on offset days as calculated above) ,
362: then the start date will be the effectivity date.If the parameter Purge SH has been set in ODS
363: then the table msc_sourcing_history would have been deleted and relcalculation will be
364: done from this new date */
365:
366: IF (start_date_offset IS NOT NULL) THEN
367: IF start_date_new > lv_start_date THEN

Line 449: FROM MSC_SOURCING_HISTORY msh

445: INTO lv_rowid,
446: lv_start_date,
447: lv_historical_allocation,
448: lv_record_exists
449: FROM MSC_SOURCING_HISTORY msh
450: WHERE msh.inventory_item_id= arg_item_id
451: AND msh.organization_id= arg_org_id
452: AND msh.sr_instance_id= v_instance_id
453: AND msh.sourcing_rule_id= arg_sourcing_rule_id

Line 538: UPDATE MSC_SOURCING_HISTORY

534: NVL( lv_historical_allocation,0);
535:
536: IF lv_record_exists= SYS_YES THEN
537:
538: UPDATE MSC_SOURCING_HISTORY
539: SET historical_allocation= lv_total_alloc_qty,
540: last_calculated_date = v_current_date,
541: LAST_UPDATED_BY = v_current_user,
542: LAST_UPDATE_DATE = v_current_date

Line 548: INSERT INTO MSC_SOURCING_HISTORY

544: c_count:= c_count+1;
545:
546: ELSE
547:
548: INSERT INTO MSC_SOURCING_HISTORY
549: ( inventory_item_id,
550: organization_id,
551: sourcing_rule_id,
552: source_org_id,