APPS.MSC_RELEASE_PK dependencies on MSC_CALENDAR_DATES

Line 273: FROM msc_calendar_dates cal1,

269: msi.sr_inventory_item_id,
270: nvl(mr.implement_project_id,mr.project_id),
271: mr.disposition_status_type
272: ,cal2.calendar_date -- date also to print 10325294
273: FROM msc_calendar_dates cal1,
274: msc_calendar_dates cal2,
275: msc_planners mpl,
276: msc_trading_partners mparam,
277: msc_system_items msi,

Line 274: msc_calendar_dates cal2,

270: nvl(mr.implement_project_id,mr.project_id),
271: mr.disposition_status_type
272: ,cal2.calendar_date -- date also to print 10325294
273: FROM msc_calendar_dates cal1,
274: msc_calendar_dates cal2,
275: msc_planners mpl,
276: msc_trading_partners mparam,
277: msc_system_items msi,
278: msc_system_items rsi,

Line 467: msc_calendar_dates cal1,

463: msc_supplies ms,
464: msc_plans mps,
465: msc_system_items msi,
466: msc_trading_partners mtp,
467: msc_calendar_dates cal1,
468: msc_calendar_dates cal2
469: where
470: ms.plan_id =arg_plan_id
471: and ms.order_type in (PLANNED_IRO,PLANNED_ERO)

Line 468: msc_calendar_dates cal2

464: msc_plans mps,
465: msc_system_items msi,
466: msc_trading_partners mtp,
467: msc_calendar_dates cal1,
468: msc_calendar_dates cal2
469: where
470: ms.plan_id =arg_plan_id
471: and ms.order_type in (PLANNED_IRO,PLANNED_ERO)
472: and ms.inventory_item_id = msi.inventory_item_id

Line 517: msc_calendar_dates cal1,

513: msc_supplies ms,
514: msc_plans mps,
515: msc_system_items msi,
516: msc_trading_partners mtp,
517: msc_calendar_dates cal1,
518: msc_calendar_dates cal2
519: where
520: ms.plan_id =arg_plan_id
521: and ms.order_type in (PLANNED_TRANSFER)

Line 518: msc_calendar_dates cal2

514: msc_plans mps,
515: msc_system_items msi,
516: msc_trading_partners mtp,
517: msc_calendar_dates cal1,
518: msc_calendar_dates cal2
519: where
520: ms.plan_id =arg_plan_id
521: and ms.order_type in (PLANNED_TRANSFER)
522: and ms.inventory_item_id = msi.inventory_item_id

Line 584: msc_calendar_dates cal1,

580: msc_supplies ms,
581: msc_plans mps,
582: msc_system_items msi,
583: msc_trading_partners mtp,
584: msc_calendar_dates cal1,
585: msc_calendar_dates cal2
586: where
587: ms.plan_id =arg_plan_id
588: and ms.order_type in (PLANNED_REP_WO,RESCHEDULE_EAM_CMRO) --79,70

Line 585: msc_calendar_dates cal2

581: msc_plans mps,
582: msc_system_items msi,
583: msc_trading_partners mtp,
584: msc_calendar_dates cal1,
585: msc_calendar_dates cal2
586: where
587: ms.plan_id =arg_plan_id
588: and ms.order_type in (PLANNED_REP_WO,RESCHEDULE_EAM_CMRO) --79,70
589: and ms.inventory_item_id = msi.inventory_item_id