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

Line 67: UPDATE MTL_ITEM_REVISIONS_INTERFACE

63: SET SET_PROCESS_ID = -999
64: WHERE PROCESS_FLAG = 1
65: AND TRANSACTION_TYPE in ('CREATE','Create','create');
66:
67: UPDATE MTL_ITEM_REVISIONS_INTERFACE
68: SET SET_PROCESS_ID = -999
69: WHERE PROCESS_FLAG = 1
70: AND TRANSACTION_TYPE in ('CREATE','Create','create');
71:

Line 79: UPDATE MTL_ITEM_REVISIONS_INTERFACE

75: SET SET_PROCESS_ID = -999
76: WHERE PROCESS_FLAG = 1
77: AND TRANSACTION_TYPE in ('UPDATE','Update','update');
78:
79: UPDATE MTL_ITEM_REVISIONS_INTERFACE
80: SET SET_PROCESS_ID = -999
81: WHERE PROCESS_FLAG = 1
82: AND TRANSACTION_TYPE in ('UPDATE','Update','update');
83:

Line 91: UPDATE MTL_ITEM_REVISIONS_INTERFACE

87: SET SET_PROCESS_ID = -999
88: WHERE PROCESS_FLAG = 1
89: AND TRANSACTION_TYPE in ('SYNC','Sync','sync');
90:
91: UPDATE MTL_ITEM_REVISIONS_INTERFACE
92: SET SET_PROCESS_ID = -999
93: WHERE PROCESS_FLAG = 1
94: AND TRANSACTION_TYPE in ('SYNC','Sync','sync');
95:

Line 191: from mtl_item_revisions_interface

187: for update;
188:
189: CURSOR lock_revs IS
190: select rowid
191: from mtl_item_revisions_interface
192: where set_process_id = xset_id
193: for update;
194:
195: CURSOR update_org_id IS

Line 204: from mtl_item_revisions_interface

200: and process_flag = 1;
201:
202: CURSOR update_org_id_revs IS
203: select rowid, transaction_id
204: from mtl_item_revisions_interface
205: where organization_id is NULL
206: and set_process_id = xset_id
207: and process_flag = 1;
208:

Line 221: FROM mtl_item_revisions_interface msii

217: AND ROWNUM = 1;
218:
219: CURSOR c_master_revs(cp_transaction_type VARCHAR2) IS
220: SELECT count(*)
221: FROM mtl_item_revisions_interface msii
222: ,mtl_parameters mp1
223: WHERE set_process_id = xset_id
224: AND transaction_type = cp_transaction_type
225: AND process_flag in (1,2,4)

Line 244: FROM mtl_item_revisions_interface

240: AND ROWNUM = 1;
241:
242: CURSOR c_child_revs(cp_transaction_type VARCHAR2) IS
243: SELECT count(*)
244: FROM mtl_item_revisions_interface
245: WHERE set_process_id = xset_id
246: AND transaction_type = cp_transaction_type
247: AND process_flag in (1,2,4)
248: AND organization_id

Line 262: FROM mtl_item_revisions_interface

258: AND process_flag in (1,4);
259:
260: CURSOR c_interface_revs(cp_transaction_type VARCHAR2) IS
261: SELECT count(*)
262: FROM mtl_item_revisions_interface
263: WHERE set_process_id = xset_id
264: AND transaction_type = cp_transaction_type
265: AND process_flag in (1,4);
266:

Line 313: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_REVISIONS_INTERFACE');

309: AND FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema)
310: THEN
311: IF l_schema IS NOT NULL THEN
312: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_SYSTEM_ITEMS_INTERFACE');
313: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_REVISIONS_INTERFACE');
314: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_DESC_ELEM_VAL_INTERFACE');
315: END IF;
316: END IF;
317:

Line 337: UPDATE mtl_item_revisions_interface

