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.EGO_ITEM_OPEN_INTERFACE_PVT dependencies on MTL_ITEM_REVISIONS_B

Line 228: FROM mtl_item_revisions_b

224: CURSOR c_get_effective_revision(cp_inventory_item_id NUMBER
225: ,cp_organization_id NUMBER
226: ,cp_revision VARCHAR2) IS
227: SELECT revision_id
228: FROM mtl_item_revisions_b
229: WHERE inventory_item_id = cp_inventory_item_id
230: AND organization_id = cp_organization_id
231: AND revision < cp_revision
232: AND implementation_date IS NOT NULL

Line 236: l_source_revision_id mtl_item_revisions_b.revision_id%TYPE;

232: AND implementation_date IS NOT NULL
233: AND effectivity_date <= sysdate
234: ORDER BY effectivity_date desc;
235:
236: l_source_revision_id mtl_item_revisions_b.revision_id%TYPE;
237: l_return_status VARCHAR2(100);
238: l_error_code NUMBER;
239: l_msg_count NUMBER ;
240: l_msg_data VARCHAR2(100);