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

Line 28: , mtl_system_items_interface msii

24: , muom.base_uom_flag
25: , muom.uom_class UOMCL
26: FROM
27: mtl_units_of_measure_vl muom
28: , mtl_system_items_interface msii
29: WHERE
30: msii.process_flag = 4
31: AND msii.allowed_units_lookup_code = 1
32: AND msii.set_process_id = xset_id

Line 70: mtl_system_items_interface msi

66: msi.eam_item_type EAMTYPE,
67: msi.contract_item_type_code CONTCODE,
68: msi.gdsn_outbound_enabled_flag GDSNFLAG
69: from mtl_parameters mp,
70: mtl_system_items_interface msi
71: where mp.MASTER_ORGANIZATION_ID <> msi.organization_id
72: and mp.organization_id = msi.organization_id
73: AND msi.transaction_type = 'CREATE'
74: AND msi.process_flag = l_process_flag_4

Line 82: mtl_system_items_interface msi

78: CURSOR Flex_Exists IS
79: select msi.item_number,msi.organization_id,msi.organization_code,
80: msi.transaction_id,msi.process_flag
81: from mtl_system_items_b_kfv msk,
82: mtl_system_items_interface msi
83: where msi.item_number = msk.concatenated_segments
84: and msk.organization_id = msi.organization_id
85: AND msi.transaction_type = 'CREATE'
86: AND msi.process_flag = l_process_flag_4

Line 101: FROM mtl_system_items_interface msii,

97: tl.language,
98: tl.column_value,
99: msii.inventory_item_id,
100: msii.organization_id
101: FROM mtl_system_items_interface msii,
102: ego_interface_tl tl
103: WHERE msii.process_flag = l_process_flag_4
104: AND msii.set_process_id = xset_id
105: AND msii.transaction_type = 'CREATE'

Line 108: AND UPPER(tl.table_name) = 'MTL_SYSTEM_ITEMS_INTERFACE'

104: AND msii.set_process_id = xset_id
105: AND msii.transaction_type = 'CREATE'
106: AND tl.unique_id = msii.transaction_id
107: AND tl.set_process_id = msii.set_process_id
108: AND UPPER(tl.table_name) = 'MTL_SYSTEM_ITEMS_INTERFACE'
109: AND UPPER(tl.column_name) = 'DESCRIPTION'
110: AND tl.language IN (SELECT l.language_code FROM fnd_languages l
111: WHERE l.installed_flag IN ('I', 'B'));
112:

Line 120: FROM mtl_system_items_interface

116: AND enabled_for_data_pool = 'Y';
117:
118: CURSOR duplicate_recs IS
119: SELECT inventory_item_id, organization_id, item_number
120: FROM mtl_system_items_interface
121: WHERE transaction_type = 'CREATE'
122: AND process_flag = l_process_flag_4
123: AND set_process_id = xset_id;
124:

Line 134: MTL_SYSTEM_ITEMS_INTERFACE I

130:
131: CURSOR serial_tag_del IS
132: SELECT inventory_item_id, organization_id
133: FROM
134: MTL_SYSTEM_ITEMS_INTERFACE I
135: WHERE
136: I.process_flag <> l_process_flag_4
137: AND I.process_flag not in (60007,7) -- Added for Excel Import Org Assignment Case
138: AND I.request_id = nvl(req_id,I.request_id) -- bug 10144142

Line 149: MTL_SYSTEM_ITEMS_INTERFACE I , MTL_SERIAL_TAGGING_ASSIGNMENTS S

145:
146: CURSOR update_inv_item_id IS
147: SELECT I.inventory_item_id,I.organization_id,I.transaction_id
148: FROM
149: MTL_SYSTEM_ITEMS_INTERFACE I , MTL_SERIAL_TAGGING_ASSIGNMENTS S
150: WHERE
151: I.process_flag = l_process_flag_4
152: AND I.set_process_id = xset_id
153: AND I.transaction_type = l_transaction_type

Line 161: TYPE transaction_type IS TABLE OF mtl_system_items_interface.transaction_id%TYPE

157:
158:
159: x_ret_sts VARCHAR(1);
160:
161: TYPE transaction_type IS TABLE OF mtl_system_items_interface.transaction_id%TYPE
162: INDEX BY BINARY_INTEGER;
163:
164: transaction_table transaction_type;
165:

Line 213: 'MTL_SYSTEM_ITEMS_INTERFACE',

209: req_id,
210: ff.TRANSACTION_ID,
211: error_msg,
212: 'INVENTORY_ITEM_ID',
213: 'MTL_SYSTEM_ITEMS_INTERFACE',
214: 'INV_IOI_ERR_DPC_ITEM_MSI', --change INV_IOI_ERR to specific message name by bug 11894684
215: l_err_text);
216: IF dumm_status < 0 THEN
217: raise LOGGING_ERR;

Line 220: UPDATE mtl_system_items_interface

216: IF dumm_status < 0 THEN
217: raise LOGGING_ERR;
218: END IF;
219:
220: UPDATE mtl_system_items_interface
221: SET process_flag = 3
222: WHERE CURRENT OF Flex_Exists;
223:
224: END LOOP;

Line 235: FROM MTL_SYSTEM_ITEMS_INTERFACE

231:
232: IF l_is_gdsn_batch = 1 THEN
233: FOR cr IN duplicate_recs LOOP
234: SELECT count(*) INTO ext_flag
235: FROM MTL_SYSTEM_ITEMS_INTERFACE
236: WHERE inventory_item_id = cr.inventory_item_id
237: AND organization_id = cr.organization_id
238: AND process_flag = 4
239: AND set_process_id = xset_id

Line 243: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

239: AND set_process_id = xset_id
240: AND transaction_type = 'CREATE';
241:
242: IF ext_flag > 1 THEN
243: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
244: SET process_flag = 3
245: WHERE inventory_item_id = cr.inventory_item_id
246: AND organization_id = cr.organization_id
247: AND process_flag = l_process_flag_4

Line 273: 'MTL_SYSTEM_ITEMS_INTERFACE',

269: req_id,
270: transaction_table(j),
271: error_msg,
272: 'INVENTORY_ITEM_ID',
273: 'MTL_SYSTEM_ITEMS_INTERFACE',
274: 'INV_IOI_ERR_DPC_ITEM_MSII' , --change INV_IOI_ERR to specific message name by bug 11894684
275: l_err_text);
276: END LOOP;
277: END IF;

Line 1135: MTL_SYSTEM_ITEMS_INTERFACE I

1131: --serial_tagging enh -- bug 9913552
1132: , Decode (INV_SERIAL_NUMBER_PUB.is_serial_tagged(I.inventory_item_id,
1133: I.organization_id),2,'Y','N')
1134: FROM
1135: MTL_SYSTEM_ITEMS_INTERFACE I
1136: WHERE
1137: I.process_flag = l_process_flag_4
1138: AND I.set_process_id = xset_id
1139: AND I.transaction_type = l_transaction_type;

Line 1175: from MTL_SYSTEM_ITEMS_INTERFACE I

1171: user_id, /* last_updated_by */
1172: l_sysdate,
1173: user_id, /* created_by */
1174: login_id /* last_update_login */
1175: from MTL_SYSTEM_ITEMS_INTERFACE I
1176: , FND_LANGUAGES L
1177: , mtl_parameters mp
1178: where I.process_flag = l_process_flag_4
1179: and I.set_process_id = xset_id

Line 1228: from MTL_SYSTEM_ITEMS_INTERFACE I

