APPS.MSC_GET_NAME dependencies on MSC_TRADING_PARTNERS

Line 353: from msc_trading_partners

349: return null;
350: END IF;
351: select organization_code
352: into org_text
353: from msc_trading_partners
354: where partner_type=3
355: and sr_tp_id=arg_org_id
356: and sr_instance_id = arg_instance_id;
357:

Line 367: FROM msc_trading_partners

363: --For SRP
364: FUNCTION org_code(arg_org_inst_id IN varchar2) return varchar2 is
365: CURSOR ORG_CUR(P_ORG_ID IN NUMBER, P_INST_ID IN NUMBER) IS
366: SELECT ORGANIZATION_CODE
367: FROM msc_trading_partners
368: WHERE SR_TP_ID = P_ORG_ID
369: AND SR_INSTANCE_ID = P_INST_ID
370: AND PARTNER_TYPE= 3;
371:

Line 1146: from msc_trading_partners

1142: return null;
1143: end if;
1144: select partner_name
1145: into supplier_name
1146: from msc_trading_partners
1147: where partner_type=1
1148: and partner_id=arg_supplier_id;
1149:
1150: return supplier_name;

Line 1179: from msc_trading_partners

1175: return null;
1176: end if;
1177: select partner_name
1178: into customer_name
1179: from msc_trading_partners
1180: where partner_type=2
1181: and partner_id=arg_customer_id;
1182:
1183: return customer_name;

Line 2047: FROM msc_trading_partners

2043: -- initialize calendar code
2044: -- --------------------------
2045: SELECT calendar_code, calendar_exception_set_id
2046: INTO calendar_code, exc_set_id
2047: FROM msc_trading_partners
2048: WHERE sr_tp_id = p_org_id
2049: AND sr_instance_id = p_inst_id
2050: AND partner_type = 3;
2051:

Line 2722: from msc_trading_partners tp

2718: 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
2719: l_supp_id NUMBER;
2720: cursor c1(l_source_org_id IN NUMBER,l_sr_instance_id IN NUMBER) IS
2721: select tp.modeled_supplier_id
2722: from msc_trading_partners tp
2723: where tp.partner_type =3 and
2724: tp.sr_tp_id = l_source_org_id and
2725: tp.sr_instance_id = l_sr_instance_id;
2726: BEGIN

Line 2756: from msc_trading_partners tp

2752: 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
2753: l_supp_site_id NUMBER;
2754: cursor c1(l_source_org_id IN NUMBER,l_sr_instance_id IN NUMBER) IS
2755: select tp.modeled_supplier_site_id
2756: from msc_trading_partners tp
2757: where tp.partner_type =3 and
2758: tp.sr_tp_id = l_source_org_id and
2759: tp.sr_instance_id = l_sr_instance_id;
2760: BEGIN