DBA Data[Home] [Help]

APPS.EGO_INV_ITEM_CATALOG_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 711: FROM mtl_item_catalog_groups_b

707: CURSOR c_lost_catalogs(cp_old_id NUMBER,
708: cp_new_id NUMBER) IS
709: SELECT item_catalog_group_id
710: FROM ((SELECT item_catalog_group_id
711: FROM mtl_item_catalog_groups_b
712: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
713: START WITH item_catalog_group_id = cp_old_id)
714: MINUS
715: (SELECT item_catalog_group_id

Line 716: FROM mtl_item_catalog_groups_b

712: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
713: START WITH item_catalog_group_id = cp_old_id)
714: MINUS
715: (SELECT item_catalog_group_id
716: FROM mtl_item_catalog_groups_b
717: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
718: START WITH item_catalog_group_id = cp_new_id));
719:
720: */

Line 795: FROM mtl_item_catalog_groups_b

791: FROM ego_obj_attr_grp_assocs_v
792: WHERE attr_group_id = ext.attr_group_id
793: AND classification_code IN
794: (SELECT to_char(item_catalog_group_id)
795: FROM mtl_item_catalog_groups_b
796: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
797: START WITH item_catalog_group_id = p_catalog_group_id))
798: AND NOT EXISTS (SELECT NULL
799: FROM ego_obj_attr_grp_assocs_v

Line 803: FROM mtl_item_catalog_groups_b

799: FROM ego_obj_attr_grp_assocs_v
800: WHERE attr_group_id = ext.attr_group_id
801: AND classification_code IN
802: (SELECT to_char(item_catalog_group_id)
803: FROM mtl_item_catalog_groups_b
804: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
805: START WITH item_catalog_group_id = p_new_catalog_group_id));
806:
807: DELETE ego_mtl_sy_items_ext_tl extl

Line 814: FROM mtl_item_catalog_groups_b

810: FROM ego_obj_attr_grp_assocs_v
811: WHERE attr_group_id = extl.attr_group_id
812: AND classification_code IN
813: (SELECT to_char(item_catalog_group_id)
814: FROM mtl_item_catalog_groups_b
815: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
816: START WITH item_catalog_group_id = p_catalog_group_id))
817: AND NOT EXISTS (SELECT NULL
818: FROM ego_obj_attr_grp_assocs_v

Line 822: FROM mtl_item_catalog_groups_b

818: FROM ego_obj_attr_grp_assocs_v
819: WHERE attr_group_id = extl.attr_group_id
820: AND classification_code IN
821: (SELECT to_char(item_catalog_group_id)
822: FROM mtl_item_catalog_groups_b
823: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
824: START WITH item_catalog_group_id = p_new_catalog_group_id));
825:
826: --Update valid AG to point to new catalog group

Line 844: FROM mtl_item_catalog_groups_b

840: FROM ego_objtype_attach_cats
841: WHERE attach_category_id = docs.category_id
842: AND classification_code IN
843: (SELECT to_char(item_catalog_group_id)
844: FROM mtl_item_catalog_groups_b
845: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
846: START WITH item_catalog_group_id = p_catalog_group_id))
847: AND NOT EXISTS (SELECT NULL
848: FROM ego_objtype_attach_cats

Line 852: FROM mtl_item_catalog_groups_b

848: FROM ego_objtype_attach_cats
849: WHERE attach_category_id = docs.category_id
850: AND classification_code IN
851: (SELECT to_char(item_catalog_group_id)
852: FROM mtl_item_catalog_groups_b
853: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
854: START WITH item_catalog_group_id = p_new_catalog_group_id));
855:
856: -- END LOOP;

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

1774: ' WHERE attr_chg.change_line_id = change.revised_item_sequence_id ' ||
1775: -- 3710038 check for the attributes in the hierarchy
1776: -- AND to_char(attr_chg.item_catalog_group_id) = assoc.classification_code
1777: ' AND assoc.classification_code IN ( ' ||
1778: ' SELECT TO_CHAR(item_catalog_group_id) FROM mtl_item_catalog_groups_b ' ||
1779: ' CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id ' ||
1780: ' START WITH item_catalog_group_id = attr_chg.item_catalog_group_id ) ' ||
1781: ' AND attr_chg.attr_group_id = assoc.attr_group_id ' ||
1782: ' AND assoc.data_level = ''ITEM_REVISION_LEVEL'' AND assoc.enabled_flag = ''Y''' ||

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

1947: ' WHERE attr_chg.change_line_id = change.revised_item_sequence_id ' ||
1948: -- 3710038 check for the attributes in the hierarchy
1949: -- AND to_char(attr_chg.item_catalog_group_id) = assoc.classification_code
1950: ' AND assoc.classification_code IN (' ||
1951: ' SELECT TO_CHAR(item_catalog_group_id) FROM mtl_item_catalog_groups_b ' ||
1952: ' CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id ' ||
1953: ' START WITH item_catalog_group_id = attr_chg.item_catalog_group_id ) ' ||
1954: ' AND attr_chg.attr_group_id = assoc.attr_group_id ' ||
1955: ' AND assoc.data_level = ''ITEM_LEVEL'' AND assoc.object_id = obj.object_id ' ||