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 AHL_ITEM_ASSOCIATIONS_VL

Line 328: FROM ahl_item_associations_vl it,

324: SELECT it.inventory_item_id,
325: it.priority,
326: it.uom_code,
327: it.quantity
328: FROM ahl_item_associations_vl it,
329: mtl_system_items_vl mt
330: WHERE it.inventory_item_id = mt.inventory_item_id
331: AND item_group_id = C_ITEM_GROUP_ID
332: AND mt.organization_id = C_ORG_ID

Line 1621: FROM ahl_item_associations_vl it,

1617: CURSOR Get_top_priority_item_id_cur(C_ITEM_GROUP_ID IN NUMBER,
1618: C_ORG_ID IN NUMBER)
1619: IS
1620: SELECT it.inventory_item_id
1621: FROM ahl_item_associations_vl it,
1622: mtl_system_items_vl mt
1623: WHERE it.inventory_item_id = mt.inventory_item_id
1624: AND item_group_id = C_ITEM_GROUP_ID
1625: AND mt.organization_id = C_ORG_ID