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 78: UPDATE MTL_ITEM_REVISIONS_INTERFACE

74: SET SET_PROCESS_ID = -999
75: WHERE PROCESS_FLAG = 1
76: AND TRANSACTION_TYPE in ('CREATE','Create','create');
77:
78: UPDATE MTL_ITEM_REVISIONS_INTERFACE
79: SET SET_PROCESS_ID = -999
80: WHERE PROCESS_FLAG = 1
81: AND TRANSACTION_TYPE in ('CREATE','Create','create');
82:

Line 90: UPDATE MTL_ITEM_REVISIONS_INTERFACE

86: SET SET_PROCESS_ID = -999
87: WHERE PROCESS_FLAG = 1
88: AND TRANSACTION_TYPE in ('UPDATE','Update','update');
89:
90: UPDATE MTL_ITEM_REVISIONS_INTERFACE
91: SET SET_PROCESS_ID = -999
92: WHERE PROCESS_FLAG = 1
93: AND TRANSACTION_TYPE in ('UPDATE','Update','update');
94:

Line 102: UPDATE MTL_ITEM_REVISIONS_INTERFACE

98: SET SET_PROCESS_ID = -999
99: WHERE PROCESS_FLAG = 1
100: AND TRANSACTION_TYPE in ('SYNC','Sync','sync');
101:
102: UPDATE MTL_ITEM_REVISIONS_INTERFACE
103: SET SET_PROCESS_ID = -999
104: WHERE PROCESS_FLAG = 1
105: AND TRANSACTION_TYPE in ('SYNC','Sync','sync');
106:

Line 204: from mtl_item_revisions_interface

200: for update;
201:
202: CURSOR lock_revs IS
203: select rowid
204: from mtl_item_revisions_interface
205: where set_process_id = xset_id
206: for update;
207:
208: CURSOR update_org_id IS

Line 217: from mtl_item_revisions_interface

213: and process_flag = 1;
214:
215: CURSOR update_org_id_revs IS
216: select rowid, transaction_id
217: from mtl_item_revisions_interface
218: where organization_id is NULL
219: and set_process_id = xset_id
220: and process_flag = 1;
221:

Line 234: FROM mtl_item_revisions_interface msii

230: AND ROWNUM = 1;
231:
232: CURSOR c_master_revs(cp_transaction_type VARCHAR2) IS
233: SELECT count(*)
234: FROM mtl_item_revisions_interface msii
235: ,mtl_parameters mp1
236: WHERE set_process_id = xset_id
237: AND transaction_type = cp_transaction_type
238: AND process_flag in (1,2,4)

Line 257: FROM mtl_item_revisions_interface

253: AND ROWNUM = 1;
254:
255: CURSOR c_child_revs(cp_transaction_type VARCHAR2) IS
256: SELECT count(*)
257: FROM mtl_item_revisions_interface
258: WHERE set_process_id = xset_id
259: AND transaction_type = cp_transaction_type
260: AND process_flag in (1,2,4)
261: AND organization_id

Line 275: FROM mtl_item_revisions_interface

271: AND process_flag in (1,4);
272:
273: CURSOR c_interface_revs(cp_transaction_type VARCHAR2) IS
274: SELECT count(*)
275: FROM mtl_item_revisions_interface
276: WHERE set_process_id = xset_id
277: AND transaction_type = cp_transaction_type
278: AND process_flag in (1,4);
279:

Line 294: from mtl_item_revisions_interface

290:
291: -- added for bug 13430047
292: CURSOR wrong_trans_type_miri IS
293: select rowid, transaction_id
294: from mtl_item_revisions_interface
295: where (transaction_type NOT IN ('CREATE', 'UPDATE','SYNC','ADD','DELETE') --bug13585063,13595665
296: OR transaction_type IS NULL OR set_process_id >= 900000000000)
297: AND set_process_id = xset_id
298: and process_flag = 1;

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

363: for any performance issues we need to gather stats manualy so no need to gather stats in the code.
364: */
365: /*
366: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_SYSTEM_ITEMS_INTERFACE');
367: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_REVISIONS_INTERFACE');
368: */
369: -- Bug 12669091 : End
370: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_DESC_ELEM_VAL_INTERFACE');
371: END IF;

Line 393: UPDATE mtl_item_revisions_interface

