[Home] [Help]
231: --if item and org are there
232: cursor buyer_c1(p_item IN VARCHAR2,p_org IN VARCHAR2) is
233: SELECT cont.name
234: FROM msc_partner_contacts cont,
235: msc_system_items sys,
236: msc_trading_partners mtp
237: WHERE sys.item_name = p_item
238: AND sys.plan_id = -1
239: AND cont.partner_id = sys.buyer_id
247:
248: cursor buyer_c2(p_item IN VARCHAR2) is
249: SELECT cont.name
250: FROM msc_partner_contacts cont,
251: msc_system_items sys,
252: msc_trading_partners mtp
253: WHERE sys.item_name = p_item
254: AND sys.plan_id = -1
255: AND cont.partner_id = sys.buyer_id
3104: cursor planner_c(p_item IN VARCHAR2) is
3105: select distinct pl.user_name,
3106: pl.planner_code
3107: from msc_planners pl,
3108: msc_system_items itm
3109: where itm.plan_id = -1
3110: --and itm.organization_id = p_organization_id
3111: and itm.item_name = p_item
3112: --and itm.sr_instance_id = pl.sr_instance_id
3117: cursor planner_c1(p_item IN VARCHAR2,p_org IN VARCHAR2) is
3118: select distinct pl.user_name,
3119: pl.planner_code
3120: from msc_planners pl,
3121: msc_system_items itm,
3122: msc_trading_partners mtp
3123: where itm.plan_id = -1
3124: and itm.organization_id = pl.organization_id
3125: and itm.item_name = p_item
3135: cursor planner_c2(p_item IN VARCHAR2) is
3136: select distinct pl.user_name,
3137: pl.planner_code
3138: from msc_planners pl,
3139: msc_system_items itm,
3140: msc_trading_partners mtp
3141: where itm.plan_id = -1
3142: and itm.organization_id = pl.organization_id
3143: and itm.item_name = p_item