DBA Data[Home] [Help]

APPS.MSC_ATP_PROC dependencies on MSC_ATP_RULES

Line 2321: FROM msc_atp_rules

2317:
2318: -- Bug 1757259, modified to replace = to IN for subquery. Also added distinct
2319: SELECT demand_class_atp_flag
2320: INTO l_dc_atp_flag
2321: FROM msc_atp_rules
2322: WHERE sr_instance_id = p_instance_id
2323: AND rule_id IN (
2324: SELECT distinct NVL(mi.atp_rule_id, tp.default_atp_rule_id)
2325: FROM msc_system_items mi,

Line 4801: msc_atp_rules r,

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
4805: AND i.organization_id = p_organization_id

Line 4845: msc_atp_rules r,

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
4849: AND dep_res.department_id = p_department_id