DBA Data[Home] [Help]

APPS.MSC_EXP_WF dependencies on MSC_SALES_ORDERS

Line 2493: FROM msc_sales_orders so,

2489:
2490: CURSOR SALESREP_C(p_exception_id in number,
2491: p_plan_id in number) IS
2492: SELECT so.salesrep_id
2493: FROM msc_sales_orders so,
2494: msc_demands mgr,
2495: msc_exception_details exp
2496: WHERE so.sales_order_number = mgr.order_number
2497: AND so.sr_instance_id = mgr.sr_instance_id

Line 2506: FROM msc_sales_orders so,

2502:
2503: CURSOR SALESREP_C2(p_demand_id in number,
2504: p_plan_id in number) IS
2505: SELECT so.salesrep_id
2506: FROM msc_sales_orders so,
2507: msc_demands mgr
2508: WHERE so.sales_order_number = mgr.order_number
2509: AND so.sr_instance_id = mgr.sr_instance_id
2510: AND mgr.plan_id = p_plan_id