APPS.EGO_RULE_SETS_PKG dependencies on EGO_MTL_SY_ITEMS_EXT_B

Line 926: and not exists (select 'x' from ego_mtl_sy_items_ext_b where organization_id = p_org_id and inventory_item_id = p_inventory_item_id and item_catalog_group_id = p_icc_id and attr_group_id = assoc.attr_group_id and data_level_id = p_datalevel_id);

922: (SELECT attr_group_id FROM ego_attr_groups_v WHERE attr_group_type = 'EGO_ITEMMGMT_GROUP' AND application_id = 431 AND attr_group_name IN (SELECT DISTINCT user_rules.attr_group_name FROM ego_user_rules_b user_rules
923: LEFT OUTER JOIN ego_rule_sets_b rule_set ON user_rules.ruleset_id = rule_set.ruleset_id
924: WHERE user_rules.severity IS NULL AND user_rules.attr_group_type = 'EGO_ITEMMGMT_GROUP' AND rule_set.composite = 'NO' AND EXISTS (SELECT '1' FROM ego_included_businessentities WHERE ruleset_id = user_rules.ruleset_id AND business_entity = p_data_level)
925: AND (rule_set.ruleset_id IN (SELECT included_ruleset FROM EGO_INCLUDED_RULESETS START WITH ruleset_id = p_top_ruleset_id CONNECT BY PRIOR included_ruleset = ruleset_id) OR rule_set.ruleset_id = p_top_ruleset_id)))
926: and not exists (select 'x' from ego_mtl_sy_items_ext_b where organization_id = p_org_id and inventory_item_id = p_inventory_item_id and item_catalog_group_id = p_icc_id and attr_group_id = assoc.attr_group_id and data_level_id = p_datalevel_id);
927: BEGIN
928: SELECT top_ruleset_id INTO l_top_ruleset_id FROM EGO_ONDEMAND_RULES_BATCHS_B WHERE batch_id = p_batch_id;
929: SELECT business_entity INTO l_selected_business_entity FROM EGO_ONDEMAND_RULES_BATCHS_B WHERE batch_id = p_batch_id;
930: SELECT decode(l_selected_business_entity, 'ITEM_LEVEL', 43101, 'ITEM_ORG', 43102, 'ITEM_SUP', 43103, 'ITEM_SUP_SITE', 43104, 'ITEM_SUP_SITE_ORG', 43105, 'ITEM_REVISION_LEVEL', 43106, -1) INTO l_datalevel_id FROM dual;

Line 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)

951: SELECT multi_row_code INTO l_multi_row_code FROM ego_attr_groups_v WHERE attr_group_id = l_ag_id;
952: IF l_multi_row_code <> 'Y' THEN
953: SELECT EGO_EXTFWK_S.NEXTVAL INTO l_ext_id FROM dual;
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)

Line 962: FROM ego_mtl_sy_items_ext_b ext, FND_LANGUAGES L

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
963: WHERE ext.EXTENSION_ID = l_ext_id AND l.INSTALLED_FLAG IN ('I', 'B');
964: commit;
965: END IF;
966: END loop;