333: ,transaction_id = NVL(transaction_id, MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL)
334: WHERE set_process_id = xset_id
335: AND process_flag IN (1,4);
336:
337: UPDATE mtl_item_revisions_interface
338: SET transaction_type = UPPER(transaction_type)
339: ,request_id = req_id
340: WHERE set_process_id = xset_id
341: AND process_flag IN (1,4);

Line 353: UPDATE mtl_item_revisions_interface

349:
350: -- Rev UPDATE is not supported
351: -- Start: 2808277 Supporting Item Revision Update
352: -- SYNC: IOI to support SYNC operation.
353: UPDATE mtl_item_revisions_interface
354: SET process_flag = -888
355: WHERE ( transaction_type NOT IN ('CREATE', 'UPDATE','SYNC')
356: OR transaction_type IS NULL OR set_process_id >= 900000000000)
357: AND set_process_id = xset_id;

Line 373: update MTL_ITEM_REVISIONS_INTERFACE MIRI

369: where MSII.organization_id is NULL
370: and MSII.set_process_id = xset_id
371: and MSII.process_flag = 1;
372:
373: update MTL_ITEM_REVISIONS_INTERFACE MIRI
374: set miri.template_id =
375: ( select template_id
376: FROM mtl_item_templates_vl
377: WHERE template_name = miri.template_name

Line 385: update MTL_ITEM_REVISIONS_INTERFACE MIRI

381: and miri.set_process_id = xset_id
382: and miri.process_flag = 1;
383:
384:
385: update MTL_ITEM_REVISIONS_INTERFACE MIRI
386: set MIRI.organization_id =
387: ( select MP.organization_id
388: from MTL_PARAMETERS MP
389: where MP.organization_code = MIRI.organization_code

Line 396: update MTL_ITEM_REVISIONS_INTERFACE MIRI

392: and MIRI.set_process_id = xset_id
393: and MIRI.process_flag = 1;
394:
395: --Bug: 3614120 Making sure that revision code is in upper case.
396: update MTL_ITEM_REVISIONS_INTERFACE MIRI
397: set MIRI.REVISION = UPPER(MIRI.REVISION)
398: WHERE MIRI.set_process_id = xset_id
399: AND MIRI.process_flag=1;
400:

Line 437: 'MTL_ITEM_REVISIONS_INTERFACE',

433: request_id,
434: cr.transaction_id,
435: 'INVPOPIF: Invalid Organization ID',
436: 'ORGANIZATION_ID',
437: 'MTL_ITEM_REVISIONS_INTERFACE',
438: 'INV_IOI_ORG_NO_EXIST',
439: err_text);
440: if dumm_status < 0 then
441: raise LOGGING_ERR;

Line 444: UPDATE mtl_item_revisions_interface

440: if dumm_status < 0 then
441: raise LOGGING_ERR;
442: end if;
443:
444: UPDATE mtl_item_revisions_interface
445: SET process_flag = 3
446: WHERE rowid = cr.rowid;
447:
448: END LOOP;

Line 487: UPDATE mtl_item_revisions_interface

483: WHERE transaction_type IN ('CREATE','UPDATE')
484: AND process_flag < 20000
485: AND set_process_id = xset_id;
486:
487: UPDATE mtl_item_revisions_interface
488: SET process_flag = process_flag + 20000
489: WHERE transaction_type IN ('CREATE','UPDATE')
490: AND process_flag < 20000
491: AND set_process_id = xset_id;

Line 510: UPDATE mtl_item_revisions_interface

506: WHERE transaction_type IN ('UPDATE','SYNC') --3018673
507: AND process_flag < 30000
508: AND set_process_id = xset_id;
509:
510: UPDATE mtl_item_revisions_interface
511: SET process_flag = process_flag + 30000
512: WHERE transaction_type IN ('UPDATE','SYNC') --3018673
513: AND process_flag < 30000
514: AND set_process_id = xset_id;

Line 541: UPDATE mtl_item_revisions_interface miri

537: AND not exists (select mp1.organization_id
538: from mtl_parameters mp1
539: where msii.organization_id = mp1.master_organization_id);
540:
541: UPDATE mtl_item_revisions_interface miri
542: SET process_flag = process_flag + 60000
543: WHERE transaction_type = 'CREATE'
544: AND process_flag < 60000
545: AND set_process_id = xset_id

Line 576: UPDATE mtl_item_revisions_interface

572: WHERE transaction_type = 'CREATE'
573: AND process_flag >= 60000
574: AND set_process_id = xset_id;
575:
576: UPDATE mtl_item_revisions_interface
577: SET process_flag = process_flag - 60000
578: WHERE transaction_type = 'CREATE'
579: AND process_flag >= 60000
580: AND set_process_id = xset_id;

Line 612: UPDATE mtl_item_revisions_interface miri

608: AND EXISTS (select mp1.organization_id /*BUG 6158936*/
609: from mtl_parameters mp1
610: where msii.organization_id = mp1.master_organization_id);
611:
612: UPDATE mtl_item_revisions_interface miri
613: SET process_flag = process_flag + 60000
614: WHERE transaction_type = 'CREATE'
615: AND process_flag < 60000
616: AND set_process_id = xset_id

Line 649: UPDATE mtl_item_revisions_interface

645: WHERE transaction_type = 'CREATE'
646: AND process_flag >= 60000
647: AND set_process_id = xset_id;
648:
649: UPDATE mtl_item_revisions_interface
650: SET process_flag = process_flag - 60000
651: WHERE transaction_type = 'CREATE'
652: AND process_flag >= 60000
653: AND set_process_id = xset_id;

Line 696: UPDATE mtl_item_revisions_interface

692: WHERE transaction_type IN ('UPDATE','SYNC') --3018673
693: AND process_flag >= 30000
694: AND set_process_id = xset_id;
695:
696: UPDATE mtl_item_revisions_interface
697: SET process_flag = process_flag - 30000
698: WHERE transaction_type IN ('UPDATE','SYNC') --3018673
699: AND process_flag >= 30000
700: AND set_process_id = xset_id;

Line 714: UPDATE mtl_item_revisions_interface

710: WHERE transaction_type IN ('CREATE','SYNC') --3018673
711: AND process_flag < 30000
712: AND set_process_id = xset_id;
713:
714: UPDATE mtl_item_revisions_interface
715: SET process_flag = process_flag + 30000
716: WHERE transaction_type IN ('CREATE','SYNC') --3018673
717: AND process_flag < 30000
718: AND set_process_id = xset_id;

Line 741: UPDATE mtl_item_revisions_interface miri

737: AND not exists (select mp1.organization_id
738: from mtl_parameters mp1
739: where msii.organization_id = mp1.master_organization_id);
740:
741: UPDATE mtl_item_revisions_interface miri
742: SET process_flag = process_flag + 60000
743: WHERE transaction_type = 'UPDATE'
744: AND process_flag < 60000
745: AND set_process_id = xset_id

Line 773: UPDATE mtl_item_revisions_interface

769: WHERE transaction_type = 'UPDATE'
770: AND process_flag >= 60000
771: AND set_process_id = xset_id;
772:
773: UPDATE mtl_item_revisions_interface
774: SET process_flag = process_flag - 60000
775: WHERE transaction_type = 'UPDATE'
776: AND process_flag >= 60000
777: AND set_process_id = xset_id;

Line 806: UPDATE mtl_item_revisions_interface miri

802: AND not exists (select mp1.organization_id
803: from mtl_parameters mp1
804: where msii.organization_id <> mp1.master_organization_id);
805:
806: UPDATE mtl_item_revisions_interface miri
807: SET process_flag = process_flag + 60000
808: WHERE transaction_type = 'UPDATE'
809: AND process_flag < 60000
810: AND set_process_id = xset_id

Line 840: UPDATE mtl_item_revisions_interface

836: WHERE transaction_type = 'UPDATE'
837: AND process_flag >= 60000
838: AND set_process_id = xset_id;
839:
840: UPDATE mtl_item_revisions_interface
841: SET process_flag = process_flag - 60000
842: WHERE transaction_type = 'UPDATE'
843: AND process_flag >= 60000
844: AND set_process_id = xset_id;

Line 884: UPDATE mtl_item_revisions_interface

880: WHERE transaction_type IN ('CREATE','SYNC') --3018673
881: AND process_flag >= 30000
882: AND set_process_id = xset_id;
883:
884: UPDATE mtl_item_revisions_interface
885: SET process_flag = process_flag - 30000
886: WHERE transaction_type IN ('CREATE','SYNC') --3018673
887: AND process_flag >= 30000
888: AND set_process_id = xset_id;

Line 901: UPDATE mtl_item_revisions_interface

897: WHERE transaction_type IN ('CREATE','UPDATE')
898: AND process_flag >= 20000
899: AND set_process_id = xset_id;
900:
901: UPDATE mtl_item_revisions_interface
902: SET process_flag = process_flag - 20000
903: WHERE transaction_type IN ('CREATE','UPDATE')
904: AND process_flag >= 20000
905: AND set_process_id = xset_id;

Line 1135: FROM mtl_item_revisions_interface mir

1131: ,NVL(mir.CREATED_BY, -1)
1132: ,NVL(mir.LAST_UPDATE_DATE, SYSDATE)
1133: ,NVL(mir.LAST_UPDATED_BY, -1)
1134: ,mir.LAST_UPDATE_LOGIN
1135: FROM mtl_item_revisions_interface mir
1136: WHERE mir.request_id = request_id
1137: and mir.set_process_id = xset_id
1138: and mir.process_flag = 7);
1139:

