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.INVPOPIF dependencies on MTL_ITEM_REVISIONS_B

Line 582: SET revision_id = MTL_ITEM_REVISIONS_B_S.NEXTVAL

578:
579: -- Bug 12758661 : Start
580: -- here populating the revision id so that while defaulting the revision UDAs we need this.
581: UPDATE MTL_ITEM_REVISIONS_INTERFACE
582: SET revision_id = MTL_ITEM_REVISIONS_B_S.NEXTVAL
583: WHERE revision_id IS NULL
584: AND set_process_id = xset_id
585: AND process_flag = 1;
586:

Line 1617: UPDATE mtl_item_revisions_interface MIRI set revision_id = (SELECT R.REVISION_ID FROM MTL_ITEM_REVISIONS_B R WHERE R.REVISION = MIRI.REVISION AND R.ORGANIZATION_ID = MIRI.ORGANIZATION_ID AND R.INVENTORY_ITEM_ID = MIRI.INVENTORY_ITEM_ID )

1613: elsif default_flag = 2 then --Rules ER 11830273, populate revision_id for UPDATE case when default_flag is 2
1614: IF l_inv_debug_level IN(101, 102) THEN
1615: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: POPULATE REVISION_ID TO mtl_item_revisions_interface IF REVISION_ID IS NULL');
1616: END IF;
1617: UPDATE mtl_item_revisions_interface MIRI set revision_id = (SELECT R.REVISION_ID FROM MTL_ITEM_REVISIONS_B R WHERE R.REVISION = MIRI.REVISION AND R.ORGANIZATION_ID = MIRI.ORGANIZATION_ID AND R.INVENTORY_ITEM_ID = MIRI.INVENTORY_ITEM_ID )
1618: where process_flag = 1
1619: AND set_process_id = xset_id
1620: AND (organization_id = org_id or all_org = 1)
1621: AND REVISION_ID IS NULL