DBA Data[Home] [Help]

APPS.MSC_EXP_WF dependencies on MSC_SALES_ORDERS

Line 2487: FROM msc_sales_orders so,

2483:
2484: CURSOR SALESREP_C(p_exception_id in number,
2485: p_plan_id in number) IS
2486: SELECT so.salesrep_id
2487: FROM msc_sales_orders so,
2488: msc_demands mgr,
2489: msc_exception_details exp
2490: WHERE so.sales_order_number = mgr.order_number
2491: AND so.sr_instance_id = mgr.sr_instance_id

Line 2500: FROM msc_sales_orders so,

2496:
2497: CURSOR SALESREP_C2(p_demand_id in number,
2498: p_plan_id in number) IS
2499: SELECT so.salesrep_id
2500: FROM msc_sales_orders so,
2501: msc_demands mgr
2502: WHERE so.sales_order_number = mgr.order_number
2503: AND so.sr_instance_id = mgr.sr_instance_id
2504: AND mgr.plan_id = p_plan_id