APPS.MSC_DEMANTRA_PKG dependencies on MSC_APPS_INSTANCES

Line 997: from msc_apps_instances

993: msc_phub_util.log('l_publish_mode='||l_publish_mode);
994:
995: if (l_sr_instance_id is null) then
996: select min(instance_id) into l_sr_instance_id
997: from msc_apps_instances
998: where instance_type<>3 and validation_org_id is not null;
999: end if;
1000: msc_phub_util.log('l_sr_instance_id='||l_sr_instance_id);
1001:

Line 1132: ' union all select instance_id, ''0'', ''-23453'' from msc_apps_instances'||LF||

1128: ' ) t,'||LF||
1129: ' msc_system_items msi,'||LF||
1130: ' msc_phub_customers_mv mpc,'||LF||
1131: ' (select sr_instance_id, meaning, demand_class from msc_demand_classes'||LF||
1132: ' union all select instance_id, ''0'', ''-23453'' from msc_apps_instances'||LF||
1133: ' union all select instance_id, ''N/A'', ''-23453'' from msc_apps_instances) mdc'||LF||
1134: ' where msi.plan_id(+)=-1'||LF||
1135: ' and t.'||l_dkey_item_column||'=msi.inventory_item_id(+)'||LF;
1136:

Line 1133: ' union all select instance_id, ''N/A'', ''-23453'' from msc_apps_instances) mdc'||LF||

1129: ' msc_system_items msi,'||LF||
1130: ' msc_phub_customers_mv mpc,'||LF||
1131: ' (select sr_instance_id, meaning, demand_class from msc_demand_classes'||LF||
1132: ' union all select instance_id, ''0'', ''-23453'' from msc_apps_instances'||LF||
1133: ' union all select instance_id, ''N/A'', ''-23453'' from msc_apps_instances) mdc'||LF||
1134: ' where msi.plan_id(+)=-1'||LF||
1135: ' and t.'||l_dkey_item_column||'=msi.inventory_item_id(+)'||LF;
1136:
1137: if (l_dkey_site_column <> DUMMY) then l_sql := l_sql||