389: ,transaction_id = NVL(transaction_id, MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL)
390: WHERE set_process_id = xset_id
391: AND process_flag IN (1,4);
392:
393: UPDATE mtl_item_revisions_interface
394: SET transaction_type = UPPER(transaction_type)
395: ,request_id = req_id
396: WHERE set_process_id = xset_id
397: AND process_flag IN (1,4);

Line 410: UPDATE mtl_item_revisions_interface

406:
407: -- Rev UPDATE is not supported
408: -- Start: 2808277 Supporting Item Revision Update
409: -- SYNC: IOI to support SYNC operation.
410: UPDATE mtl_item_revisions_interface
411: SET process_flag = -888
412: WHERE ( transaction_type NOT IN ('CREATE', 'UPDATE','SYNC')
413: OR transaction_type IS NULL OR set_process_id >= 900000000000)
414: AND set_process_id = xset_id;

Line 443: -- wrong transaction_type in mtl_item_revisions_interface

439: where rowid = cr.rowid ;
440:
441: END LOOP;
442:
443: -- wrong transaction_type in mtl_item_revisions_interface
444: FOR cr IN wrong_trans_type_miri LOOP
445: dumm_status := INVPUOPI.mtl_log_interface_err(
446: -1,
447: user_id,

Line 455: 'mtl_item_revisions_interface',

451: request_id,
452: cr.transaction_id,
453: 'INVPOPIF: Invalid transaction type',
454: 'TRANSACTION_TYPE',
455: 'mtl_item_revisions_interface',
456: 'INV_INT_TRXTYPCODE',
457: err_text);
458: if dumm_status < 0 then
459: raise LOGGING_ERR;

Line 462: update mtl_item_revisions_interface

458: if dumm_status < 0 then
459: raise LOGGING_ERR;
460: end if;
461:
462: update mtl_item_revisions_interface
463: set process_flag = 3
464: where rowid = cr.rowid ;
465: END LOOP;
466: -- Assign missing organization_id from organization_code

Line 478: update MTL_ITEM_REVISIONS_INTERFACE MIRI

474: where MSII.organization_id is NULL
475: and MSII.set_process_id = xset_id
476: and MSII.process_flag = 1;
477:
478: update MTL_ITEM_REVISIONS_INTERFACE MIRI
479: set miri.template_id =
480: ( select template_id
481: FROM mtl_item_templates_vl
482: WHERE template_name = miri.template_name

Line 490: update MTL_ITEM_REVISIONS_INTERFACE MIRI

486: and miri.set_process_id = xset_id
487: and miri.process_flag = 1;
488:
489:
490: update MTL_ITEM_REVISIONS_INTERFACE MIRI
491: set MIRI.organization_id =
492: ( select MP.organization_id
493: from MTL_PARAMETERS MP
494: where MP.organization_code = MIRI.organization_code

Line 501: update MTL_ITEM_REVISIONS_INTERFACE MIRI

497: and MIRI.set_process_id = xset_id
498: and MIRI.process_flag = 1;
499:
500: --Bug: 3614120 Making sure that revision code is in upper case.
501: update MTL_ITEM_REVISIONS_INTERFACE MIRI
502: set MIRI.REVISION = UPPER(MIRI.REVISION)
503: WHERE MIRI.set_process_id = xset_id
504: AND MIRI.process_flag=1;
505:

Line 542: 'MTL_ITEM_REVISIONS_INTERFACE',

538: request_id,
539: cr.transaction_id,
540: 'INVPOPIF: Invalid Organization ID',
541: 'ORGANIZATION_ID',
542: 'MTL_ITEM_REVISIONS_INTERFACE',
543: 'INV_IOI_ORG_NO_EXIST',
544: err_text);
545: if dumm_status < 0 then
546: raise LOGGING_ERR;

Line 549: UPDATE mtl_item_revisions_interface

545: if dumm_status < 0 then
546: raise LOGGING_ERR;
547: end if;
548:
549: UPDATE mtl_item_revisions_interface
550: SET process_flag = 3
551: WHERE rowid = cr.rowid;
552:
553: END LOOP;

Line 581: UPDATE MTL_ITEM_REVISIONS_INTERFACE

577: AND process_flag = 1;
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;

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 654: UPDATE mtl_item_revisions_interface

650: WHERE transaction_type IN ('CREATE','UPDATE')
651: AND process_flag < 20000
652: AND set_process_id = xset_id;
653:
654: UPDATE mtl_item_revisions_interface
655: SET process_flag = process_flag + 20000
656: WHERE transaction_type IN ('CREATE','UPDATE')
657: AND process_flag < 20000
658: AND set_process_id = xset_id;

Line 678: UPDATE mtl_item_revisions_interface

674: WHERE transaction_type IN ('UPDATE','SYNC') --3018673
675: AND process_flag < 30000
676: AND set_process_id = xset_id;
677:
678: UPDATE mtl_item_revisions_interface
679: SET process_flag = process_flag + 30000
680: WHERE transaction_type IN ('UPDATE','SYNC') --3018673
681: AND process_flag < 30000
682: AND set_process_id = xset_id;

Line 710: UPDATE mtl_item_revisions_interface miri

706: AND not exists (select mp1.organization_id
707: from mtl_parameters mp1
708: where msii.organization_id = mp1.master_organization_id);
709:
710: UPDATE mtl_item_revisions_interface miri
711: SET process_flag = process_flag + 60000
712: WHERE transaction_type = 'CREATE'
713: AND process_flag < 60000
714: AND set_process_id = xset_id

Line 745: UPDATE mtl_item_revisions_interface

741: WHERE transaction_type = 'CREATE'
742: AND process_flag >= 60000
743: AND set_process_id = xset_id;
744:
745: UPDATE mtl_item_revisions_interface
746: SET process_flag = process_flag - 60000
747: WHERE transaction_type = 'CREATE'
748: AND process_flag >= 60000
749: AND set_process_id = xset_id;

Line 782: UPDATE mtl_item_revisions_interface miri

778: AND EXISTS (select mp1.organization_id /*BUG 6158936*/
779: from mtl_parameters mp1
780: where msii.organization_id = mp1.master_organization_id);
781:
782: UPDATE mtl_item_revisions_interface miri
783: SET process_flag = process_flag + 60000
784: WHERE transaction_type = 'CREATE'
785: AND process_flag < 60000
786: AND set_process_id = xset_id

Line 819: UPDATE mtl_item_revisions_interface

815: WHERE transaction_type = 'CREATE'
816: AND process_flag >= 60000
817: AND set_process_id = xset_id;
818:
819: UPDATE mtl_item_revisions_interface
820: SET process_flag = process_flag - 60000
821: WHERE transaction_type = 'CREATE'
822: AND process_flag >= 60000
823: AND set_process_id = xset_id;

Line 866: UPDATE mtl_item_revisions_interface

862: WHERE transaction_type IN ('UPDATE','SYNC') --3018673
863: AND process_flag >= 30000
864: AND set_process_id = xset_id;
865:
866: UPDATE mtl_item_revisions_interface
867: SET process_flag = process_flag - 30000
868: WHERE transaction_type IN ('UPDATE','SYNC') --3018673
869: AND process_flag >= 30000
870: AND set_process_id = xset_id;

Line 885: UPDATE mtl_item_revisions_interface

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

Line 913: UPDATE mtl_item_revisions_interface miri

909: AND not exists (select mp1.organization_id
910: from mtl_parameters mp1
911: where msii.organization_id = mp1.master_organization_id);
912:
913: UPDATE mtl_item_revisions_interface miri
914: SET process_flag = process_flag + 60000
915: WHERE transaction_type = 'UPDATE'
916: AND process_flag < 60000
917: AND set_process_id = xset_id

Line 945: UPDATE mtl_item_revisions_interface

941: WHERE transaction_type = 'UPDATE'
942: AND process_flag >= 60000
943: AND set_process_id = xset_id;
944:
945: UPDATE mtl_item_revisions_interface
946: SET process_flag = process_flag - 60000
947: WHERE transaction_type = 'UPDATE'
948: AND process_flag >= 60000
949: AND set_process_id = xset_id;

Line 979: UPDATE mtl_item_revisions_interface miri

975: AND not exists (select mp1.organization_id
976: from mtl_parameters mp1
977: where msii.organization_id <> mp1.master_organization_id);
978:
979: UPDATE mtl_item_revisions_interface miri
980: SET process_flag = process_flag + 60000
981: WHERE transaction_type = 'UPDATE'
982: AND process_flag < 60000
983: AND set_process_id = xset_id

Line 1013: UPDATE mtl_item_revisions_interface

1009: WHERE transaction_type = 'UPDATE'
1010: AND process_flag >= 60000
1011: AND set_process_id = xset_id;
1012:
1013: UPDATE mtl_item_revisions_interface
1014: SET process_flag = process_flag - 60000
1015: WHERE transaction_type = 'UPDATE'
1016: AND process_flag >= 60000
1017: AND set_process_id = xset_id;

Line 1057: UPDATE mtl_item_revisions_interface

1053: WHERE transaction_type IN ('CREATE','SYNC') --3018673
1054: AND process_flag >= 30000
1055: AND set_process_id = xset_id;
1056:
1057: UPDATE mtl_item_revisions_interface
1058: SET process_flag = process_flag - 30000
1059: WHERE transaction_type IN ('CREATE','SYNC') --3018673
1060: AND process_flag >= 30000
1061: AND set_process_id = xset_id;

Line 1074: UPDATE mtl_item_revisions_interface

1070: WHERE transaction_type IN ('CREATE','UPDATE')
1071: AND process_flag >= 20000
1072: AND set_process_id = xset_id;
1073:
1074: UPDATE mtl_item_revisions_interface
1075: SET process_flag = process_flag - 20000
1076: WHERE transaction_type IN ('CREATE','UPDATE')
1077: AND process_flag >= 20000
1078: AND set_process_id = xset_id;

Line 1308: FROM mtl_item_revisions_interface mir

1304: ,NVL(mir.CREATED_BY, -1)
1305: ,NVL(mir.LAST_UPDATE_DATE, SYSDATE)
1306: ,NVL(mir.LAST_UPDATED_BY, -1)
1307: ,mir.LAST_UPDATE_LOGIN
1308: FROM mtl_item_revisions_interface mir
1309: WHERE mir.request_id = request_id
1310: and mir.set_process_id = xset_id
1311: and mir.process_flag = 7);
1312:

