APPS.MSC_X_UTIL dependencies on MSC_SYSTEM_ITEMS

Line 85: -- from CP to return the buyer_code from msc_system_items.

81: END;
82: END GET_CATEGORY_CODE;
83:
84: -- function get_buyer_code takes in inventory_item_id, customer and supplier information
85: -- from CP to return the buyer_code from msc_system_items.
86: FUNCTION GET_BUYER_CODE (p_inventory_item_id IN NUMBER,
87: p_publisher_id IN NUMBER,
88: p_publisher_site_id IN NUMBER,
89: p_customer_id IN NUMBER,

Line 110: FROM msc_system_items msi,

106: l_org_id := null;
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

Line 1445: FROM msc_system_items msi

1441: l_buyer_code VARCHAR2(240);
1442: BEGIN
1443:
1444: SELECT distinct buyer_name into l_buyer_code
1445: FROM msc_system_items msi
1446: WHERE
1447: msi.organization_id=p_organization_id
1448: and msi.sr_instance_id = p_sr_instance_id
1449: and msi.inventory_item_id = p_inventory_item_id