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_INV_ITEM_CATALOG_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 737: FROM mtl_item_catalog_groups_b

733: CURSOR c_lost_catalogs(cp_old_id NUMBER,
734: cp_new_id NUMBER) IS
735: SELECT item_catalog_group_id
736: FROM ((SELECT item_catalog_group_id
737: FROM mtl_item_catalog_groups_b
738: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
739: START WITH item_catalog_group_id = cp_old_id)
740: MINUS
741: (SELECT item_catalog_group_id

Line 742: FROM mtl_item_catalog_groups_b

738: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
739: START WITH item_catalog_group_id = cp_old_id)
740: MINUS
741: (SELECT item_catalog_group_id
742: FROM mtl_item_catalog_groups_b
743: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
744: START WITH item_catalog_group_id = cp_new_id));
745:
746: */

Line 835: FROM mtl_item_catalog_groups_b

831: FROM ego_obj_attr_grp_assocs_v
832: WHERE attr_group_id = ext.attr_group_id
833: AND classification_code IN
834: (SELECT to_char(item_catalog_group_id)
835: FROM mtl_item_catalog_groups_b
836: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
837: START WITH item_catalog_group_id = p_catalog_group_id))
838: AND NOT EXISTS (SELECT NULL
839: FROM ego_obj_attr_grp_assocs_v

Line 843: FROM mtl_item_catalog_groups_b

839: FROM ego_obj_attr_grp_assocs_v
840: WHERE attr_group_id = ext.attr_group_id
841: AND classification_code IN
842: (SELECT to_char(item_catalog_group_id)
843: FROM mtl_item_catalog_groups_b
844: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
845: START WITH item_catalog_group_id = p_new_catalog_group_id));
846:
847: /* Fix for Bug 10404086- If there are no recs in ego_mtl_sy_items_ext_b ,

Line 858: FROM mtl_item_catalog_groups_b

854: FROM ego_obj_attr_grp_assocs_v
855: WHERE attr_group_id = extl.attr_group_id
856: AND classification_code IN
857: (SELECT to_char(item_catalog_group_id)
858: FROM mtl_item_catalog_groups_b
859: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
860: START WITH item_catalog_group_id = p_catalog_group_id))
861: AND NOT EXISTS (SELECT NULL
862: FROM ego_obj_attr_grp_assocs_v

Line 866: FROM mtl_item_catalog_groups_b

862: FROM ego_obj_attr_grp_assocs_v
863: WHERE attr_group_id = extl.attr_group_id
864: AND classification_code IN
865: (SELECT to_char(item_catalog_group_id)
866: FROM mtl_item_catalog_groups_b
867: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
868: START WITH item_catalog_group_id = p_new_catalog_group_id));
869: End If; /* Fix for bug 10404086 - end of if for delete on ego_mtl_sy_items_ext_tl */
870:

Line 900: FROM mtl_item_catalog_groups_b

896: FROM ego_objtype_attach_cats
897: WHERE attach_category_id = docs.category_id
898: AND classification_code IN
899: (SELECT to_char(item_catalog_group_id)
900: FROM mtl_item_catalog_groups_b
901: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
902: START WITH item_catalog_group_id = p_catalog_group_id))
903: AND NOT EXISTS (SELECT NULL
904: FROM ego_objtype_attach_cats

Line 908: FROM mtl_item_catalog_groups_b

904: FROM ego_objtype_attach_cats
905: WHERE attach_category_id = docs.category_id
906: AND classification_code IN
907: (SELECT to_char(item_catalog_group_id)
908: FROM mtl_item_catalog_groups_b
909: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
910: START WITH item_catalog_group_id = p_new_catalog_group_id));
911:
912: -- END LOOP;

Line 1856: ' SELECT TO_CHAR(item_catalog_group_id) FROM mtl_item_catalog_groups_b ' ||

1852: ' WHERE attr_chg.change_line_id = change.revised_item_sequence_id ' ||
1853: -- 3710038 check for the attributes in the hierarchy
1854: -- AND to_char(attr_chg.item_catalog_group_id) = assoc.classification_code
1855: ' AND assoc.classification_code IN ( ' ||
1856: ' SELECT TO_CHAR(item_catalog_group_id) FROM mtl_item_catalog_groups_b ' ||
1857: ' CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id ' ||
1858: ' START WITH item_catalog_group_id = attr_chg.item_catalog_group_id ) ' ||
1859: ' AND attr_chg.attr_group_id = assoc.attr_group_id ' ||
1860: ' AND assoc.data_level = ''ITEM_REVISION_LEVEL'' AND assoc.enabled_flag = ''Y''' ||

Line 2033: ' SELECT TO_CHAR(item_catalog_group_id) FROM mtl_item_catalog_groups_b ' ||

2029: ' WHERE attr_chg.change_line_id = change.revised_item_sequence_id ' ||
2030: -- 3710038 check for the attributes in the hierarchy
2031: -- AND to_char(attr_chg.item_catalog_group_id) = assoc.classification_code
2032: ' AND assoc.classification_code IN (' ||
2033: ' SELECT TO_CHAR(item_catalog_group_id) FROM mtl_item_catalog_groups_b ' ||
2034: ' CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id ' ||
2035: ' START WITH item_catalog_group_id = attr_chg.item_catalog_group_id ) ' ||
2036: ' AND attr_chg.attr_group_id = assoc.attr_group_id ' ||
2037: ' AND assoc.data_level = ''ITEM_LEVEL'' AND assoc.object_id = obj.object_id ' ||