DBA Data[Home] [Help]

APPS.EGO_PUB_FWK_PK dependencies on MTL_SYSTEM_ITEMS_B

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