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_SUPPLY_PKG dependencies on MSC_HUB_CALENDAR

Line 188: -1, msc_hub_calendar.last_work_date(p_plan_id,l_plan_start_date),

184:
185: supply_tbl.ship_method,
186: supply_tbl.part_condition,
187: decode(sign(to_number(supply_tbl.supply_date-l_plan_start_date)),
188: -1, msc_hub_calendar.last_work_date(p_plan_id,l_plan_start_date),
189: decode(supply_tbl.supply_type,
190: 18, msc_hub_calendar.last_work_date(p_plan_id,supply_tbl.supply_date),
191: supply_tbl.supply_date)) supply_date,
192: to_number(0) aggr_type,

Line 190: 18, msc_hub_calendar.last_work_date(p_plan_id,supply_tbl.supply_date),

186: supply_tbl.part_condition,
187: decode(sign(to_number(supply_tbl.supply_date-l_plan_start_date)),
188: -1, msc_hub_calendar.last_work_date(p_plan_id,l_plan_start_date),
189: decode(supply_tbl.supply_type,
190: 18, msc_hub_calendar.last_work_date(p_plan_id,supply_tbl.supply_date),
191: supply_tbl.supply_date)) supply_date,
192: to_number(0) aggr_type,
193: to_number(-23453) category_set_id,
194: to_number(-23453) sr_category_id,

Line 227: decode(sign(ms.organization_id), -1, msc_hub_calendar.get_item_org(p_plan_id, ms.inventory_item_id,

223: decode(sign(ms.organization_id), -1, -23453, ms.organization_id) organization_id,
224: nvl(mtp.currency_code, l_owning_currency_code) currency_code,
225: decode(ms.order_type, 18, nvl(ms.subinventory_code, '-23453'), '-23453') subinventory_code,
226: decode(sign(ms.sr_instance_id), -1, l_sr_instance_id, ms.sr_instance_id) owning_inst_id,
227: decode(sign(ms.organization_id), -1, msc_hub_calendar.get_item_org(p_plan_id, ms.inventory_item_id,
228: decode(sign(ms.sr_instance_id), -1, l_sr_instance_id, ms.sr_instance_id)),
229: ms.organization_id) owning_org_id,
230: decode(ms.source_sr_instance_id,null,-23453,0,-23453,ms.source_sr_instance_id) source_org_instance_id,
231: decode(ms.source_organization_id,null,-23453,0,-23453,ms.source_organization_id) source_organization_id,

Line 397: and decode(sign(ms.organization_id), -1, msc_hub_calendar.get_item_org(p_plan_id, ms.inventory_item_id,

393: msc_apcc_item_d msi,
394: msc_trading_partners mtp
395: where ms.plan_id = msi.plan_id
396: and decode(sign(ms.sr_instance_id), -1, l_sr_instance_id, ms.sr_instance_id) = msi.sr_instance_id
397: and decode(sign(ms.organization_id), -1, msc_hub_calendar.get_item_org(p_plan_id, ms.inventory_item_id,
398: decode(sign(ms.sr_instance_id), -1, l_sr_instance_id, ms.sr_instance_id)),
399: ms.organization_id) = msi.organization_id
400: and ms.inventory_item_id = msi.inventory_item_id
401: and ms.plan_id=p_plan_id

Line 423: decode(sign(ms.organization_id), -1, msc_hub_calendar.get_item_org(p_plan_id, ms.inventory_item_id,

419: decode(sign(ms.organization_id), -1, -23453, ms.organization_id),
420: nvl(mtp.currency_code, l_owning_currency_code),
421: decode(ms.order_type, 18, nvl(ms.subinventory_code, '-23453'), '-23453'),
422: decode(sign(ms.sr_instance_id), -1, l_sr_instance_id, ms.sr_instance_id),
423: decode(sign(ms.organization_id), -1, msc_hub_calendar.get_item_org(p_plan_id, ms.inventory_item_id,
424: decode(sign(ms.sr_instance_id), -1, l_sr_instance_id, ms.sr_instance_id)),
425: ms.organization_id),
426: decode(ms.source_sr_instance_id,null,-23453,0,-23453,ms.source_sr_instance_id),
427: decode(ms.source_organization_id,null,-23453,0,-23453,ms.source_organization_id),

Line 470: -1, msc_hub_calendar.last_work_date(p_plan_id,l_plan_start_date),

466: supply_tbl.customer_region_id,
467: supply_tbl.ship_method,
468: supply_tbl.part_condition,
469: decode(sign(to_number(supply_tbl.supply_date-l_plan_start_date)),
470: -1, msc_hub_calendar.last_work_date(p_plan_id,l_plan_start_date),
471: decode(supply_tbl.supply_type,
472: 18, msc_hub_calendar.last_work_date(p_plan_id,supply_tbl.supply_date),
473: supply_tbl.supply_date)),
474: supply_tbl.supply_type,

Line 472: 18, msc_hub_calendar.last_work_date(p_plan_id,supply_tbl.supply_date),

468: supply_tbl.part_condition,
469: decode(sign(to_number(supply_tbl.supply_date-l_plan_start_date)),
470: -1, msc_hub_calendar.last_work_date(p_plan_id,l_plan_start_date),
471: decode(supply_tbl.supply_type,
472: 18, msc_hub_calendar.last_work_date(p_plan_id,supply_tbl.supply_date),
473: supply_tbl.supply_date)),
474: supply_tbl.supply_type,
475: supply_tbl.vmi_flag;
476: