[Home] [Help]
954: --insert ext data
955: INSERT INTO ego_mtl_sy_items_ext_b(extension_id, organization_id, inventory_item_id, item_catalog_group_id, attr_group_id, data_level_id, created_by, creation_date, last_updated_by, last_update_date, revision_id, pk1_value, pk2_value)
956: VALUES (l_ext_id, l_batch_item_rec.organization_id, l_batch_item_rec.inventory_item_id, l_batch_item_rec.item_catalog_group_id, l_ag_id, l_datalevel_id, 1, SYSDATE, 1, SYSDATE, l_revision_id, l_supplier_id, l_supplier_site_id);
957: --inert language data
958: INSERT INTO ego_mtl_sy_items_ext_tl(extension_id, organization_id, inventory_item_id, item_catalog_group_id, attr_group_id, data_level_id, source_lang, language, created_by, creation_date,
959: last_updated_by, last_update_date, revision_id, pk1_value, pk2_value)
960: SELECT EXT.EXTENSION_ID, EXT.ORGANIZATION_ID, EXT.INVENTORY_ITEM_ID, EXT.ITEM_CATALOG_GROUP_ID, EXT.ATTR_GROUP_ID, ext.data_level_id, USERENV('LANG'), L.LANGUAGE_CODE, ext.created_by,
961: ext.creation_date, ext.last_updated_by, ext.last_update_date, ext.revision_id, ext.pk1_value, ext.pk2_value
962: FROM ego_mtl_sy_items_ext_b ext, FND_LANGUAGES L