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

Line 50: -- mtl_system_items_interface m

46: a.control_level
47: from mtl_item_status s,
48: mtl_status_attribute_values v,
49: mtl_item_attributes a
50: -- mtl_system_items_interface m
51: -- where s.inventory_item_status_code = m.inventory_item_status_code
52: -- and m.rowid = p_rowid
53: where s.inventory_item_status_code = p_status_code -- bug 7137702
54: and s.inventory_item_status_code = v.inventory_item_status_code

Line 72: FROM MTL_SYSTEM_ITEMS B

68: B.BUILD_IN_WIP_FLAG,
69: B.INVOICE_ENABLED_FLAG,
70: B.RECIPE_ENABLED_FLAG,
71: B.PROCESS_EXECUTION_ENABLED_FLAG
72: FROM MTL_SYSTEM_ITEMS B
73: ,MTL_PARAMETERS PARAM
74: WHERE B.INVENTORY_ITEM_ID = item_id
75: AND B.ORGANIZATION_ID = PARAM.MASTER_ORGANIZATION_ID
76: AND PARAM.ORGANIZATION_ID = org_id;

Line 85: from MTL_SYSTEM_ITEMS B

81: B.CUSTOMER_ORDER_ENABLED_FLAG,B.INTERNAL_ORDER_ENABLED_FLAG,
82: B.MTL_TRANSACTIONS_ENABLED_FLAG,B.BOM_ENABLED_FLAG,
83: B.BUILD_IN_WIP_FLAG,B.INVOICE_ENABLED_FLAG,
84: B.RECIPE_ENABLED_FLAG,B.PROCESS_EXECUTION_ENABLED_FLAG
85: from MTL_SYSTEM_ITEMS B
86: where INVENTORY_ITEM_ID = item_id
87: and ORGANIZATION_ID = org_id;
88:
89: /*NP 05AUG94 IMPORTANT NOTE: Have put in an order by clause in

Line 95: AttRec MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;

91: **STOCK_ENABLED_FLAG attribute be processed before the MTL_TRANSACTIONS_ENABLED_FLAG record
92: **since the logic of the latter is depenent on the former
93: */
94:
95: AttRec MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;
96: master_rec master_cur%ROWTYPE;
97: Master_Org char(1);
98: Master_status_code varchar2(10);
99: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452

Line 112: FROM MTL_SYSTEM_ITEMS_INTERFACE

108: INVPUTLI.info('Inside INVPULI4.assign_status_attributes');
109: END IF;
110:
111: SELECT * INTO AttRec
112: FROM MTL_SYSTEM_ITEMS_INTERFACE
113: WHERE ROWID = p_rowid ;
114:
115: Master_Org := 'N';
116:

