APPS.AML_INTERACTION_ENGINE dependencies on MTL_SYSTEM_ITEMS_B

Line 13: -- Join mtl_system_items_b to get uom_code.

9: -- 02/23/2004 SOLIN Bug 3454115
10: -- Add "AND aap.level_type_code = 'FAMILY'" in cursor
11: -- C_Get_Category
12: -- 04/27/2004 SOLIN Bug 3584079, 3583298
13: -- Join mtl_system_items_b to get uom_code.
14: -- Change rule exit condition.
15: --
16: -- FLOW
17: --

Line 356: -- Bug 3583298, join mtl_system_items_b to get uom_code

352: AND sl.customer_id = c_customer_id
353: AND sl.status_open_flag = 'Y'
354: ORDER BY sl.lead_rank_score DESC, sl.creation_date DESC;
355:
356: -- Bug 3583298, join mtl_system_items_b to get uom_code
357: -- Bug 3583510, remove AND aap.level_type_code = 'FAMILY' because both 'PRODUCT'
358: -- and 'FAMILY' should be used.
359: CURSOR C_Get_Category(c_interaction_id NUMBER, c_default_source_code VARCHAR2) IS
360: SELECT distinct aap.category_id, aap.category_set_id, aap.inventory_item_id,

Line 366: mtl_system_items_b msi,

362: DECODE(aap.inventory_item_id, NULL, NULL, msi.primary_uom_code),
363: aap.quantity
364: FROM ams_source_codes amsc,
365: ams_act_products aap,
366: mtl_system_items_b msi,
367: (
368: SELECT jii.source_code
369: FROM jtf_ih_interactions jii
370: WHERE interaction_id = c_interaction_id