DBA Data[Home] [Help]

APPS.MSC_X_CVMI_PLANNING dependencies on MSC_COMPANY_RELATIONSHIPS

Line 349: , msc_company_relationships cr

345:
346: CURSOR c_company_key_1 IS
347: SELECT cr.object_id
348: FROM msc_trading_partner_maps map
349: , msc_company_relationships cr
350: WHERE map.map_type = p_map_type
351: AND map.tp_key = p_tp_key
352: AND map.company_key = cr.relationship_id
353: AND cr.relationship_type = 1 -- customer of, 2 -- supplier of

Line 412: , msc_company_relationships cr

408:
409: CURSOR c_tp_key_1 IS
410: SELECT map.tp_key
411: FROM msc_trading_partner_maps map
412: , msc_company_relationships cr
413: WHERE map.map_type = p_map_type
414: AND cr.object_id = p_company_key
415: AND map.company_key = cr.relationship_id
416: AND cr.relationship_type = 1 -- customer of, 2 -- supplier of