1224: user_id, --* last_updated_by
1225: l_sysdate,
1226: user_id, --* created_by
1227: login_id --* last_update_login
1228: from MTL_SYSTEM_ITEMS_INTERFACE I
1229: , MTL_SYSTEM_ITEMS_TL msitl
1230: , FND_LANGUAGES L
1231: where I.process_flag = l_process_flag_4
1232: and I.set_process_id = xset_id

Line 1266: MTL_SYSTEM_ITEMS_INTERFACE I

1262: delete from mtl_descr_element_values
1263: where inventory_item_id in
1264: ( select inventory_item_id
1265: from mtl_parameters MP,
1266: MTL_SYSTEM_ITEMS_INTERFACE I
1267: where I.process_flag = l_process_flag_4
1268: and I.set_process_id = xset_id
1269: and I.transaction_type = l_transaction_type
1270: and I.item_catalog_group_id is not null

Line 1313: mtl_system_items_interface I

1309: l_sysdate,
1310: MDE.ELEMENT_SEQUENCE
1311: from mtl_descriptive_elements MDE,
1312: mtl_parameters MP,
1313: mtl_system_items_interface I
1314: where I.process_flag = l_process_flag_4
1315: and I.set_process_id = xset_id
1316: and I.transaction_type = l_transaction_type
1317: and I.organization_id = MP.master_organization_id

Line 1612: FROM mtl_system_items_interface m

1608: ,prg_appid -- program_application_id
1609: ,prg_id -- program_id
1610: ,l_sysdate -- program_update_date
1611: ,req_id -- request_id
1612: FROM mtl_system_items_interface m
1613: ,mtl_default_category_sets d
1614: ,mtl_category_sets_b s
1615: WHERE
1616: m.transaction_type = 'CREATE'

Line 1689: FROM mtl_system_items_interface msi

1685: ,prg_appid -- program_application_id
1686: ,prg_id -- program_id
1687: ,l_sysdate -- program_update_date
1688: ,req_id -- request_id
1689: FROM mtl_system_items_interface msi
1690: ,mtl_default_category_sets mdcs
1691: ,mtl_category_sets_b mcs
1692: ,mtl_parameters mp
1693: WHERE

Line 1763: from MTL_SYSTEM_ITEMS_INTERFACE I

1759: l_sysdate,
1760: --2740503: Lifecycle-phase introduced.
1761: I.LIFECYCLE_ID,
1762: I.CURRENT_PHASE_ID
1763: from MTL_SYSTEM_ITEMS_INTERFACE I
1764: where I.process_flag = l_process_flag_4
1765: and I.set_process_id = xset_id
1766: and I.transaction_type = l_transaction_type;
1767:

Line 1815: ** from mtl_system_items_interface msii,

1811: ** prg_appid,
1812: ** prg_id,
1813: ** sysdate,
1814: ** msii.organization_id
1815: ** from mtl_system_items_interface msii,
1816: ** mtl_item_categories mic,
1817: ** MTL_PARAMETERS MP
1818: ** where msii.process_flag = 4
1819: ** and msii.transaction_type = 'CREATE'

Line 1959: table_name := 'MTL_SYSTEM_ITEMS_INTERFACE';

1955: --
1956: -- The last step: set process_flags to 7
1957: --
1958:
1959: table_name := 'MTL_SYSTEM_ITEMS_INTERFACE';
1960:
1961: update MTL_SYSTEM_ITEMS_INTERFACE
1962: set process_flag = l_process_flag_7,
1963: request_id = nvl(request_id,req_id),

Line 1961: update MTL_SYSTEM_ITEMS_INTERFACE

1957: --
1958:
1959: table_name := 'MTL_SYSTEM_ITEMS_INTERFACE';
1960:
1961: update MTL_SYSTEM_ITEMS_INTERFACE
1962: set process_flag = l_process_flag_7,
1963: request_id = nvl(request_id,req_id),
1964: program_application_id = nvl(program_application_id,prg_appid),
1965: PROGRAM_ID = nvl(PROGRAM_ID,prg_id),