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 EGO_MTL_SY_ITEMS_EXT_B

Line 827: DELETE ego_mtl_sy_items_ext_b ext

823: -- FOR catalog_record IN c_lost_catalogs(p_catalog_group_id,p_new_catalog_group_id)
824: -- LOOP
825:
826: --Delete AG which doesnt fall under new catalog hierarchy.
827: DELETE ego_mtl_sy_items_ext_b ext
828: WHERE inventory_item_id = p_inventory_item_id
829: AND organization_id IN (SELECT organization_id FROM mtl_parameters WHERE master_organization_id=p_organization_id) /* Changed WHERE clause for the Bug 9094912 */
830: AND EXISTS (SELECT NULL
831: FROM ego_obj_attr_grp_assocs_v

Line 847: /* Fix for Bug 10404086- If there are no recs in ego_mtl_sy_items_ext_b ,

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 ,
848: do not run delete on ego_mtl_sy_items_ext_tl.*/
849: IF(SQL%ROWCOUNT > 0) THEN
850: DELETE ego_mtl_sy_items_ext_tl extl
851: WHERE inventory_item_id = p_inventory_item_id

Line 872: UPDATE ego_mtl_sy_items_ext_b

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:
871: --Update valid AG to point to new catalog group
872: UPDATE ego_mtl_sy_items_ext_b
873: SET item_catalog_group_id = p_new_catalog_group_id
874: -- For bug 13473691
875: ,last_update_date = l_sysdate
876: ,last_updated_by = l_user_id

Line 881: /* Fix for Bug 10404086- If there are no recs in ego_mtl_sy_items_ext_b ,

877: ,last_update_login = l_login_id
878: WHERE inventory_item_id = p_inventory_item_id
879: AND organization_id IN (SELECT organization_id FROM mtl_parameters WHERE master_organization_id=p_organization_id); /* Changed WHERE clause for the Bug 9094912 */
880:
881: /* Fix for Bug 10404086- If there are no recs in ego_mtl_sy_items_ext_b ,
882: do not run update on ego_mtl_sy_items_ext_tl.*/
883: IF(SQL%ROWCOUNT > 0) THEN
884: UPDATE ego_mtl_sy_items_ext_tl
885: SET item_catalog_group_id = p_new_catalog_group_id