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_RELATED_ITEMS_INTERFACE

Line 1173: from mtl_related_items_interface rii,

1169: prg_appid, /* program_application_id */
1170: prg_id, /* program_id */
1171: SYSDATE, /* program_update_date */
1172: rii.organization_id
1173: from mtl_related_items_interface rii,
1174: mtl_system_items_interface si
1175: where rii.inventory_item_id = si.inventory_item_id
1176: and rii.organization_id = si.organization_id
1177: and rii.related_item_id is not NULL

Line 1220: from mtl_related_items_interface rii

1216: mtl_system_items_interface si
1217: where ri.inventory_item_id = si.copy_item_id
1218: and ri.organization_id = si.organization_id
1219: and not exists ( select NULL
1220: from mtl_related_items_interface rii
1221: where rii.inventory_item_id = si.inventory_item_id
1222: and rii.organization_id = si.organization_id
1223: and rii.related_item_id is not NULL
1224: and rii.relationship_type_id is not NULL

Line 1625: table_name := 'MTL_RELATED_ITEMS_INTERFACE';

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'))));
1624:
1625: table_name := 'MTL_RELATED_ITEMS_INTERFACE';
1626: delete from MTL_RELATED_ITEMS_INTERFACE ri
1627: where ri.rowid in ( select ri2.rowid
1628: from MTL_RELATED_ITEMS_INTERFACE ri2,
1629: MTL_SYSTEM_ITEMS_INTERFACE si

Line 1626: delete from MTL_RELATED_ITEMS_INTERFACE ri

1622: and si.organization_id = ci2.organization_id
1623: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1624:
1625: table_name := 'MTL_RELATED_ITEMS_INTERFACE';
1626: delete from MTL_RELATED_ITEMS_INTERFACE ri
1627: where ri.rowid in ( select ri2.rowid
1628: from MTL_RELATED_ITEMS_INTERFACE ri2,
1629: MTL_SYSTEM_ITEMS_INTERFACE si
1630: where si.inventory_item_id = ri2.inventory_item_id

Line 1628: from MTL_RELATED_ITEMS_INTERFACE ri2,

1624:
1625: table_name := 'MTL_RELATED_ITEMS_INTERFACE';
1626: delete from MTL_RELATED_ITEMS_INTERFACE ri
1627: where ri.rowid in ( select ri2.rowid
1628: from MTL_RELATED_ITEMS_INTERFACE ri2,
1629: MTL_SYSTEM_ITEMS_INTERFACE si
1630: where si.inventory_item_id = ri2.inventory_item_id
1631: and si.organization_id = ri2.organization_id
1632: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));