APPS.MSC_X_USER_EXCEP_GEN dependencies on MSC_TRADING_PARTNERS

Line 236: msc_trading_partners mtp

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
240: AND cont.partner_type = 4

Line 252: msc_trading_partners mtp

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
256: AND cont.partner_type = 4

Line 368: msc_trading_partners mtp,

364: select
365: distinct mpc.name
366: from
367: msc_partner_contacts mpc,
368: msc_trading_partners mtp,
369: msc_trading_partner_sites mtps,
370: msc_trading_partners mtporg
371: where
372: mpc.partner_id=mtp.partner_id

Line 370: msc_trading_partners mtporg

366: from
367: msc_partner_contacts mpc,
368: msc_trading_partners mtp,
369: msc_trading_partner_sites mtps,
370: msc_trading_partners mtporg
371: where
372: mpc.partner_id=mtp.partner_id
373: and mpc.partner_site_id=mtps.partner_site_id
374: and mpc.PARTNER_TYPE =1--supplier

Line 389: msc_trading_partners mtp,

385: select
386: distinct mpc.name
387: from
388: msc_partner_contacts mpc,
389: msc_trading_partners mtp,
390: msc_trading_partners mtporg
391: where
392: mpc.partner_id=mtp.MODELED_SUPPLIER_ID
393: and mpc.partner_site_id=mtp.MODELED_SUPPLIER_SITE_ID

Line 390: msc_trading_partners mtporg

386: distinct mpc.name
387: from
388: msc_partner_contacts mpc,
389: msc_trading_partners mtp,
390: msc_trading_partners mtporg
391: where
392: mpc.partner_id=mtp.MODELED_SUPPLIER_ID
393: and mpc.partner_site_id=mtp.MODELED_SUPPLIER_SITE_ID
394: and mpc.PARTNER_TYPE =1--supplier

Line 3122: msc_trading_partners mtp

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
3126: and pl.organization_id = itm.organization_id

Line 3140: msc_trading_partners mtp

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
3144: and pl.organization_id = itm.organization_id