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 473: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

469: AWOS.workorder_id,
470: asml.inventory_item_id,
471: ASML.organization_id,
472: ASML.scheduled_material_id
473: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
474: WHERE AWOS.visit_task_id = ASML.visit_task_id
475: and ASML.inventory_item_id = MSIK.inventory_item_id
476: and ASML.organization_id = MSIK.organization_id
477: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

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

1456: END IF;
1457:
1458: IF ( qa_plan_attributes.char_id = 10 )THEN
1459: l_result_column_name := 'ITEM.' || l_result_column || ' ';
1460: l_result_column_name := '(Select ' ||l_result_column_name || ' FROM MTL_SYSTEM_ITEMS_KFV ITEM '
1461: || ' WHERE ITEM.inventory_item_id = RESULTS.'|| qa_plan_attributes.hardcoded_column
1462: || ' AND ITEM.organization_id = RESULTS.organization_id ) ' || l_result_column;
1463:
1464: ELSIF ( qa_plan_attributes.char_id = 15) THEN