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 27: , mtl_system_items_interface msii

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

Line 69: mtl_system_items_interface msi

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

Line 81: mtl_system_items_interface msi

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

Line 100: FROM mtl_system_items_interface msii,

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

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

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

Line 119: FROM mtl_system_items_interface

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

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

120: WHERE transaction_type = 'CREATE'
121: AND process_flag = l_process_flag_4
122: AND set_process_id = xset_id;
123:
124: TYPE transaction_type IS TABLE OF mtl_system_items_interface.transaction_id%TYPE
125: INDEX BY BINARY_INTEGER;
126:
127: transaction_table transaction_type;
128: l_transaction_type VARCHAR2(10) := 'CREATE';

Line 176: 'MTL_SYSTEM_ITEMS_INTERFACE',

172: req_id,
173: ff.TRANSACTION_ID,
174: error_msg,
175: 'INVENTORY_ITEM_ID',
176: 'MTL_SYSTEM_ITEMS_INTERFACE',
177: 'INV_IOI_ERR',
178: l_err_text);
179: IF dumm_status < 0 THEN
180: raise LOGGING_ERR;

Line 183: UPDATE mtl_system_items_interface

179: IF dumm_status < 0 THEN
180: raise LOGGING_ERR;
181: END IF;
182:
183: UPDATE mtl_system_items_interface
184: SET process_flag = 3
185: WHERE CURRENT OF Flex_Exists;
186:
187: END LOOP;

Line 198: FROM MTL_SYSTEM_ITEMS_INTERFACE

194:
195: IF l_is_gdsn_batch = 1 THEN
196: FOR cr IN duplicate_recs LOOP
197: SELECT count(*) INTO ext_flag
198: FROM MTL_SYSTEM_ITEMS_INTERFACE
199: WHERE inventory_item_id = cr.inventory_item_id
200: AND organization_id = cr.organization_id
201: AND process_flag = 4
202: AND set_process_id = xset_id

Line 206: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

202: AND set_process_id = xset_id
203: AND transaction_type = 'CREATE';
204:
205: IF ext_flag > 1 THEN
206: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
207: SET process_flag = 3
208: WHERE inventory_item_id = cr.inventory_item_id
209: AND organization_id = cr.organization_id
210: AND process_flag = l_process_flag_4

Line 236: 'MTL_SYSTEM_ITEMS_INTERFACE',

232: req_id,
233: transaction_table(j),
234: error_msg,
235: 'INVENTORY_ITEM_ID',
236: 'MTL_SYSTEM_ITEMS_INTERFACE',
237: 'INV_IOI_ERR' ,
238: l_err_text);
239: END LOOP;
240: END IF;

Line 1066: MTL_SYSTEM_ITEMS_INTERFACE I

1062: , I.TRADE_ITEM_DESCRIPTOR
1063: , I.STYLE_ITEM_FLAG
1064: , I.STYLE_ITEM_ID
1065: FROM
1066: MTL_SYSTEM_ITEMS_INTERFACE I
1067: WHERE
1068: I.process_flag = l_process_flag_4
1069: AND I.set_process_id = xset_id
1070: AND I.transaction_type = l_transaction_type;

Line 1104: from MTL_SYSTEM_ITEMS_INTERFACE I

1100: user_id, /* last_updated_by */
1101: NVL(I.CREATION_DATE, l_sysdate),
1102: user_id, /* created_by */
1103: login_id /* last_update_login */
1104: from MTL_SYSTEM_ITEMS_INTERFACE I
1105: , FND_LANGUAGES L
1106: , mtl_parameters mp
1107: where I.process_flag = l_process_flag_4
1108: and I.set_process_id = xset_id

Line 1154: from MTL_SYSTEM_ITEMS_INTERFACE I

