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.INVPULI3 dependencies on MTL_SYSTEM_ITEMS

Line 36: TYPE base_id_type IS TABLE OF mtl_system_items_interface.copy_item_id%TYPE

32: WHERE status.phase_code = phase.phase_code
33: AND proj_element_id = Cp_phase_id
34: AND status.default_flag = 'Y';
35:
36: TYPE base_id_type IS TABLE OF mtl_system_items_interface.copy_item_id%TYPE
37: INDEX BY BINARY_INTEGER;
38:
39: TYPE base_org_type IS TABLE OF mtl_system_items_interface.copy_organization_id%TYPE
40: INDEX BY BINARY_INTEGER;

Line 39: TYPE base_org_type IS TABLE OF mtl_system_items_interface.copy_organization_id%TYPE

35:
36: TYPE base_id_type IS TABLE OF mtl_system_items_interface.copy_item_id%TYPE
37: INDEX BY BINARY_INTEGER;
38:
39: TYPE base_org_type IS TABLE OF mtl_system_items_interface.copy_organization_id%TYPE
40: INDEX BY BINARY_INTEGER;
41:
42: TYPE base_number_type IS TABLE OF mtl_system_items_interface.copy_item_number%TYPE
43: INDEX BY BINARY_INTEGER;

Line 42: TYPE base_number_type IS TABLE OF mtl_system_items_interface.copy_item_number%TYPE

38:
39: TYPE base_org_type IS TABLE OF mtl_system_items_interface.copy_organization_id%TYPE
40: INDEX BY BINARY_INTEGER;
41:
42: TYPE base_number_type IS TABLE OF mtl_system_items_interface.copy_item_number%TYPE
43: INDEX BY BINARY_INTEGER;
44:
45: TYPE base_org_code_type IS TABLE OF mtl_system_items_interface.copy_organization_code%TYPE
46: INDEX BY BINARY_INTEGER;

Line 45: TYPE base_org_code_type IS TABLE OF mtl_system_items_interface.copy_organization_code%TYPE

41:
42: TYPE base_number_type IS TABLE OF mtl_system_items_interface.copy_item_number%TYPE
43: INDEX BY BINARY_INTEGER;
44:
45: TYPE base_org_code_type IS TABLE OF mtl_system_items_interface.copy_organization_code%TYPE
46: INDEX BY BINARY_INTEGER;
47:
48: TYPE transaction_type IS TABLE OF mtl_system_items_interface.transaction_id%TYPE
49: INDEX BY BINARY_INTEGER;

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

44:
45: TYPE base_org_code_type IS TABLE OF mtl_system_items_interface.copy_organization_code%TYPE
46: INDEX BY BINARY_INTEGER;
47:
48: TYPE transaction_type IS TABLE OF mtl_system_items_interface.transaction_id%TYPE
49: INDEX BY BINARY_INTEGER;
50:
51: base_item_table base_id_type;
52: base_org_table base_org_type;

Line 63: l_status MTL_SYSTEM_ITEMS.inventory_item_status_code%TYPE;

59: l_msii_count NUMBER;
60: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
61: dumm_status NUMBER;
62: l_phase_id NUMBER;
63: l_status MTL_SYSTEM_ITEMS.inventory_item_status_code%TYPE;
64: l_lifecycle_id NUMBER;
65: l_valid_status VARCHAR2(1) := 'N';
66:
67: BEGIN

Line 75: FROM mtl_system_items_interface msii, mtl_parameters mp

71:
72: /* Resolving Copy Item Numbers if any to Item Ids */
73: BEGIN
74: SELECT DISTINCT msii.copy_item_number BULK COLLECT INTO base_item_num_table
75: FROM mtl_system_items_interface msii, mtl_parameters mp
76: WHERE msii.process_flag = 1
77: AND msii.set_process_id = xset_id
78: AND msii.transaction_type = 'CREATE'
79: AND ((msii.organization_id = org_id) or (all_org = 1))

Line 90: UPDATE mtl_system_items_interface msii

