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.INVPPRCI dependencies on MTL_ITEM_CATEGORIES_INTERFACE

Line 1078: mtl_item_categories_interface ici,

1074: SYSDATE, /* program_update_date */
1075: MP1.organization_id
1076: from MTL_PARAMETERS MP1,
1077: MTL_PARAMETERS MP2,
1078: mtl_item_categories_interface ici,
1079: mtl_system_items_interface si
1080: where si.inventory_item_id = ici.inventory_item_id
1081: and si.organization_id = ici.organization_id
1082: and ici.category_set_id is not NULL

Line 1128: from mtl_item_categories_interface ici

1124: where si.copy_item_id = ic.inventory_item_id
1125: and si.organization_id = ic.organization_id
1126: and MP2.organization_id = si.organization_id
1127: and not exists ( select NULL
1128: from mtl_item_categories_interface ici
1129: where ici.inventory_item_id = si.inventory_item_id
1130: and ici.organization_id = si.organization_id
1131: and ici.category_set_id is not NULL
1132: and ici.category_id is not NULL)

Line 1616: table_name := 'MTL_ITEM_CATEGORIES_INTERFACE';

1612: MTL_SYSTEM_ITEMS_INTERFACE si
1613: where si.inventory_item_id = di2.inventory_item_id
1614: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1615:
1616: table_name := 'MTL_ITEM_CATEGORIES_INTERFACE';
1617: delete from MTL_ITEM_CATEGORIES_INTERFACE ci
1618: where ci.rowid in ( select ci2.rowid
1619: from MTL_ITEM_CATEGORIES_INTERFACE ci2,
1620: MTL_SYSTEM_ITEMS_INTERFACE si

Line 1617: delete from MTL_ITEM_CATEGORIES_INTERFACE ci

1613: where si.inventory_item_id = di2.inventory_item_id
1614: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1615:
1616: table_name := 'MTL_ITEM_CATEGORIES_INTERFACE';
1617: delete from MTL_ITEM_CATEGORIES_INTERFACE ci
1618: where ci.rowid in ( select ci2.rowid
1619: from MTL_ITEM_CATEGORIES_INTERFACE ci2,
1620: MTL_SYSTEM_ITEMS_INTERFACE si
1621: where si.inventory_item_id = ci2.inventory_item_id

Line 1619: from MTL_ITEM_CATEGORIES_INTERFACE ci2,

1615:
1616: table_name := 'MTL_ITEM_CATEGORIES_INTERFACE';
1617: delete from MTL_ITEM_CATEGORIES_INTERFACE ci
1618: where ci.rowid in ( select ci2.rowid
1619: from MTL_ITEM_CATEGORIES_INTERFACE ci2,
1620: MTL_SYSTEM_ITEMS_INTERFACE si
1621: where si.inventory_item_id = ci2.inventory_item_id
1622: and si.organization_id = ci2.organization_id
1623: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));