DBA Data[Home] [Help]

APPS.MSC_EXCEPTION_PKG dependencies on MSC_HUB_CALENDAR

Line 172: -1, msc_hub_calendar.get_item_org(p_plan_id, med.inventory_item_id,

168: 19, decode(med.number4,null,nvl(ms.task_id,-23453),med.number1),
169: nvl(md.task_id, nvl(ms.task_id,-23453)) ) task_id,
170:
171: decode(sign(nvl(med.organization_id, -23453)),
172: -1, msc_hub_calendar.get_item_org(p_plan_id, med.inventory_item_id,
173: decode(sign(nvl(med.sr_instance_id, -23453)),
174: -1, l_sr_instance_id, med.sr_instance_id)),
175: med.organization_id) owning_org_id,
176:

Line 444: -1, msc_hub_calendar.get_item_org(p_plan_id, med.inventory_item_id,

440: 19, decode(med.number4,null,nvl(ms.task_id,-23453),med.number1),
441: nvl(md.task_id, nvl(ms.task_id,-23453)) ),
442:
443: decode(sign(nvl(med.organization_id, -23453)),
444: -1, msc_hub_calendar.get_item_org(p_plan_id, med.inventory_item_id,
445: decode(sign(nvl(med.sr_instance_id, -23453)),
446: -1, l_sr_instance_id, med.sr_instance_id)),
447: med.organization_id),
448:

Line 545: -1, msc_hub_calendar.get_item_org(p_plan_id, med.inventory_item_id,

541: nvl(med.customer_site_id, -23453) customer_site_id,
542: nvl(med.zone_id, -23453) customer_region_id,
543:
544: decode(sign(nvl(med.organization_id, -23453)),
545: -1, msc_hub_calendar.get_item_org(p_plan_id, med.inventory_item_id,
546: decode(sign(nvl(med.sr_instance_id, -23453)),
547: -1, l_sr_instance_id, med.sr_instance_id)),
548: med.organization_id) owning_org_id,
549: