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.INVNIRIS dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 42: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,

38: -- micb.NEW_ITEM_REQ_CHANGE_TYPE_ID,
39: mp.ORGANIZATION_CODE,
40: mp.MASTER_ORGANIZATION_ID,
41: msii.TRANSACTION_TYPE
42: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
43: --MTL_ITEM_CATALOG_GROUPS_B micb,
44: MTL_PARAMETERS mp
45: WHERE ( (msii.organization_id + 0 = org_id) OR (all_Org = 1) )
46: AND msii.process_flag = cp_process_flag

Line 124: UPDATE mtl_system_items_interface

120: l_item_approval_status := 'N';
121: END;
122:
123: IF l_item_approval_status <> 'A' THEN
124: UPDATE mtl_system_items_interface
125: SET process_flag = 3
126: WHERE CURRENT OF c_get_processed_records;
127:
128: l_dumm_status := INVPUOPI.mtl_log_interface_err (

Line 138: 'MTL_SYSTEM_ITEMS_INTERFACE',

134: request_id,
135: cur.transaction_id,
136: 'Unapproved Item cannot be assigned to a child org',
137: 'APPROVAL_STATUS',
138: 'MTL_SYSTEM_ITEMS_INTERFACE',
139: 'INV_NIR_NO_APPROVE',
140: l_err_text);
141: IF l_dumm_status < 0 then
142: raise LOGGING_ERR;

Line 155: UPDATE MTL_SYSTEM_ITEMS_INTERFACE I

151: OR((cur.TRANSACTION_TYPE = 'UPDATE') AND (NVL(l_item_approval_status, 'A') <> 'A')))
152: THEN
153: l_nir_rec_exists := true;
154:
155: UPDATE MTL_SYSTEM_ITEMS_INTERFACE I
156: SET I.SET_PROCESS_ID = I.SET_PROCESS_ID + 3000000000000,
157: I.ENG_ITEM_FLAG = 'Y', --Bug 5519768
158: I.SUMMARY_FLAG = 'Y',
159: I.ENABLED_FLAG = 'Y',

Line 501: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

497: END IF;
498:
499: IF (status = 0) THEN
500:
501: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
502: --SET PROCESS_FLAG = 4 BUG 7255713
503: SET PROCESS_FLAG = 44 -- added for bug 7255713-ccsingh
504: WHERE PROCESS_FLAG = 41
505: AND ((SET_PROCESS_ID >= 3000000000000) OR (SET_PROCESS_ID = 3000000000000-999));

Line 527: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

523: END IF ;
524:
525: IF (status = 0) THEN
526:
527: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
528: SET PROCESS_FLAG = 4
529: WHERE PROCESS_FLAG = 45 --Changed the value from 41 to 45 as we need to validate primary attributes
530: AND ((SET_PROCESS_ID >= 3000000000000) OR (SET_PROCESS_ID = 3000000000000-999));
531:

Line 579: UPDATE mtl_system_items_interface

575: IF l_inv_debug_level IN(101, 102) THEN
576: INVPUTLI.info('INVNIRIS.mtl_pr_validate_item: done with status :'||status);
577: END IF;
578:
579: UPDATE mtl_system_items_interface
580: SET SET_PROCESS_ID = xset_id
581: WHERE ((SET_PROCESS_ID >= 3000000000000) OR (SET_PROCESS_ID = 3000000000000-999));
582:
583: UPDATE mtl_item_revisions_interface

Line 639: FROM mtl_system_items_interface msi,

635: ,msb.eng_item_flag -- 5306178
636: ,msb.style_item_flag
637: ,msb.style_item_id
638: ,msb.gdsn_outbound_enabled_flag
639: FROM mtl_system_items_interface msi,
640: mtl_system_items_b msb
641: WHERE msi.process_flag = 1
642: AND msi.set_process_id = xset_id
643: AND ((msi.organization_id = org_id) or (all_org = 1))

Line 652: FROM mtl_system_items_interface msi

648:
649: CURSOR c_check_attributes_policy IS
650: SELECT msi.rowid
651: ,msi.*
652: FROM mtl_system_items_interface msi
653: WHERE msi.process_flag = 1
654: AND msi.set_process_id = xset_id
655: AND ((msi.organization_id = org_id) or (all_org = 1))
656: AND msi.transaction_type = 'UPDATE';

Line 668: FROM mtl_system_items_interface msi

664:
665:
666: cursor c_hold_status_codes is
667: SELECT msi.inventory_item_status_code, msi.eng_item_flag, msi.rowid
668: FROM mtl_system_items_interface msi
669: WHERE msi.process_flag = 1
670: AND msi.set_process_id = xset_id
671: AND ((msi.organization_id = org_id) or (all_org = 1))
672: AND msi.transaction_type = 'UPDATE';

Line 721: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

717:
718:
719: BEGIN
720:
721: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
722: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
723: WHERE transaction_id IS NULL
724: AND set_process_id = xset_id;
725:

Line 722: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

718:
719: BEGIN
720:
721: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
722: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
723: WHERE transaction_id IS NULL
724: AND set_process_id = xset_id;
725:
726: --Assign Item Id and apply template.

Line 773: UPDATE mtl_system_items_interface

769: OPEN c_hold_status_codes;
770:
771: --Default certain basic attributes which are required for policy check.
772: FOR cur IN c_populate_values LOOP
773: UPDATE mtl_system_items_interface
774: SET lifecycle_id = DECODE(lifecycle_id,NULL,cur.lifecycle_id,-999999,NULL,lifecycle_id)
775: ,current_phase_id = DECODE(current_phase_id,NULL,cur.current_phase_id,-999999,NULL,current_phase_id)
776: ,item_catalog_group_id = DECODE(item_catalog_group_id,NULL,cur.item_catalog_group_id,-999999, NULL,item_catalog_group_id)
777: ,inventory_item_status_code = NVL(inventory_item_status_code,cur.inventory_item_status_code)

Line 805: UPDATE mtl_system_items_interface

801: LOOP
802: FETCH c_hold_status_codes
803: INTO l_status_code, l_eng_item_flag, l_rowid ;
804: EXIT WHEN c_hold_status_codes%NOTFOUND;
805: UPDATE mtl_system_items_interface
806: SET inventory_item_status_code = l_status_code
807: ,eng_item_flag = l_eng_item_flag
808: WHERE rowid = l_rowid;
809: END LOOP;

Line 1307: UPDATE mtl_system_items_interface

1303: l_policy_value := 'CHANGE_ORDER_REQUIRED';
1304: END IF; --cur.current_phase_id is not NULL
1305:
1306: IF l_policy_value = 'NOT_ALLOWED' THEN
1307: UPDATE mtl_system_items_interface
1308: SET process_flag = 3
1309: WHERE rowid = cur.rowid;
1310:
1311: SELECT ATTR_GROUP_DISP_NAME INTO l_attr_grp_name

Line 1347: INSERT INTO mtl_system_items_interface(

1343: --4696529: Insert row into interface table to propogate changes to production.
1344: IF l_msb_rec.inventory_item_status_code <> NVL(cur.inventory_item_status_code,l_msb_rec.inventory_item_status_code)
1345: OR l_msb_rec.description <> NVL(cur.description,l_msb_rec.description)
1346: THEN
1347: INSERT INTO mtl_system_items_interface(
1348: organization_id
1349: ,inventory_item_id
1350: ,process_flag
1351: ,set_process_id

Line 1364: ,mtl_system_items_interface_s.nextval

1360: ,cur.inventory_item_id
1361: ,1
1362: ,cur.set_process_id
1363: ,'UPDATE'
1364: ,mtl_system_items_interface_s.nextval
1365: ,cur.inventory_item_status_code --Bug 5383744
1366: ,cur.allowed_units_lookup_code
1367: ,cur.item_type
1368: ,NVL(cur.description,l_msb_rec.description));

Line 1371: UPDATE mtl_system_items_interface

1367: ,cur.item_type
1368: ,NVL(cur.description,l_msb_rec.description));
1369: END IF;
1370:
1371: UPDATE mtl_system_items_interface
1372: SET process_flag = 5,
1373: --bug 5383744
1374: inventory_item_status_code = NVL(cur.inventory_item_status_code,l_msb_rec.inventory_item_status_code)
1375: WHERE rowid = cur.rowid;

Line 1714: UPDATE mtl_system_items_interface msi

1710: l_desc_status_change := FALSE;
1711: END IF;
1712:
1713: IF l_values_provided THEN
1714: UPDATE mtl_system_items_interface msi
1715: SET process_flag = 5,
1716: --Bug 5383744
1717: inventory_item_status_code = NVL(cur.inventory_item_status_code,l_msb_rec.inventory_item_status_code)
1718: WHERE rowid = cur.rowid;

Line 1721: INSERT INTO mtl_system_items_interface(

1717: inventory_item_status_code = NVL(cur.inventory_item_status_code,l_msb_rec.inventory_item_status_code)
1718: WHERE rowid = cur.rowid;
1719:
1720: IF l_desc_status_change THEN
1721: INSERT INTO mtl_system_items_interface(
1722: organization_id
1723: ,inventory_item_id
1724: ,process_flag
1725: ,set_process_id

Line 1738: ,mtl_system_items_interface_s.nextval

1734: ,cur.inventory_item_id
1735: ,1
1736: ,cur.set_process_id
1737: ,'UPDATE'
1738: ,mtl_system_items_interface_s.nextval
1739: ,cur.inventory_item_status_code --Bug 5383744
1740: ,cur.allowed_units_lookup_code
1741: ,cur.item_type
1742: ,NVL(cur.description,l_msb_rec.description));

Line 1747: UPDATE mtl_system_items_interface msi

1743: END IF;
1744:
1745: ELSIF NOT l_desc_status_change THEN
1746:
1747: UPDATE mtl_system_items_interface msi
1748: SET process_flag = 7
1749: WHERE rowid = cur.rowid;
1750:
1751: END IF; -- IF l_values_provided THEN