DBA Data[Home] [Help]

APPS.EGO_INV_ITEM_CATALOG_PVT dependencies on EGO_MTL_SY_ITEMS_EXT_TL

Line 807: DELETE ego_mtl_sy_items_ext_tl extl

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
808: WHERE inventory_item_id = p_inventory_item_id
809: AND EXISTS (SELECT NULL
810: FROM ego_obj_attr_grp_assocs_v
811: WHERE attr_group_id = extl.attr_group_id

Line 831: UPDATE ego_mtl_sy_items_ext_tl

827: UPDATE ego_mtl_sy_items_ext_b
828: SET item_catalog_group_id = p_new_catalog_group_id
829: WHERE inventory_item_id = p_inventory_item_id;
830:
831: UPDATE ego_mtl_sy_items_ext_tl
832: SET item_catalog_group_id = p_new_catalog_group_id
833: WHERE inventory_item_id = p_inventory_item_id;
834:
835: --Delete attachments which doesnt fall under new catalog hierarchy.