APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSC_TRADING_PARTNERS

Line 930: from msc_trading_partners

926: and using_organization_id = p_using_organization_id;
927:
928: cursor c2 (p_sr_instance_id IN NUMBER, p_organization_id IN number) IS
929: select calendar_code
930: from msc_trading_partners
931: where partner_type = 3
932: and sr_tp_id = p_organization_id
933: and sr_instance_id = p_sr_instance_id;
934:

Line 1061: msc_trading_partners mtp,

1057: || ':' || mtps.location
1058: || ':' || mtps.operating_unit_name
1059: INTO x_site
1060: FROM msc_trading_partner_sites mtps,
1061: msc_trading_partners mtp,
1062: msc_tp_id_lid mtil
1063: WHERE
1064: mtps.partner_site_id = p_customer_site_id
1065: AND mtp.partner_id = mtps.partner_id

Line 1077: FROM msc_trading_partners mtp,

1073: || ':' || mtil.sr_cust_account_number
1074: || ':' || mtps.location
1075: || ':' || mtps.operating_unit_name
1076: INTO x_site
1077: FROM msc_trading_partners mtp,
1078: msc_tp_id_lid mtil,
1079: msc_trading_partner_sites mtps,
1080: msc_tp_site_id_lid mtsil
1081: WHERE

Line 1196: msc_trading_partners

1192: calendar_code
1193: INTO
1194: x_calendar_code
1195: FROM
1196: msc_trading_partners
1197: WHERE
1198: partner_type = 3
1199: AND sr_tp_id = x_organization_id
1200: AND sr_instance_id = x_sr_instance_id;