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_RULE_SETS_PKG dependencies on EGO_ATTR_GROUPS_V

Line 909: l_ag_id ego_attr_groups_v.attr_group_id%TYPE;

905: l_ext_id number;
906: l_top_ruleset_id NUMBER;
907: l_selected_business_entity EGO_ONDEMAND_RULES_BATCHS_B.business_entity%type;
908: l_datalevel_id NUMBER;
909: l_ag_id ego_attr_groups_v.attr_group_id%TYPE;
910: l_multi_row_code ego_attr_groups_v.multi_row_code%type;
911:
912: l_revision_id NUMBER DEFAULT NULL;
913: l_supplier_id NUMBER DEFAULT NULL;

Line 910: l_multi_row_code ego_attr_groups_v.multi_row_code%type;

906: l_top_ruleset_id NUMBER;
907: l_selected_business_entity EGO_ONDEMAND_RULES_BATCHS_B.business_entity%type;
908: l_datalevel_id NUMBER;
909: l_ag_id ego_attr_groups_v.attr_group_id%TYPE;
910: l_multi_row_code ego_attr_groups_v.multi_row_code%type;
911:
912: l_revision_id NUMBER DEFAULT NULL;
913: l_supplier_id NUMBER DEFAULT NULL;
914: l_supplier_site_id number default null;

Line 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

918: SELECT * FROM EGO_ONDEMAND_RULES_ITEMS_B WHERE batch_id = p_batch AND process_status = 1;
919:
920: CURSOR c_default_ag(p_data_level VARCHAR2, p_datalevel_id NUMBER, p_top_ruleset_id NUMBER, p_org_id NUMBER, p_inventory_item_id NUMBER, p_icc_id NUMBER) IS
921: SELECT DISTINCT assoc.attr_group_id FROM EGO_OBJ_ATTR_GRP_ASSOCS_V assoc WHERE assoc.application_id = 431 AND assoc.classification_code = to_char(p_icc_id) AND assoc.data_level_int_name = p_data_level AND assoc.attr_group_id IN
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);

Line 951: SELECT multi_row_code INTO l_multi_row_code FROM ego_attr_groups_v WHERE attr_group_id = l_ag_id;

947: loop
948: fetch c_default_ag INTO l_ag_id;
949: exit WHEN c_default_ag%NOTFOUND;
950:
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)