APPS.MSC_GET_NAME dependencies on MSC_TRADING_PARTNERS

Line 474: from msc_trading_partners

470:
471:
472: select organization_code
473: into org_text
474: from msc_trading_partners
475: where partner_type=3
476: and sr_tp_id=arg_org_id
477: and sr_instance_id = arg_instance_id;
478:

Line 493: FROM msc_trading_partners

489: --For SRP
490: FUNCTION org_code(arg_org_inst_id IN varchar2) return varchar2 is
491: CURSOR ORG_CUR(P_ORG_ID IN NUMBER, P_INST_ID IN NUMBER) IS
492: SELECT ORGANIZATION_CODE
493: FROM msc_trading_partners
494: WHERE SR_TP_ID = P_ORG_ID
495: AND SR_INSTANCE_ID = P_INST_ID
496: AND PARTNER_TYPE= 3;
497:

Line 1276: from msc_trading_partners

1272: supplier_name varchar2(240);
1273:
1274: cursor c_supplier_name is
1275: select partner_name
1276: from msc_trading_partners
1277: where partner_type=1 and
1278: partner_id=arg_supplier_id;
1279:
1280: cursor c_supplier_name_tp is

Line 1282: from msc_trading_partners

1278: partner_id=arg_supplier_id;
1279:
1280: cursor c_supplier_name_tp is
1281: select partner_name
1282: from msc_trading_partners
1283: where partner_type=1 and
1284: sr_tp_id=arg_supplier_id;
1285:
1286: fetched number :=0;

Line 1295: from msc_trading_partners

1291: return null;
1292: end if;
1293: /*select partner_name
1294: into supplier_name
1295: from msc_trading_partners
1296: where partner_type=1
1297: and partner_id=arg_supplier_id;
1298: */
1299: open c_supplier_name;

Line 1367: from msc_trading_partners

1363: return null;
1364: end if;
1365: select partner_name
1366: into customer_name
1367: from msc_trading_partners
1368: where partner_type=2
1369: and partner_id=arg_customer_id;
1370:
1371: return customer_name;

Line 1416: from msc_trading_partners

1412: return null;
1413: end if;
1414: select partner_name
1415: into carrier_name
1416: from msc_trading_partners
1417: where partner_type=4
1418: and partner_id=arg_carrier_id;
1419:
1420: return carrier_name;

Line 1519: msc_trading_partners mtp

1515: Select 1
1516: from
1517: msc_supplies ms,
1518: msc_system_items msi,
1519: msc_trading_partners mtp
1520: where
1521: ms.transaction_id = arg_trx_id
1522: and ms.plan_id =arg_plan_id
1523: and ms.order_type = 51

Line 2449: FROM msc_trading_partners

2445: -- initialize calendar code
2446: -- --------------------------
2447: SELECT calendar_code, calendar_exception_set_id
2448: INTO calendar_code, exc_set_id
2449: FROM msc_trading_partners
2450: WHERE sr_tp_id = p_org_id
2451: AND sr_instance_id = p_inst_id
2452: AND partner_type = 3;
2453:

Line 3124: from msc_trading_partners tp

3120: FUNCTION source_supplier(arg_sr_instance_id IN NUMBER,arg_plan_id IN NUMBER,arg_supplier_id IN NUMBER,arg_source_supplier_id IN NUMBER,arg_source_org_id IN NUMBER,arg_order_type IN NUMBER) return varchar2 IS
3121: l_supp_id NUMBER;
3122: cursor c1(l_source_org_id IN NUMBER,l_sr_instance_id IN NUMBER) IS
3123: select tp.modeled_supplier_id
3124: from msc_trading_partners tp
3125: where tp.partner_type =3 and
3126: tp.sr_tp_id = l_source_org_id and
3127: tp.sr_instance_id = l_sr_instance_id;
3128: BEGIN

Line 3158: from msc_trading_partners tp

3154: FUNCTION source_supplier_site(arg_sr_instance_id IN NUMBER,arg_plan_id IN NUMBER,arg_supplier_site_id IN NUMBER,arg_source_supplier_site_id IN NUMBER,arg_source_org_id IN NUMBER,arg_order_type IN NUMBER) return varchar2 IS
3155: l_supp_site_id NUMBER;
3156: cursor c1(l_source_org_id IN NUMBER,l_sr_instance_id IN NUMBER) IS
3157: select tp.modeled_supplier_site_id
3158: from msc_trading_partners tp
3159: where tp.partner_type =3 and
3160: tp.sr_tp_id = l_source_org_id and
3161: tp.sr_instance_id = l_sr_instance_id;
3162: BEGIN

Line 5420: from msc_trading_partners tp

5416: DEFAULT NULL
5417: ) RETURN NUMBER IS
5418: cursor cur_calendar is
5419: select tp.calendar_code, tp.calendar_exception_set_id
5420: from msc_trading_partners tp
5421: where tp.partner_type = 3
5422: and tp.sr_instance_id = p_inst_id
5423: and tp.sr_tp_id = p_org_id;
5424: