APPS.MSC_ATP_PROC dependencies on MSC_CALENDAR_DATES

Line 2966: MSC_CALENDAR_DATES C,

2962: NVL(MB.assembly_quantity,1)) quantity
2963: FROM MSC_SYSTEM_ITEMS I,
2964: MSC_BOMS MB,
2965: MSC_BOM_COMPONENTS MBC,
2966: MSC_CALENDAR_DATES C,
2967: MSC_TRADING_PARTNERS TP
2968: WHERE I.plan_id = p_plan_id and
2969: I.sr_instance_id = p_instance_id and
2970: I.organization_id = p_org_id and

Line 4790: FROM msc_calendar_dates c2,

4786:
4787: -- Obtain the ITF the normal way.
4788: SELECT c2.calendar_date, r.rule_name
4789: INTO l_infinite_time_fence_date, x_atp_rule_name
4790: FROM msc_calendar_dates c2,
4791: msc_calendar_dates c1,
4792: msc_atp_rules r,
4793: msc_trading_partners tp,
4794: msc_system_items i

Line 4791: msc_calendar_dates c1,

4787: -- Obtain the ITF the normal way.
4788: SELECT c2.calendar_date, r.rule_name
4789: INTO l_infinite_time_fence_date, x_atp_rule_name
4790: FROM msc_calendar_dates c2,
4791: msc_calendar_dates c1,
4792: msc_atp_rules r,
4793: msc_trading_partners tp,
4794: msc_system_items i
4795: WHERE i.sr_inventory_item_id = p_inventory_item_id

Line 4834: FROM msc_calendar_dates c2,

4830:
4831: ELSE -- Bug 3036513 obtain infinite_time_fence_date for resource.
4832: SELECT c2.calendar_date, r.rule_name
4833: INTO l_infinite_time_fence_date, x_atp_rule_name
4834: FROM msc_calendar_dates c2,
4835: msc_calendar_dates c1,
4836: msc_atp_rules r,
4837: msc_trading_partners tp,
4838: msc_department_resources dep_res

Line 4835: msc_calendar_dates c1,

4831: ELSE -- Bug 3036513 obtain infinite_time_fence_date for resource.
4832: SELECT c2.calendar_date, r.rule_name
4833: INTO l_infinite_time_fence_date, x_atp_rule_name
4834: FROM msc_calendar_dates c2,
4835: msc_calendar_dates c1,
4836: msc_atp_rules r,
4837: msc_trading_partners tp,
4838: msc_department_resources dep_res
4839: WHERE dep_res.resource_id = p_resource_id