APPS.MSC_CL_PUBLISH dependencies on MSC_ITEM_CUSTOMERS

Line 3772: /* Add code to get customer item name from msc_item customers */

3768: t_sup_item_desc(i) := t_item_desc(i);
3769:
3770: t_customer_item_name(i) := null;
3771:
3772: /* Add code to get customer item name from msc_item customers */
3773:
3774: BEGIN
3775:
3776: /* sbala Using Fetching Customer item name,

Line 3786: from msc_item_customers mic

3782: uom_code
3783: into l_customer_item_name,
3784: l_customer_item_desc,
3785: l_tp_uom
3786: from msc_item_customers mic
3787: where mic.plan_id = G_PLAN_ID
3788: and mic.inventory_item_id = t_item_id(i)
3789: and mic.customer_id = t_supp_id(i)
3790: and nvl(mic.customer_site_id, -99) = decode(

Line 4526: from msc_item_customers mic

4522: uom_code
4523: into l_customer_item_name,
4524: l_customer_item_desc,
4525: l_tp_uom
4526: from msc_item_customers mic
4527: where mic.plan_id = G_PLAN_ID
4528: and mic.inventory_item_id = t_item_id(i)
4529: and mic.customer_id = t_partner_id(i)
4530: and nvl(mic.customer_site_id, -99) = decode(mic.customer_site_id,