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_STYLE_SKU_ITEM_PVT dependencies on MTL_ITEM_CATEGORIES

Line 978: INSERT INTO MTL_ITEM_CATEGORIES_INTERFACE

974: ,x_msg_data OUT NOCOPY VARCHAR2)
975: IS
976: l_ss_id NUMBER := EGO_IMPORT_PVT.G_PDH_SOURCE_SYSTEM_ID;
977: BEGIN
978: INSERT INTO MTL_ITEM_CATEGORIES_INTERFACE
979: ( SET_PROCESS_ID,
980: PROCESS_FLAG,
981: TRANSACTION_TYPE,
982: INVENTORY_ITEM_ID,

Line 1003: AND NOT EXISTS (SELECT NULL FROM MTL_ITEM_CATEGORIES mic

999: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp
1000: WHERE msib.STYLE_ITEM_ID = p_style_item_id
1001: AND msib.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
1002: AND mp.ORGANIZATION_ID = p_organization_id
1003: AND NOT EXISTS (SELECT NULL FROM MTL_ITEM_CATEGORIES mic
1004: WHERE mic.INVENTORY_ITEM_ID = msib.INVENTORY_ITEM_ID
1005: AND mic.ORGANIZATION_ID = p_organization_id
1006: AND mic.CATEGORY_SET_ID = p_category_set_id
1007: AND mic.CATEGORY_ID = p_category_id