86: END;
87:
88: IF base_item_num_table.COUNT > 0 THEN
89: FOR I IN base_item_num_table.FIRST .. base_item_num_table.LAST LOOP
90: UPDATE mtl_system_items_interface msii
91: SET msii.copy_item_id =
92: ( SELECT mskfv.inventory_item_id
93: FROM mtl_system_items_b_kfv mskfv
94: WHERE mskfv.concatenated_segments = base_item_num_table(i)

Line 93: FROM mtl_system_items_b_kfv mskfv

89: FOR I IN base_item_num_table.FIRST .. base_item_num_table.LAST LOOP
90: UPDATE mtl_system_items_interface msii
91: SET msii.copy_item_id =
92: ( SELECT mskfv.inventory_item_id
93: FROM mtl_system_items_b_kfv mskfv
94: WHERE mskfv.concatenated_segments = base_item_num_table(i)
95: AND rownum = 1 )
96: WHERE msii.copy_item_number = base_item_num_table(i)
97: AND msii.set_process_id = xset_id

Line 106: FROM mtl_system_items_interface msii, mtl_parameters mp

102:
103: /* Resolving Copy Org Codes if any to Org Ids */
104: BEGIN
105: SELECT DISTINCT msii.copy_organization_code BULK COLLECT INTO base_org_code_table
106: FROM mtl_system_items_interface msii, mtl_parameters mp
107: WHERE msii.process_flag = 1
108: AND msii.set_process_id = xset_id
109: AND msii.transaction_type = 'CREATE'
110: AND ((msii.organization_id = org_id) or (all_org = 1))

Line 121: UPDATE mtl_system_items_interface msii

117: END;
118:
119: IF base_org_code_table.COUNT > 0 THEN
120: FOR I IN base_org_code_table.FIRST .. base_org_code_table.LAST LOOP
121: UPDATE mtl_system_items_interface msii
122: SET msii.copy_organization_id =
123: ( SELECT mp.organization_id
124: FROM mtl_parameters mp
125: WHERE mp.organization_code = base_org_code_table(i))

Line 135: UPDATE mtl_system_items_interface

131: END LOOP;
132: END IF;
133:
134: /* Mark records with Copy Item Id but no Copy Org Id to error */
135: UPDATE mtl_system_items_interface
136: SET process_flag = 3
137: WHERE copy_item_id IS NOT NULL
138: AND copy_organization_id IS NULL
139: AND set_process_id = xset_id

Line 156: 'MTL_SYSTEM_ITEMS_INTERFACE',

152: request_id,
153: transaction_table(j),
154: err_text,
155: 'BASE_ITEM_ID',
156: 'MTL_SYSTEM_ITEMS_INTERFACE',
157: 'INV_ITEM_COPY_NO_EXIST' ,
158: err_text);
159: END LOOP;
160: END IF;

Line 165: FROM mtl_system_items_interface msii, mtl_parameters mp

161:
162: BEGIN
163: SELECT DISTINCT msii.copy_item_id, msii.copy_organization_id
164: BULK COLLECT INTO base_item_table, base_org_table
165: FROM mtl_system_items_interface msii, mtl_parameters mp
166: WHERE msii.process_flag = 1
167: AND msii.set_process_id = xset_id
168: AND msii.transaction_type = 'CREATE'
169: AND ((msii.organization_id = org_id) or (all_org = 1))

Line 184: FROM mtl_system_items

180: FOR I IN base_item_table.FIRST .. base_item_table.LAST LOOP
181: BEGIN
182: SELECT lifecycle_id, inventory_item_status_code
183: INTO l_lifecycle_id, l_status
184: FROM mtl_system_items
185: WHERE inventory_item_id = base_item_table(i)
186: AND organization_id = base_org_table(i);
187: l_msi_count := 1;
188: EXCEPTION

Line 196: UPDATE mtl_system_items_interface interface

192: l_status := null;
193: END;
194:
195: IF l_msi_count = 0 THEN
196: UPDATE mtl_system_items_interface interface
197: SET interface.process_flag = 3
198: WHERE interface.process_flag = 1
199: AND interface.set_process_id = xset_id
200: AND interface.transaction_type = 'CREATE'

Line 217: 'MTL_SYSTEM_ITEMS_INTERFACE',

213: request_id,
214: transaction_table(j),
215: err_text,
216: 'BASE_ITEM_ID',
217: 'MTL_SYSTEM_ITEMS_INTERFACE',
218: 'INV_ITEM_COPY_NO_EXIST' ,
219: err_text);
220: END LOOP;
221: END IF;

Line 240: UPDATE MTL_SYSTEM_ITEMS_INTERFACE i

236: CLOSE c_default_status;
237: END IF;
238: END IF;
239:
240: UPDATE MTL_SYSTEM_ITEMS_INTERFACE i
241: SET (
242: i.ITEM_CATALOG_GROUP_ID,
243: i.CATALOG_STATUS_FLAG ,
244: -- Main attributes

Line 930: FROM MTL_SYSTEM_ITEMS m

926: NVL(i.OUTSOURCED_ASSEMBLY, m.OUTSOURCED_ASSEMBLY),
927: /* R12 C Enhancement */
928: NVL(i.GDSN_OUTBOUND_ENABLED_FLAG, m.GDSN_OUTBOUND_ENABLED_FLAG),
929: NVL(i.TRADE_ITEM_DESCRIPTOR, m.TRADE_ITEM_DESCRIPTOR)
930: FROM MTL_SYSTEM_ITEMS m
931: WHERE m.inventory_item_id = base_item_table(i)
932: AND m.organization_id = base_org_table(i))
933: WHERE i.process_flag = 1
934: AND i.set_process_id = xset_id