APPS.MSC_X_REPLENISH dependencies on MSC_COMPANY_RELATIONSHIPS

Line 121: msc_company_relationships r

117: msc_trading_partners tp,
118: msc_trading_partner_maps map,
119: msc_trading_partner_maps map2,
120: msc_trading_partner_maps map3,
121: msc_company_relationships r
122: WHERE sd1.plan_id = -1
123: -- Alloc onhand, po, asn, recpt, req
124: AND sd1.publisher_order_type in (9, 13, 15, 16, 20)
125: AND nvl(sd1.last_refresh_number,-1) > p_last_max_refresh_number

Line 162: msc_company_relationships r

158: msc_trading_partners tp,
159: msc_trading_partner_maps map,
160: msc_trading_partner_maps map2,
161: msc_trading_partner_maps map3,
162: msc_company_relationships r
163: WHERE sd1.plan_id = -1
164: -- Alloc onhand, po, asn, recpt, req
165: AND sd1.publisher_order_type in (9, 13, 15, 16, 20)
166: -- AND nvl(sd1.last_refresh_number,-1) > p_last_max_refresh_number

Line 2970: , msc_company_relationships cr

2966:
2967: CURSOR c_company_key_1 IS
2968: SELECT cr.object_id
2969: FROM msc_trading_partner_maps map
2970: , msc_company_relationships cr
2971: WHERE map.map_type = p_map_type
2972: AND map.tp_key = p_tp_key
2973: AND map.company_key = cr.relationship_id
2974: AND cr.relationship_type = 2

Line 3033: , msc_company_relationships cr

3029:
3030: CURSOR c_tp_key_1 IS
3031: SELECT map.tp_key
3032: FROM msc_trading_partner_maps map
3033: , msc_company_relationships cr
3034: WHERE map.map_type = p_map_type
3035: AND cr.object_id = p_company_key
3036: AND map.company_key = cr.relationship_id
3037: AND cr.relationship_type = 2

Line 3566: msc_company_relationships r,

3562: tp_key
3563: )
3564: select distinct r.object_id, map1.tp_key
3565: from msc_trading_partner_maps map1,
3566: msc_company_relationships r,
3567: msc_item_suppliers its
3568: where map1.map_type = 1
3569: AND map1.company_key = r.relationship_id
3570: AND map1.tp_key = its.supplier_id