DBA Data[Home] [Help]

APPS.EDW_ITEMS_M_C dependencies on MTL_SYSTEM_ITEMS_KFV

Line 97: mtl_system_items_kfv mti

93: mti.concatenated_segments,
94: mti.organization_id,
95: COUNT(mti.inventory_item_id)
96: FROM
97: mtl_system_items_kfv mti
98: GROUP BY
99: mti.concatenated_segments,
100: mti.organization_id
101: HAVING COUNT(inventory_item_id) > 1;

Line 110: mtl_system_items_kfv

106: SELECT
107: inventory_item_id,
108: organization_id
109: FROM
110: mtl_system_items_kfv
111: WHERE concatenated_segments = l_name
112: AND organization_id = l_org_id;
113:
114: BEGIN