APPS.MSC_CL_CONT_COLL_FW dependencies on MSC_INSTANCE_ORGS

Line 364: ||' msc_instance_orgs mio'

360: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' --Discrete and Process Instance--');
361: BEGIN
362: lv_sql_stmt:=' SELECT 1 '
363: ||' FROM mtl_parameters'||p_dblink||' mp,'
364: ||' msc_instance_orgs mio'
365: ||' WHERE mio.sr_instance_id= :p_instance_id'
366: ||' AND ' || lv_cond_str_enabled_flag
367: ||' AND mio.organization_id=mp.organization_id'
368: ||' 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 839: from msc_instance_orgs

835: lv_unit_no_lrn,
836: lv_uom_lrn,
837: lv_calendar_lrn,
838: lv_trip_lrn
839: from msc_instance_orgs
840: WHERE ((p_org_group =MSC_UTIL.G_ALL_ORGANIZATIONS) or (org_group=p_org_group))
841: AND sr_instance_id = p_instance_id;
842:
843: -- p_bom_sn_flag