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 797: from msc_apps_instances

793: lv_in_org_str:= MSC_CL_PULL.GET_ORG_STR(p_instance_id,2);
794:
795: select apps_lrn
796: into lv_apps_lrn
797: from msc_apps_instances
798: where instance_id = p_instance_id;
799:
800: select min(nvl(supplier_capacity_lrn,lv_apps_lrn)),
801: min(nvl(bom_lrn,lv_apps_lrn)),

Line 1981: || ' from msc_apps_instances '

1977:
1978: -- lv_wip3
1979: IF lv_status_decided_wip = MSC_UTIL.SYS_NO THEN
1980: lv_sql_stmt:= 'select LBJ_DETAILS '
1981: || ' from msc_apps_instances '
1982: || ' where instance_id = ' || p_instance_id ;
1983: EXECUTE IMMEDIATE lv_sql_stmt into lv_param1;
1984:
1985: if(lv_param1 = 1) then