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_LTP_REQST_MATRL_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 80: mtl_system_items_kfv mtl

76: asm.requested_date,
77: asm.status,
78: mtl.concatenated_segments
79: FROM ahl_schedule_materials asm,
80: mtl_system_items_kfv mtl
81: WHERE asm.visit_id = c_visit_id
82: AND mtl.inventory_item_id = asm.inventory_item_id
83: AND mtl.organization_id = asm.organization_id;
84:

Line 1561: mtl_system_items_kfv mtl

1557: asm.requested_date,
1558: mtl.concatenated_segments
1559: FROM ahl_visit_tasks_b tsk,
1560: ahl_schedule_materials asm,
1561: mtl_system_items_kfv mtl
1562: WHERE asm.visit_id = C_VISIT_ID
1563: AND asm.visit_task_id = tsk.visit_task_id
1564: AND tsk.status_code ='DELETED'
1565: AND asm.status <> 'DELETED'

Line 1584: mtl_system_items_kfv mtl

1580: asm.requested_date,
1581: asm.scheduled_date,
1582: mtl.concatenated_segments
1583: FROM ahl_schedule_materials asm,
1584: mtl_system_items_kfv mtl
1585: WHERE asm.visit_task_id = c_visit_task_id
1586: AND asm.rt_oper_material_id = c_rt_oper_material_id
1587: AND NVL(asm.STATUS, 'X') = 'ACTIVE'
1588: AND mtl.inventory_item_id = asm.inventory_item_id

Line 1611: FROM mtl_system_items_kfv mtl

1607:
1608: -- Cursor added by surrkuma on 15-JUL-2010 for Bug 9901811
1609: CURSOR Item_exists_in_org_Cur(c_item_id IN NUMBER, c_org_id IN NUMBER ) IS
1610: SELECT 1
1611: FROM mtl_system_items_kfv mtl
1612: WHERE mtl.inventory_item_id = c_item_id
1613: AND mtl.organization_id = c_org_id;
1614:
1615: -- surrkuma :: Bug #9901811 :: 15-JUL-2010