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.GMF_LOT_COSTING_PUB dependencies on MTL_ITEM_CATEGORIES

Line 1247: FROM mtl_item_categories mic,

1243: AND p_date BETWEEN eff_start_date AND eff_end_date
1244: AND delete_mark = 0
1245: AND cost_category_id IN
1246: ( SELECT category_id -- cost_category_id Bug#7306720
1247: FROM mtl_item_categories mic,
1248: gmf_process_organizations_gt gpo
1249: WHERE mic.inventory_item_id = p_item_id
1250: AND mic.organization_id = gpo.organization_id
1251: AND (mic.organization_id = p_orgn_id OR p_orgn_id IS NULL)

Line 7361: FROM mtl_item_categories mic,

7357: SELECT
7358: mic.organization_id, /*ANTHIYAG Bug#5279681 06-Jun-2006 */
7359: mic.inventory_item_id, /*ANTHIYAG Bug#5279681 06-Jun-2006 */
7360: i.primary_uom_code
7361: FROM mtl_item_categories mic,
7362: gmf_lot_costed_items g,
7363: mtl_system_items_b i,
7364: gmf_process_organizations_gt gpo
7365: WHERE g.cost_category_id = mic.category_id

Line 8564: mtl_item_categories mic,

8560: SELECT mic.category_id
8561: INTO l_cost_category_id
8562: FROM mtl_default_category_sets mdc,
8563: mtl_category_sets mcs,
8564: mtl_item_categories mic,
8565: mtl_categories mc
8566: WHERE mic.inventory_item_id = l_item_id
8567: AND mic.organization_id = l_orgn_id
8568: AND mic.category_id = mc.category_id