eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TCM_CONTROL_PKG dependencies on MTL_ITEM_CATEGORIES

Line 111: from mtl_item_categories

107:
108: -- get the allocation
109: cursor c_item_category is
110: select 'ALLOCATED'
111: from mtl_item_categories
112: where category_set_id = l_category_set_id
113: and category_id = l_category_id
114: and organization_id = p_fsc_rec.item_org_id
115: and inventory_item_id = p_fsc_rec.classified_entity_id;

Line 120: from mtl_item_categories mit

116:
117: -- get allocation for a child when rule is on a parent level
118: cursor c_item_category_child is
119: select 'ALLOCATED'
120: from mtl_item_categories mit
121: where mit.category_set_id = l_category_set_id
122: and mit.organization_id = p_fsc_rec.item_org_id
123: and mit.inventory_item_id = p_fsc_rec.classified_entity_id
124: and exists (