APPS.MSC_CL_CONT_COLL_FW dependencies on MSC_APPS_INSTANCES

Line 451: from msc_apps_instances

447: lv_in_org_str:= MSC_CL_PULL.GET_ORG_STR(p_instance_id,2);
448:
449: select apps_lrn
450: into lv_apps_lrn
451: from msc_apps_instances
452: where instance_id = p_instance_id;
453:
454: select min(nvl(supplier_capacity_lrn,lv_apps_lrn)),
455: min(nvl(bom_lrn,lv_apps_lrn)),

Line 790: from msc_apps_instances

786: lv_in_org_str:= MSC_CL_PULL.GET_ORG_STR(p_instance_id,2);
787:
788: select apps_lrn
789: into lv_apps_lrn
790: from msc_apps_instances
791: where instance_id = p_instance_id;
792:
793: select min(nvl(supplier_capacity_lrn,lv_apps_lrn)),
794: min(nvl(bom_lrn,lv_apps_lrn)),

Line 1948: || ' from msc_apps_instances '

1944:
1945: -- lv_wip3
1946: IF lv_status_decided_wip = MSC_UTIL.SYS_NO THEN
1947: lv_sql_stmt:= 'select LBJ_DETAILS '
1948: || ' from msc_apps_instances '
1949: || ' where instance_id = ' || p_instance_id ;
1950: EXECUTE IMMEDIATE lv_sql_stmt into lv_param1;
1951:
1952: if(lv_param1 = 1) then