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.INVPVALI dependencies on MTL_ITEM_REVISIONS_B_S

Line 304: SELECT MTL_ITEM_REVISIONS_B_S.CURRVAL

300: l_revid_error := FALSE;
301: IF cr.transaction_type ='CREATE' AND cr.revision_id IS NOT NULL THEN
302: /* Bug 7513461*/
303: BEGIN
304: SELECT MTL_ITEM_REVISIONS_B_S.CURRVAL
305: INTO l_revision_id FROM DUAL;
306: EXCEPTION
307: WHEN currval_not_def THEN
308: SELECT MTL_ITEM_REVISIONS_B_S.NEXTVAL

Line 308: SELECT MTL_ITEM_REVISIONS_B_S.NEXTVAL

304: SELECT MTL_ITEM_REVISIONS_B_S.CURRVAL
305: INTO l_revision_id FROM DUAL;
306: EXCEPTION
307: WHEN currval_not_def THEN
308: SELECT MTL_ITEM_REVISIONS_B_S.NEXTVAL
309: INTO l_revision_id FROM DUAL;
310: WHEN OTHERS THEN
311: l_revision_id := cr.revision_id - 1;
312: END;

Line 1086: revision_id = NVL(revision_id,MTL_ITEM_REVISIONS_B_S.NEXTVAL) --2808277

1082:
1083: update mtl_item_revisions_interface
1084: set process_flag = l_process_flag_4,
1085: revision_label = NVL(revision_label,revision),
1086: revision_id = NVL(revision_id,MTL_ITEM_REVISIONS_B_S.NEXTVAL) --2808277
1087: where process_flag = l_process_flag_2
1088: and set_process_id = xset_id
1089: and (organization_id = org_id or all_org = l_all_org);
1090: