APPS.MSC_X_UTIL dependencies on MSC_TRADING_PARTNERS

Line 60: msc_trading_partners tp,

56:
57: SELECT category_name
58: INTO l_category_code
59: FROM msc_item_categories mic,
60: msc_trading_partners tp,
61: msc_trading_partner_maps map
62: WHERE map.company_key = l_org_id
63: and map.map_type = 2
64: and map.tp_key = tp.partner_id

Line 111: msc_trading_partners tp,

107: end if;
108:
109: SELECT buyer_name into l_buyer_code
110: FROM msc_system_items msi,
111: msc_trading_partners tp,
112: msc_trading_partner_maps map
113: WHERE map.company_key = l_org_id
114: and map.map_type = 2
115: and map.tp_key = tp.partner_id

Line 513: FROM msc_trading_partners

509: SELECT sr_tp_id,
510: sr_instance_id
511: INTO l_sr_tp_id,
512: l_sr_instance_id
513: FROM msc_trading_partners
514: WHERE partner_id = l_tp_org_partner_id;
515: EXCEPTION WHEN OTHERS THEN
516: l_result_date := get_default_res_date(1,
517: p_ship_date,

Line 760: FROM msc_trading_partners

756: SELECT sr_tp_id,
757: sr_instance_id
758: INTO l_sr_tp_id,
759: l_sr_instance_id
760: FROM msc_trading_partners
761: WHERE partner_id = l_tp_org_partner_id;
762: EXCEPTION WHEN OTHERS THEN
763: l_result_date := get_default_res_date(1,
764: p_ship_date,

Line 980: msc_trading_partners tp

976:
977: SELECT tp.sr_tp_id,tp.sr_instance_id
978: INTO aps_partner_id, aps_sr_instance_id
979: FROM msc_trading_partner_maps map,
980: msc_trading_partners tp
981: WHERE map.map_type = G_ORGANIZATION_MAPPING
982: AND map.company_key = p_sce_company_site_id
983: AND map.tp_key = tp.partner_id;
984:

Line 1152: from msc_trading_partners tp,

1148: begin
1149: /* If there is no customer calendar, get the OEM Org Shipping or Mfg calendar */
1150: select nvl(ca.CALENDAR_CODE, tp.calendar_code)
1151: into lv_calendar_code
1152: from msc_trading_partners tp,
1153: msc_calendar_assignments ca
1154: where tp.sr_instance_id = aps_sr_instance_id
1155: and tp.sr_tp_id = aps_org_partner_id
1156: and tp.partner_type = 3

Line 1194: msc_trading_partners tp

1190: /* Get the Org Receiving Calendar, if not available then get the OEM Orgs' Mfg calendar */
1191: select nvl(ca.CALENDAR_CODE, tp.calendar_code)
1192: into lv_calendar_code
1193: from msc_calendar_assignments ca,
1194: msc_trading_partners tp
1195: where tp.sr_instance_id = aps_sr_instance_id
1196: and tp.sr_tp_id = aps_org_partner_id
1197: and tp.partner_type = 3
1198: and ca.sr_instance_id(+) = tp.sr_instance_id

Line 1263: from msc_trading_partners tp,

1259:
1260: /* If there is no customer calendar, get the OEM Org Shipping or Mfg calendar */
1261: select nvl(ca.CALENDAR_CODE, tp.calendar_code)
1262: into lv_calendar_code
1263: from msc_trading_partners tp,
1264: msc_calendar_assignments ca
1265: where tp.sr_instance_id = aps_sr_instance_id
1266: and tp.sr_tp_id = aps_org_partner_id
1267: and tp.partner_type = 3