APPS.MSC_RP_RELEASE_PUB dependencies on MSC_APPS_INSTANCES

Line 87: msc_apps_instances mai

83: sum(decode(ms.load_type,20,1,0)),
84: sum(decode(mai.lrtype, 'I', 0,
85: decode(nvl(mai.st_status,0),3,1,0)))
86: FROM msc_supplies ms,
87: msc_apps_instances mai
88: where ms.plan_id = pid
89: and ms.release_errors is null
90: and ms.load_type is not null
91: and ms.sr_instance_id = mai.instance_id

Line 489: from msc_apps_instances

485: select decode(apps_ver,3,nvl(allow_release_flag ,2)
486: ,4,nvl(allow_release_flag ,2)
487: ,1) allow_release_flag,
488: instance_code
489: from msc_apps_instances
490: where instance_id = nvl(p_sr_instance_id,-1);
491: begin
492: open cur_release_flag;
493: fetch cur_release_flag