APPS.MSC_SCE_LOADS_PKG dependencies on MSC_ITEM_CUSTOMERS

Line 1055: from msc_item_customers mic

1051: ln.supplier_item_name)) and
1052: mis.plan_id = -1
1053: UNION
1054: select mic.inventory_item_id
1055: from msc_item_customers mic
1056: where mic.customer_item_name = NVL(ln.owner_item_name,
1057: NVL(ln.customer_item_name,
1058: ln.supplier_item_name)) and
1059: mic.plan_id = -1 );

Line 1989: from msc_item_customers mic,

1985: cs.company_id = c.company_id AND
1986: ln.item_name IS NULL
1987: UNION
1988: select mic.inventory_item_id
1989: from msc_item_customers mic,
1990: msc_trading_partner_maps map,
1991: msc_trading_partner_maps map1,
1992: msc_company_relationships r,
1993: msc_company_sites cs,

Line 2525: from msc_item_customers mic,

2521: cs.company_id = c.company_id AND
2522: ln.item_name IS NULL
2523: UNION
2524: select mic.inventory_item_id
2525: from msc_item_customers mic,
2526: msc_trading_partner_maps map,
2527: msc_trading_partner_maps map1,
2528: msc_company_relationships r,
2529: msc_company_sites cs,

Line 8540: from msc_item_customers mic,

8536: l_uom,
8537: l_base_item_id,
8538: l_base_item_name,
8539: l_planner_code--Bug 4424426
8540: from msc_item_customers mic,
8541: msc_trading_partner_maps map,
8542: msc_trading_partner_maps map1,
8543: msc_company_relationships r
8544: where mic.inventory_item_id = t_item_id(j) and

Line 8641: from msc_item_customers mic,

8637: mic.uom_code
8638: into l_item_name,
8639: l_desc,
8640: l_uom
8641: from msc_item_customers mic,
8642: msc_trading_partner_maps map,
8643: msc_trading_partner_maps map1,
8644: msc_company_relationships r
8645: where mic.inventory_item_id = t_item_id(j) and

Line 10075: FROM msc_item_customers mic,

10071: mssn.master_item_name IS NULL
10072:
10073: UNION ALL
10074: SELECT mic.inventory_item_id
10075: FROM msc_item_customers mic,
10076: msc_trading_partner_maps map,
10077: msc_trading_partner_maps map1,
10078: msc_company_relationships r,
10079: msc_company_sites cs,