APPS.MSC_ATP_PROC dependencies on MSC_CALENDAR_DATES

Line 2974: MSC_CALENDAR_DATES C,

2970: NVL(MB.assembly_quantity,1)) quantity
2971: FROM MSC_SYSTEM_ITEMS I,
2972: MSC_BOMS MB,
2973: MSC_BOM_COMPONENTS MBC,
2974: MSC_CALENDAR_DATES C,
2975: MSC_TRADING_PARTNERS TP
2976: WHERE I.plan_id = p_plan_id and
2977: I.sr_instance_id = p_instance_id and
2978: I.organization_id = p_org_id and

Line 4799: FROM msc_calendar_dates c2,

4795:
4796: -- Obtain the ITF the normal way.
4797: SELECT c2.calendar_date, r.rule_name
4798: INTO l_infinite_time_fence_date, x_atp_rule_name
4799: FROM msc_calendar_dates c2,
4800: msc_calendar_dates c1,
4801: msc_atp_rules r,
4802: msc_trading_partners tp,
4803: msc_system_items i

Line 4800: msc_calendar_dates c1,

4796: -- Obtain the ITF the normal way.
4797: SELECT c2.calendar_date, r.rule_name
4798: INTO l_infinite_time_fence_date, x_atp_rule_name
4799: FROM msc_calendar_dates c2,
4800: msc_calendar_dates c1,
4801: msc_atp_rules r,
4802: msc_trading_partners tp,
4803: msc_system_items i
4804: WHERE i.sr_inventory_item_id = p_inventory_item_id

Line 4843: FROM msc_calendar_dates c2,

4839:
4840: ELSE -- Bug 3036513 obtain infinite_time_fence_date for resource.
4841: SELECT c2.calendar_date, r.rule_name
4842: INTO l_infinite_time_fence_date, x_atp_rule_name
4843: FROM msc_calendar_dates c2,
4844: msc_calendar_dates c1,
4845: msc_atp_rules r,
4846: msc_trading_partners tp,
4847: msc_department_resources dep_res

Line 4844: msc_calendar_dates c1,

4840: ELSE -- Bug 3036513 obtain infinite_time_fence_date for resource.
4841: SELECT c2.calendar_date, r.rule_name
4842: INTO l_infinite_time_fence_date, x_atp_rule_name
4843: FROM msc_calendar_dates c2,
4844: msc_calendar_dates c1,
4845: msc_atp_rules r,
4846: msc_trading_partners tp,
4847: msc_department_resources dep_res
4848: WHERE dep_res.resource_id = p_resource_id