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.AHL_PRD_WO_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 452: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

448: AWOS.workorder_id,
449: asml.inventory_item_id,
450: ASML.organization_id,
451: ASML.scheduled_material_id
452: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
453: WHERE AWOS.visit_task_id = ASML.visit_task_id
454: and ASML.inventory_item_id = MSIK.inventory_item_id
455: and ASML.organization_id = MSIK.organization_id
456: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 1435: l_result_column_name := '(Select ' ||l_result_column_name || ' FROM MTL_SYSTEM_ITEMS_KFV ITEM '

1431: END IF;
1432:
1433: IF ( qa_plan_attributes.char_id = 10 )THEN
1434: l_result_column_name := 'ITEM.' || l_result_column || ' ';
1435: l_result_column_name := '(Select ' ||l_result_column_name || ' FROM MTL_SYSTEM_ITEMS_KFV ITEM '
1436: || ' WHERE ITEM.inventory_item_id = RESULTS.'|| qa_plan_attributes.hardcoded_column
1437: || ' AND ITEM.organization_id = RESULTS.organization_id ) ' || l_result_column;
1438:
1439: ELSIF ( qa_plan_attributes.char_id = 15) THEN