Line 1615: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: POPULATE REVISION_ID TO mtl_item_revisions_interface IF REVISION_ID IS NULL');

1611: err_text => err_msg,
1612: xset_id => xset_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

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

Line 2064: DELETE FROM MTL_ITEM_REVISIONS_INTERFACE

2060: stmt_num := 2;
2061:
2062:
2063: LOOP
2064: DELETE FROM MTL_ITEM_REVISIONS_INTERFACE
2065: WHERE PROCESS_FLAG = l_process_flag_7
2066: AND set_process_id = xset_id
2067: AND rownum < l_rownum;
2068:

Line 2146: FROM mtl_item_revisions_interface

2142: ,revision_id
2143: ,revision
2144: ,transaction_id
2145: ,transaction_type
2146: FROM mtl_item_revisions_interface
2147: WHERE set_process_id = p_set_id
2148: AND process_flag = 1
2149: AND transaction_type = 'SYNC'
2150: FOR UPDATE OF transaction_type;

Line 2173: FROM mtl_item_revisions

2169: cp_rev_id NUMBER,
2170: cp_revision VARCHAR,
2171: cp_org_id NUMBER) IS
2172: SELECT 1
2173: FROM mtl_item_revisions
2174: WHERE inventory_item_id = cp_item_id
2175: AND (revision_id = cp_rev_id
2176: OR revision = cp_revision)
2177: AND organization_id = cp_org_id ;

Line 2368: UPDATE mtl_item_revisions_interface

2364: CLOSE c_revision_exists;
2365: l_rev_exist := NVL(l_rev_exist,0);
2366:
2367: IF l_rev_exist = 1 THEN
2368: UPDATE mtl_item_revisions_interface
2369: SET transaction_type = 'UPDATE'
2370: WHERE rowid = revision_record.rowid;
2371: ELSE
2372: UPDATE mtl_item_revisions_interface

Line 2372: UPDATE mtl_item_revisions_interface

2368: UPDATE mtl_item_revisions_interface
2369: SET transaction_type = 'UPDATE'
2370: WHERE rowid = revision_record.rowid;
2371: ELSE
2372: UPDATE mtl_item_revisions_interface
2373: SET transaction_type = 'CREATE'
2374: WHERE rowid = revision_record.rowid;
2375: END IF;
2376: END LOOP;