APPS.MSC_RELEASE_PK dependencies on MSC_CALENDAR_DATES

Line 250: FROM msc_calendar_dates cal1,

246: DECODE(mr.source_organization_id,mr.organization_id,1,2),
247: 2),
248: msi.sr_inventory_item_id,
249: nvl(mr.implement_project_id,mr.project_id)
250: FROM msc_calendar_dates cal1,
251: msc_calendar_dates cal2,
252: msc_planners mpl,
253: msc_trading_partners mparam,
254: msc_system_items msi,

Line 251: msc_calendar_dates cal2,

247: 2),
248: msi.sr_inventory_item_id,
249: nvl(mr.implement_project_id,mr.project_id)
250: FROM msc_calendar_dates cal1,
251: msc_calendar_dates cal2,
252: msc_planners mpl,
253: msc_trading_partners mparam,
254: msc_system_items msi,
255: msc_system_items rsi,

Line 415: msc_calendar_dates cal1,

411: from
412: msc_supplies ms,
413: msc_system_items msi,
414: msc_trading_partners mtp,
415: msc_calendar_dates cal1,
416: msc_calendar_dates cal2
417: where
418: ms.plan_id =arg_plan_id
419: and ms.order_type in (PLANNED_IRO,PLANNED_ERO)

Line 416: msc_calendar_dates cal2

412: msc_supplies ms,
413: msc_system_items msi,
414: msc_trading_partners mtp,
415: msc_calendar_dates cal1,
416: msc_calendar_dates cal2
417: where
418: ms.plan_id =arg_plan_id
419: and ms.order_type in (PLANNED_IRO,PLANNED_ERO)
420: and ms.inventory_item_id = msi.inventory_item_id

Line 459: msc_calendar_dates cal1,

455: from
456: msc_supplies ms,
457: msc_system_items msi,
458: msc_trading_partners mtp,
459: msc_calendar_dates cal1,
460: msc_calendar_dates cal2
461: where
462: ms.plan_id =arg_plan_id
463: and ms.order_type in (PLANNED_TRANSFER)

Line 460: msc_calendar_dates cal2

456: msc_supplies ms,
457: msc_system_items msi,
458: msc_trading_partners mtp,
459: msc_calendar_dates cal1,
460: msc_calendar_dates cal2
461: where
462: ms.plan_id =arg_plan_id
463: and ms.order_type in (PLANNED_TRANSFER)
464: and ms.inventory_item_id = msi.inventory_item_id