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

Line 24: l_item_approval_status mtl_system_items_b.approval_status%TYPE; --Bug 4418037

20: status NUMBER;
21: l_sysdate DATE ;
22: l_nir_rec_exists BOOLEAN;
23: l_flag_error NUMBER;
24: l_item_approval_status mtl_system_items_b.approval_status%TYPE; --Bug 4418037
25: l_dumm_status NUMBER;
26: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
27: l_err_text VARCHAR2(1000);
28:

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 98: FROM mtl_system_items_b

94:
95: BEGIN
96: SELECT approval_status
97: INTO l_item_approval_status
98: FROM mtl_system_items_b
99: WHERE inventory_item_id = cur.INVENTORY_ITEM_ID
100: AND organization_id = cur.ORGANIZATION_ID;
101: EXCEPTION
102: WHEN OTHERS THEN

Line 113: FROM mtl_system_items_b msi

109:
110: BEGIN
111: SELECT msi.approval_status
112: INTO l_item_approval_status
113: FROM mtl_system_items_b msi
114: WHERE msi.inventory_item_id = cur.inventory_item_id
115: AND msi.organization_id = (SELECT mp.master_organization_id
116: FROM mtl_parameters mp
117: WHERE mp.organization_id = cur.organization_id);

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 640: mtl_system_items_b msb

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))
644: AND msi.transaction_type = 'UPDATE'

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 676: l_msb_rec mtl_system_items%ROWTYPE;

672: AND msi.transaction_type = 'UPDATE';
673:
674: l_process_control VARCHAR2(50) := INV_EGO_REVISION_VALIDATE.Get_Process_Control;
675: l_ret_code NUMBER := 1;
676: l_msb_rec mtl_system_items%ROWTYPE;
677: l_attr_grps VARCHAR2(200);
678: l_eng_object VARCHAR2(10);
679: l_policy_value VARCHAR2(100);
680: l_error_logged NUMBER := 0;

Line 695: l_status_code mtl_system_items_b.inventory_item_status_code%TYPE;

691: l_structure_type_id NUMBER; --5216971
692: l_values_provided BOOLEAN := FALSE;
693: l_desc_status_change BOOLEAN := FALSE;
694: l_rowid ROWID;
695: l_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
696: l_eng_item_flag mtl_system_items_b.eng_item_flag%TYPE;
697:
698: --Bug: 5532737
699: l_attr_grp_name EGO_ATTR_GROUPS_V.ATTR_GROUP_DISP_NAME%TYPE;

Line 696: l_eng_item_flag mtl_system_items_b.eng_item_flag%TYPE;

692: l_values_provided BOOLEAN := FALSE;
693: l_desc_status_change BOOLEAN := FALSE;
694: l_rowid ROWID;
695: l_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
696: l_eng_item_flag mtl_system_items_b.eng_item_flag%TYPE;
697:
698: --Bug: 5532737
699: l_attr_grp_name EGO_ATTR_GROUPS_V.ATTR_GROUP_DISP_NAME%TYPE;
700: l_ch_policy_found BOOLEAN := FALSE;

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 836: FROM mtl_system_items

832: l_Err_Text := NULL;
833: l_error_logged := 0;
834:
835: SELECT * INTO l_msb_rec
836: FROM mtl_system_items
837: WHERE inventory_item_id = cur.inventory_item_id
838: AND organization_id = cur.organization_id;
839:
840: --5367962 Check for attribute changes if:

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 1398: FROM mtl_system_items

1394: --Start: 5383744: Donot move 5 for no attrib values
1395: FOR cur IN c_check_attributes_policy LOOP
1396:
1397: SELECT * INTO l_msb_rec
1398: FROM mtl_system_items
1399: WHERE inventory_item_id = cur.inventory_item_id
1400: AND organization_id = cur.organization_id;
1401:
1402: --Inventory Attribute group

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