eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_X_CP_FLOW dependencies on MSC_COMPANY_RELATIONSHIPS

Line 297: , msc_company_relationships cr

293:
294: CURSOR c_aps_customer_id (p_customer_id IN NUMBER) IS
295: SELECT map.tp_key
296: FROM msc_trading_partner_maps map
297: , msc_company_relationships cr
298: WHERE map.map_type = 1 -- company level mapping
299: AND cr.object_id = p_customer_id
300: AND map.company_key = cr.relationship_id
301: AND cr.relationship_type = 1 -- customer

Line 560: , msc_company_relationships cr

556:
557: CURSOR c_aps_supplier_id (p_supplier_id IN NUMBER) IS
558: SELECT map.tp_key
559: FROM msc_trading_partner_maps map
560: , msc_company_relationships cr
561: WHERE map.map_type = 1 -- company level mapping
562: AND cr.object_id = p_supplier_id
563: AND map.company_key = cr.relationship_id
564: AND cr.relationship_type = 2 -- supplier