DBA Data[Home] [Help]

APPS.MSC_ATP_PROC dependencies on MSC_DEPARTMENT_RESOURCES

Line 1915: FROM msc_department_resources

1911: SELECT department_code,
1912: resource_code
1913: INTO x_department_code,
1914: x_resource_code
1915: FROM msc_department_resources
1916: WHERE sr_instance_id = p_instance_id
1917: AND organization_id = p_organization_id
1918: AND plan_id = -1
1919: AND department_id = p_department_id

Line 4847: msc_department_resources dep_res

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
4850: AND dep_res.organization_id = p_organization_id
4851: AND dep_res.plan_id = p_plan_id