Line 179: IF ( cr.attribute_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' ) THEN

175: cr.status_control_code := g_status_control_codes(i);
176: cr.control_level := g_control_levels(i);
177: -- end bug 7137702
178:
179: IF ( cr.attribute_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' ) THEN
180: IF ( AttRec.INVENTORY_ITEM_FLAG = 'Y' ) THEN
181: IF(cr.control_level=1) AND (Master_Org ='N') THEN
182: AttRec.STOCK_ENABLED_FLAG := master_rec.STOCK_ENABLED_FLAG;
183: ELSE

Line 201: IF ( cr.attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' ) then

197: AttRec.STOCK_ENABLED_FLAG := 'N';
198: END IF;
199: END IF;
200:
201: IF ( cr.attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' ) then
202: IF ( AttRec.STOCK_ENABLED_FLAG = 'Y' ) THEN
203: IF(cr.control_level=1) AND (Master_Org ='N') THEN
204: AttRec.MTL_TRANSACTIONS_ENABLED_FLAG := master_rec.MTL_TRANSACTIONS_ENABLED_FLAG;
205: ELSE

Line 223: IF cr.attribute_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN

219: AttRec.MTL_TRANSACTIONS_ENABLED_FLAG := 'N';
220: END IF;
221: END IF;
222:
223: IF cr.attribute_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
224: IF AttRec.purchasing_item_flag = 'Y' THEN
225: IF(cr.control_level=1) AND (Master_Org ='N') THEN
226: AttRec.PURCHASING_ENABLED_FLAG := master_rec.PURCHASING_ENABLED_FLAG;
227: ELSE

Line 245: IF cr.attribute_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN

241: AttRec.PURCHASING_ENABLED_FLAG := 'N';
242: END IF;
243: END IF;
244:
245: IF cr.attribute_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN
246: IF AttRec.invoiceable_item_flag = 'Y' THEN
247: IF(cr.control_level=1) AND (Master_Org ='N') THEN
248: AttRec.INVOICE_ENABLED_FLAG := master_rec.INVOICE_ENABLED_FLAG;
249: ELSE

Line 267: IF cr.attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN

263: AttRec.INVOICE_ENABLED_FLAG := 'N';
264: END IF;
265: END IF;
266:
267: IF cr.attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
268: IF (AttRec.inventory_item_flag = 'Y' and AttRec.bom_item_type = 4) THEN
269: IF(cr.control_level=1) AND (Master_Org ='N') THEN
270: AttRec.BUILD_IN_WIP_FLAG := master_rec.BUILD_IN_WIP_FLAG;
271: ELSE

Line 289: IF cr.attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN

285: AttRec.BUILD_IN_WIP_FLAG := 'N';
286: END IF;
287: END IF;
288:
289: IF cr.attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
290: IF AttRec.customer_order_flag = 'Y' THEN
291: IF(cr.control_level=1) AND (Master_Org ='N') THEN
292: AttRec.CUSTOMER_ORDER_ENABLED_FLAG := master_rec.CUSTOMER_ORDER_ENABLED_FLAG;
293: ELSE

Line 311: IF cr.attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN

307: AttRec.CUSTOMER_ORDER_ENABLED_FLAG := 'N';
308: END IF;
309: END IF;
310:
311: IF cr.attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN
312: IF AttRec.internal_order_flag = 'Y' THEN
313: IF(cr.control_level=1) AND (Master_Org ='N') THEN
314: AttRec.INTERNAL_ORDER_ENABLED_FLAG := master_rec.INTERNAL_ORDER_ENABLED_FLAG;
315: ELSE

Line 333: IF cr.attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN

329: AttRec.INTERNAL_ORDER_ENABLED_FLAG := 'N';
330: END IF;
331: END IF;
332:
333: IF cr.attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
334: IF(cr.control_level=1) AND (Master_Org ='N') THEN
335: AttRec.BOM_ENABLED_FLAG := master_rec.BOM_ENABLED_FLAG;
336: ELSE
337: IF ( cr.status_control_code = 1 ) THEN

Line 351: IF ( cr.attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG' ) THEN

347: END IF;
348: END IF;-- Master_Org ='N'
349: END IF;
350:
351: IF ( cr.attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG' ) THEN
352: IF(cr.control_level=1) AND (Master_Org ='N') THEN
353: AttRec.RECIPE_ENABLED_FLAG := master_rec.RECIPE_ENABLED_FLAG;
354: ELSE
355: IF ( cr.status_control_code = 1 ) THEN

Line 369: IF ( cr.attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG' ) THEN

365: END IF;
366: END IF;-- Master_Org ='N'
367: END IF;
368:
369: IF ( cr.attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG' ) THEN
370: IF ( AttRec.INVENTORY_ITEM_FLAG = 'N' OR
371: AttRec.RECIPE_ENABLED_FLAG = 'N') THEN
372: AttRec.PROCESS_EXECUTION_ENABLED_FLAG := 'N';
373: ELSE

Line 394: update MTL_SYSTEM_ITEMS_INTERFACE

390: END IF;
391:
392: END LOOP;
393:
394: update MTL_SYSTEM_ITEMS_INTERFACE
395: set
396: STOCK_ENABLED_FLAG = AttRec.STOCK_ENABLED_FLAG,
397: MTL_TRANSACTIONS_ENABLED_FLAG = AttRec.MTL_TRANSACTIONS_ENABLED_FLAG,
398: PURCHASING_ENABLED_FLAG = AttRec.PURCHASING_ENABLED_FLAG,

Line 410: update mtl_system_items_interface

406: where rowid = p_rowid ;
407: end if ; -- Main end if
408:
409: IF (AttRec.INVENTORY_ITEM_STATUS_CODE is null and AttRec.TRANSACTION_TYPE = 'UPDATE') THEN
410: update mtl_system_items_interface
411: set inventory_item_status_code = (select msi.inventory_item_status_code
412: from mtl_system_items msi
413: where msi.inventory_item_id = AttRec.inventory_item_id
414: and msi.organization_id = AttRec.organization_id)

Line 412: from mtl_system_items msi

408:
409: IF (AttRec.INVENTORY_ITEM_STATUS_CODE is null and AttRec.TRANSACTION_TYPE = 'UPDATE') THEN
410: update mtl_system_items_interface
411: set inventory_item_status_code = (select msi.inventory_item_status_code
412: from mtl_system_items msi
413: where msi.inventory_item_id = AttRec.inventory_item_id
414: and msi.organization_id = AttRec.organization_id)
415: where rowid = p_rowid;
416: END IF;