1150: user_id, --* last_updated_by
1151: NVL(I.CREATION_DATE, l_sysdate),
1152: user_id, --* created_by
1153: login_id --* last_update_login
1154: from MTL_SYSTEM_ITEMS_INTERFACE I
1155: , MTL_SYSTEM_ITEMS_TL msitl
1156: , FND_LANGUAGES L
1157: where I.process_flag = l_process_flag_4
1158: and I.set_process_id = xset_id

Line 1192: MTL_SYSTEM_ITEMS_INTERFACE I

1188: delete from mtl_descr_element_values
1189: where inventory_item_id in
1190: ( select inventory_item_id
1191: from mtl_parameters MP,
1192: MTL_SYSTEM_ITEMS_INTERFACE I
1193: where I.process_flag = l_process_flag_4
1194: and I.set_process_id = xset_id
1195: and I.transaction_type = l_transaction_type
1196: and I.item_catalog_group_id is not null

Line 1237: mtl_system_items_interface I

1233: l_sysdate,
1234: MDE.ELEMENT_SEQUENCE
1235: from mtl_descriptive_elements MDE,
1236: mtl_parameters MP,
1237: mtl_system_items_interface I
1238: where I.process_flag = l_process_flag_4
1239: and I.set_process_id = xset_id
1240: and I.transaction_type = l_transaction_type
1241: and I.organization_id = MP.master_organization_id

Line 1528: FROM mtl_system_items_interface m

1524: ,prg_appid -- program_application_id
1525: ,prg_id -- program_id
1526: ,l_sysdate -- program_update_date
1527: ,req_id -- request_id
1528: FROM mtl_system_items_interface m
1529: ,mtl_default_category_sets d
1530: ,mtl_category_sets_b s
1531: WHERE
1532: m.transaction_type = 'CREATE'

Line 1603: FROM mtl_system_items_interface msi

1599: ,prg_appid -- program_application_id
1600: ,prg_id -- program_id
1601: ,l_sysdate -- program_update_date
1602: ,req_id -- request_id
1603: FROM mtl_system_items_interface msi
1604: ,mtl_default_category_sets mdcs
1605: ,mtl_category_sets_b mcs
1606: ,mtl_parameters mp
1607: WHERE

Line 1677: from MTL_SYSTEM_ITEMS_INTERFACE I

1673: l_sysdate,
1674: --2740503: Lifecycle-phase introduced.
1675: I.LIFECYCLE_ID,
1676: I.CURRENT_PHASE_ID
1677: from MTL_SYSTEM_ITEMS_INTERFACE I
1678: where I.process_flag = l_process_flag_4
1679: and I.set_process_id = xset_id
1680: and I.transaction_type = l_transaction_type;
1681:

Line 1729: ** from mtl_system_items_interface msii,

1725: ** prg_appid,
1726: ** prg_id,
1727: ** sysdate,
1728: ** msii.organization_id
1729: ** from mtl_system_items_interface msii,
1730: ** mtl_item_categories mic,
1731: ** MTL_PARAMETERS MP
1732: ** where msii.process_flag = 4
1733: ** and msii.transaction_type = 'CREATE'

Line 1873: table_name := 'MTL_SYSTEM_ITEMS_INTERFACE';

1869: --
1870: -- The last step: set process_flags to 7
1871: --
1872:
1873: table_name := 'MTL_SYSTEM_ITEMS_INTERFACE';
1874:
1875: update MTL_SYSTEM_ITEMS_INTERFACE
1876: set process_flag = l_process_flag_7,
1877: request_id = nvl(request_id,req_id),

Line 1875: update MTL_SYSTEM_ITEMS_INTERFACE

1871: --
1872:
1873: table_name := 'MTL_SYSTEM_ITEMS_INTERFACE';
1874:
1875: update MTL_SYSTEM_ITEMS_INTERFACE
1876: set process_flag = l_process_flag_7,
1877: request_id = nvl(request_id,req_id),
1878: program_application_id = nvl(program_application_id,prg_appid),
1879: PROGRAM_ID = nvl(PROGRAM_ID,prg_id),