Line 1840: DELETE FROM MTL_ITEM_REVISIONS_INTERFACE

1836: stmt_num := 2;
1837:
1838:
1839: LOOP
1840: DELETE FROM MTL_ITEM_REVISIONS_INTERFACE
1841: WHERE PROCESS_FLAG = l_process_flag_7
1842: AND set_process_id = xset_id
1843: AND rownum < l_rownum;
1844:

Line 1922: FROM mtl_item_revisions_interface

1918: ,revision_id
1919: ,revision
1920: ,transaction_id
1921: ,transaction_type
1922: FROM mtl_item_revisions_interface
1923: WHERE set_process_id = p_set_id
1924: AND process_flag = 1
1925: AND transaction_type = 'SYNC'
1926: FOR UPDATE OF transaction_type;

Line 1949: FROM mtl_item_revisions

1945: cp_rev_id NUMBER,
1946: cp_revision VARCHAR,
1947: cp_org_id NUMBER) IS
1948: SELECT 1
1949: FROM mtl_item_revisions
1950: WHERE inventory_item_id = cp_item_id
1951: AND (revision_id = cp_rev_id
1952: OR revision = cp_revision)
1953: AND organization_id = cp_org_id ;

Line 2144: UPDATE mtl_item_revisions_interface

2140: CLOSE c_revision_exists;
2141: l_rev_exist := NVL(l_rev_exist,0);
2142:
2143: IF l_rev_exist = 1 THEN
2144: UPDATE mtl_item_revisions_interface
2145: SET transaction_type = 'UPDATE'
2146: WHERE rowid = revision_record.rowid;
2147: ELSE
2148: UPDATE mtl_item_revisions_interface

Line 2148: UPDATE mtl_item_revisions_interface

2144: UPDATE mtl_item_revisions_interface
2145: SET transaction_type = 'UPDATE'
2146: WHERE rowid = revision_record.rowid;
2147: ELSE
2148: UPDATE mtl_item_revisions_interface
2149: SET transaction_type = 'CREATE'
2150: WHERE rowid = revision_record.rowid;
2151: END IF;
2152: END LOOP;