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_PUB_FWK_PK dependencies on MTL_ITEM_REVISIONS_B

Line 2188: FROM MTL_ITEM_REVISIONS_B

2184: l_has_expl_err BOOLEAN := false;
2185:
2186: cursor c_rev_impl (c_rev_id number) is
2187: SELECT 'N'
2188: FROM MTL_ITEM_REVISIONS_B
2189: WHERE IMPLEMENTATION_DATE IS null AND REVISION_ID = c_rev_id;
2190:
2191: cursor c_valid_expl (c_item_id number, c_org_id number, c_expl_date date) is
2192: SELECT Max(revision_id) RevisionId

Line 2193: FROM mtl_item_revisions_b

2189: WHERE IMPLEMENTATION_DATE IS null AND REVISION_ID = c_rev_id;
2190:
2191: cursor c_valid_expl (c_item_id number, c_org_id number, c_expl_date date) is
2192: SELECT Max(revision_id) RevisionId
2193: FROM mtl_item_revisions_b
2194: WHERE inventory_item_id = c_item_id
2195: AND organization_id = c_org_id
2196: AND effectivity_date <= c_expl_date
2197: AND implementation_date IS NOT NULL;

Line 2435: from mtl_system_items_b mi, mtl_item_revisions_b mr

2431: l_pk3_value := nvl(p_batch_entities(i).pk3_value, -1);
2432: if (p_batch_type = C_BATCH_ENTITY_ITEM) then
2433: begin
2434: select mi.inventory_item_id into l_entity_id
2435: from mtl_system_items_b mi, mtl_item_revisions_b mr
2436: where mi.inventory_item_id = mr.inventory_item_id
2437: and mi.organization_id = mr.organization_id
2438: and mi.inventory_item_id = l_pk1_value
2439: and mi.organization_id = l_pk2_value