APPS.ENI_ITEMS_STAR_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 38: mtl_system_items_kfv mti,

34: mti.concatenated_segments,
35: -- mtp.organization_code,
36: COUNT(category_id)
37: FROM
38: mtl_system_items_kfv mti,
39: -- mtl_parameters mtp,
40: mtl_item_categories cat
41: WHERE
42: mti.inventory_item_id = cat.inventory_item_id AND

Line 61: mtl_system_items_kfv mti

57: mti.concatenated_segments,
58: mti.organization_id,
59: COUNT(mti.inventory_item_id)
60: FROM
61: mtl_system_items_kfv mti
62: GROUP BY
63: mti.concatenated_segments,
64: mti.organization_id
65: HAVING COUNT(inventory_item_id) > 1;

Line 74: mtl_system_items_kfv

70: SELECT
71: inventory_item_id,
72: organization_id
73: FROM
74: mtl_system_items_kfv
75: WHERE
76: concatenated_segments = l_name;
77:
78: CURSOR c_non_flex_item IS

Line 84: mtl_system_items_kfv mti

80: count(mti.inventory_item_id),
81: mti.organization_id,
82: mti.concatenated_segments
83: FROM
84: mtl_system_items_kfv mti
85: WHERE
86: mti.concatenated_segments = 'X'
87: GROUP BY mti.concatenated_segments, mti.organization_id
88: HAVING count(inventory_item_id) > 1;