eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_DEMAND_PKG dependencies on MSC_HUB_CALENDAR

Line 139: decode(md.organization_id,-1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,

135: decode(md.organization_id, -1, -23453, md.organization_id) organization_id,
136:
137: --- we assume that the item must exist in plan's owning inst
138: decode(md.sr_instance_id, -1, l_sr_instance_id, md.sr_instance_id) owning_inst_id,
139: decode(md.organization_id,-1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,
140: decode(md.sr_instance_id,-1, l_sr_instance_id, md.sr_instance_id)),
141: md.organization_id) owning_org_id,
142: md.inventory_item_id,
143:

Line 435: decode(md.organization_id, -1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,

431: (case when md.origination_type in (5,6,7,8,9,10,11,12,15,22,27,29,30,81) and sign(md.zone_id)=1
432: then md.zone_id else -23453 end),
433: nvl(md.demand_class, '-23453'),
434:
435: decode(md.organization_id, -1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,
436: decode(md.sr_instance_id, -1, l_sr_instance_id, md.sr_instance_id)),
437: md.organization_id),
438:
439: decode(md.sr_instance_id, -1, l_sr_instance_id, md.sr_instance_id),

Line 488: decode(md.organization_id,-1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,

484: to_number(0),
485: decode(md.organization_id, -1, -23453, md.sr_instance_id) sr_instance_id,
486: decode(md.organization_id, -1, -23453, md.organization_id) organization_id,
487: decode(md.sr_instance_id, -1, l_sr_instance_id, md.sr_instance_id) owning_inst_id,
488: decode(md.organization_id,-1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,
489: decode(md.sr_instance_id,-1, l_sr_instance_id, md.sr_instance_id)),
490: md.organization_id) owning_org_id,
491: md.inventory_item_id,
492: decode(sign(md.customer_id), 1, md.customer_id, -23453) customer_id,

Line 565: decode(md.organization_id, -1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,

561: decode(sign(md.customer_site_id), 1, md.customer_site_id, -23453),
562: decode(sign(md.zone_id), 1, md.zone_id, -23453),
563: nvl(md.demand_class, '-23453'),
564:
565: decode(md.organization_id, -1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,
566: decode(md.sr_instance_id, -1, l_sr_instance_id, md.sr_instance_id)),
567: md.organization_id),
568:
569: decode(md.sr_instance_id, -1, l_sr_instance_id, md.sr_instance_id),

Line 1018: decode(md.organization_id,-1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,

1014: to_number(0),
1015: decode(md.organization_id, -1, -23453, md.sr_instance_id) sr_instance_id,
1016: decode(md.organization_id, -1, -23453, md.organization_id) organization_id,
1017: decode(md.sr_instance_id, -1, l_sr_instance_id, md.sr_instance_id) owning_inst_id,
1018: decode(md.organization_id,-1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,
1019: decode(md.sr_instance_id,-1, l_sr_instance_id, md.sr_instance_id)),
1020: md.organization_id) owning_org_id,
1021: md.inventory_item_id,
1022: decode(sign(md.customer_id), 1, md.customer_id, -23453) customer_id,

Line 1058: decode(md.organization_id,-1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,

1054: decode(sign(md.customer_id), 1, md.customer_id, -23453),
1055: decode(sign(md.customer_site_id), 1, md.customer_site_id, -23453),
1056: decode(sign(md.zone_id), 1, md.zone_id, -23453),
1057: nvl(md.demand_class, '-23453'),
1058: decode(md.organization_id,-1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,
1059: decode(md.sr_instance_id,-1, l_sr_instance_id, md.sr_instance_id)),
1060: md.organization_id),
1061: decode(md.sr_instance_id, -1, l_sr_instance_id, md.sr_instance_id),
1062: trunc(nvl(nvl(md.dmd_satisfied_date, md.schedule_ship_date),

Line 1101: decode(md.organization_id,-1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,

1097: to_number(0),
1098: decode(md.organization_id, -1, -23453, md.sr_instance_id) sr_instance_id,
1099: decode(md.organization_id, -1, -23453, md.organization_id) organization_id,
1100: decode(md.sr_instance_id, -1, l_sr_instance_id, md.sr_instance_id) owning_inst_id,
1101: decode(md.organization_id,-1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,
1102: decode(md.sr_instance_id,-1, l_sr_instance_id, md.sr_instance_id)),
1103: md.organization_id) owning_org_id,
1104: md.inventory_item_id,
1105: decode(sign(md.customer_id), 1, md.customer_id, -23453) customer_id,

Line 1140: decode(md.organization_id,-1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,

1136: decode(sign(md.customer_id), 1, md.customer_id, -23453),
1137: decode(sign(md.customer_site_id), 1, md.customer_site_id, -23453),
1138: decode(sign(md.zone_id), 1, md.zone_id, -23453),
1139: nvl(md.demand_class, '-23453'),
1140: decode(md.organization_id,-1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,
1141: decode(md.sr_instance_id,-1, l_sr_instance_id, md.sr_instance_id)),
1142: md.organization_id),
1143: decode(md.sr_instance_id, -1, l_sr_instance_id, md.sr_instance_id),
1144: trunc(nvl(md.request_ship_date, md.using_assembly_demand_date)),

Line 1182: decode(md.organization_id,-1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,

1178: to_number(0),
1179: decode(md.organization_id, -1, -23453, md.sr_instance_id) sr_instance_id,
1180: decode(md.organization_id, -1, -23453, md.organization_id) organization_id,
1181: decode(md.sr_instance_id, -1, l_sr_instance_id, md.sr_instance_id) owning_inst_id,
1182: decode(md.organization_id,-1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,
1183: decode(md.sr_instance_id,-1, l_sr_instance_id, md.sr_instance_id)),
1184: md.organization_id) owning_org_id,
1185: md.inventory_item_id,
1186: decode(sign(md.customer_id), 1, md.customer_id, -23453) customer_id,

Line 1221: decode(md.organization_id,-1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,

1217: decode(sign(md.customer_id), 1, md.customer_id, -23453),
1218: decode(sign(md.customer_site_id), 1, md.customer_site_id, -23453),
1219: decode(sign(md.zone_id), 1, md.zone_id, -23453),
1220: nvl(md.demand_class, '-23453'),
1221: decode(md.organization_id,-1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,
1222: decode(md.sr_instance_id,-1, l_sr_instance_id, md.sr_instance_id)),
1223: md.organization_id),
1224: decode(md.sr_instance_id, -1, l_sr_instance_id, md.sr_instance_id),
1225: trunc(nvl(md.promise_ship_date, md.using_assembly_demand_date)),