APPS.MSC_CL_CONT_COLL_FW dependencies on MSC_INSTANCE_ORGS

Line 363: ||' msc_instance_orgs mio'

359: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' --Discrete and Process Instance--');
360: BEGIN
361: lv_sql_stmt:=' SELECT 1 '
362: ||' FROM mtl_parameters'||p_dblink||' mp,'
363: ||' msc_instance_orgs mio'
364: ||' WHERE mio.sr_instance_id= :p_instance_id'
365: ||' AND ' || lv_cond_str_enabled_flag
366: ||' AND mio.organization_id=mp.organization_id'
367: ||' AND mp.process_enabled_flag='||'''Y'''

Line 493: from msc_instance_orgs

489: lv_unit_no_lrn,
490: lv_uom_lrn,
491: lv_calendar_lrn,
492: lv_trip_lrn
493: from msc_instance_orgs
494: WHERE ((p_org_group =MSC_UTIL.G_ALL_ORGANIZATIONS) or (org_group=p_org_group))
495: AND sr_instance_id = p_instance_id;
496:
497:

Line 832: from msc_instance_orgs

828: lv_unit_no_lrn,
829: lv_uom_lrn,
830: lv_calendar_lrn,
831: lv_trip_lrn
832: from msc_instance_orgs
833: WHERE ((p_org_group =MSC_UTIL.G_ALL_ORGANIZATIONS) or (org_group=p_org_group))
834: AND sr_instance_id = p_instance_id;
835:
836: -- p_bom_sn_flag