DBA Data[Home] [Help]

APPS.MSC_HUB_CALENDAR dependencies on MSC_SYSTEM_ITEMS

Line 379: from msc_system_items

375: from
376: (select organization_id,
377: rank() over(order by decode(organization_id, p_def_organization_id, 1, 0) desc,
378: organization_id) n
379: from msc_system_items
380: where plan_id=p_plan_id
381: and sr_instance_id=p_sr_instance_id
382: and inventory_item_id=p_inventory_item_id
383: )