DBA Data[Home] [Help]

APPS.INV_ITEM_STATUS_CP dependencies on MTL_SYSTEM_ITEMS

Line 4: G_STATUS_CODE VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';

1: PACKAGE BODY INV_ITEM_STATUS_CP AS
2: /* $Header: INVCIPSB.pls 120.10 2007/11/19 09:15:25 arattan ship $ */
3:
4: G_STATUS_CODE VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
5: G_STOCK_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG';
6: G_TRANSACTIONS_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG';
7: G_PURCHASING_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG';
8: G_INVOICE_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG';

Line 5: G_STOCK_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG';

1: PACKAGE BODY INV_ITEM_STATUS_CP AS
2: /* $Header: INVCIPSB.pls 120.10 2007/11/19 09:15:25 arattan ship $ */
3:
4: G_STATUS_CODE VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
5: G_STOCK_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG';
6: G_TRANSACTIONS_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG';
7: G_PURCHASING_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG';
8: G_INVOICE_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG';
9: G_BUILD_IN_WIP VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG';

Line 6: G_TRANSACTIONS_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG';

2: /* $Header: INVCIPSB.pls 120.10 2007/11/19 09:15:25 arattan ship $ */
3:
4: G_STATUS_CODE VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
5: G_STOCK_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG';
6: G_TRANSACTIONS_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG';
7: G_PURCHASING_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG';
8: G_INVOICE_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG';
9: G_BUILD_IN_WIP VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG';
10: G_CUSTOMER_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG';

Line 7: G_PURCHASING_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG';

3:
4: G_STATUS_CODE VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
5: G_STOCK_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG';
6: G_TRANSACTIONS_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG';
7: G_PURCHASING_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG';
8: G_INVOICE_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG';
9: G_BUILD_IN_WIP VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG';
10: G_CUSTOMER_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG';
11: G_INTERNAL_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG';

Line 8: G_INVOICE_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG';

4: G_STATUS_CODE VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
5: G_STOCK_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG';
6: G_TRANSACTIONS_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG';
7: G_PURCHASING_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG';
8: G_INVOICE_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG';
9: G_BUILD_IN_WIP VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG';
10: G_CUSTOMER_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG';
11: G_INTERNAL_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG';
12: G_BOM_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG';

Line 9: G_BUILD_IN_WIP VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG';

5: G_STOCK_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG';
6: G_TRANSACTIONS_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG';
7: G_PURCHASING_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG';
8: G_INVOICE_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG';
9: G_BUILD_IN_WIP VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG';
10: G_CUSTOMER_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG';
11: G_INTERNAL_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG';
12: G_BOM_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG';
13:

Line 10: G_CUSTOMER_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG';

6: G_TRANSACTIONS_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG';
7: G_PURCHASING_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG';
8: G_INVOICE_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG';
9: G_BUILD_IN_WIP VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG';
10: G_CUSTOMER_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG';
11: G_INTERNAL_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG';
12: G_BOM_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG';
13:
14: G_ITEM NUMBER := 1;

Line 11: G_INTERNAL_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG';

7: G_PURCHASING_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG';
8: G_INVOICE_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG';
9: G_BUILD_IN_WIP VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG';
10: G_CUSTOMER_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG';
11: G_INTERNAL_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG';
12: G_BOM_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG';
13:
14: G_ITEM NUMBER := 1;
15: G_ITEM_ORG NUMBER := 2;

Line 12: G_BOM_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG';

8: G_INVOICE_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG';
9: G_BUILD_IN_WIP VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG';
10: G_CUSTOMER_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG';
11: G_INTERNAL_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG';
12: G_BOM_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG';
13:
14: G_ITEM NUMBER := 1;
15: G_ITEM_ORG NUMBER := 2;
16: G_PWIDTH NUMBER := 132;

Line 42: G_RECIPE_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG';

38: --commented for bug 5479302
39: -- G_BOM_status NUMBER := 0;
40:
41: /* Start Bug 3713912 */
42: G_RECIPE_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG';
43: G_PROCESS_EXECUTION_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG';
44: /* End Bug 3713912 */
45:
46: -- Added for bug 5230594

Line 43: G_PROCESS_EXECUTION_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG';

39: -- G_BOM_status NUMBER := 0;
40:
41: /* Start Bug 3713912 */
42: G_RECIPE_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG';
43: G_PROCESS_EXECUTION_ENABLED VARCHAR2(50) := 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG';
44: /* End Bug 3713912 */
45:
46: -- Added for bug 5230594
47: G_TRANSACTABLE NUMBER := 0;

Line 130: FROM mtl_system_items msi

126:
127: /* Check to see wether the row is locked */
128:
129: SELECT 1 INTO l_row_temp
130: FROM mtl_system_items msi
131: WHERE inventory_item_id = p_Item_Id
132: AND ((p_control_level = G_ITEM_ORG and msi.organization_id = p_Org_Id)
133: OR
134: (p_control_level = G_ITEM

Line 148: (SELECT 'X' FROM mtl_system_items

144: /* 5523531 - Condition only applies when Transactable flag of item is changed by the status */
145: SELECT count(*) INTO is_transactable_upd
146: FROM DUAL
147: WHERE EXISTS
148: (SELECT 'X' FROM mtl_system_items
149: WHERE inventory_item_id = p_item_id
150: AND organization_id = p_org_id
151: AND mtl_transactions_enabled_flag <>
152: (SELECT attribute_value FROM mtl_status_attribute_values

Line 153: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG'

149: WHERE inventory_item_id = p_item_id
150: AND organization_id = p_org_id
151: AND mtl_transactions_enabled_flag <>
152: (SELECT attribute_value FROM mtl_status_attribute_values
153: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG'
154: AND inventory_item_status_code = p_pending_status));
155:
156: --Added for Bug: 5230429
157: if (l_trans_cntrl_level in ( G_UNDER_STATUS_CONTROL,G_DEFAULT_CONTROL) AND is_transactable_upd = 1) then

Line 163: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'

159: end if;
160: /* 5523531 - Condition only applies when Transactable flag of item is changed by the status */
161: SELECT count(*) INTO is_bom_enabled_upd
162: FROM mtl_status_attribute_values
163: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'
164: AND attribute_value = 'N'
165: AND inventory_item_status_code = p_pending_status;
166:
167: /*commented for bug 5479302

Line 198: FROM mtl_system_items_b msi

194: Sum(Decode(mav.attribute_name,G_CUSTOMER_ENABLED ,Decode(mav.attribute_value,'N',Decode(msi.orderable_on_web_flag,'Y',1,0),0),0)) uncheck_orderable_err
195: INTO G_TRANSACTABLE
196: ,G_PURCHASABLE
197: ,G_ORDERABLE
198: FROM mtl_system_items_b msi
199: ,mtl_status_attribute_values mav
200: WHERE msi.inventory_item_id = p_Item_Id
201: AND msi.organization_id = p_Org_Id
202: AND mav.inventory_item_status_code = p_pending_status

Line 214: UPDATE mtl_system_items msi

210: ) THEN
211:
212: /* Lock is success - Update Item status */
213:
214: UPDATE mtl_system_items msi
215: SET (inventory_item_status_code,
216: last_update_date,
217: last_updated_by,
218: last_update_login) =

Line 241: UPDATE mtl_system_items msi

237: AND p1.master_organization_id = p2.master_organization_id)));
238:
239: /* Update all the Eight Item Attributes */
240:
241: UPDATE mtl_system_items msi
242: SET msi.stock_enabled_flag =
243: ( SELECT DECODE(mti.inventory_item_flag,'N','N',v.attribute_value)
244: FROM mtl_status_attribute_values v,
245: mtl_item_attributes a,

Line 246: mtl_system_items mti

242: SET msi.stock_enabled_flag =
243: ( SELECT DECODE(mti.inventory_item_flag,'N','N',v.attribute_value)
244: FROM mtl_status_attribute_values v,
245: mtl_item_attributes a,
246: mtl_system_items mti
247: WHERE v.inventory_item_status_code = p_pending_status
248: AND a.attribute_name = G_STOCK_ENABLED
249: AND a.attribute_name = v.attribute_name
250: AND mti.inventory_item_id = p_Item_Id

Line 265: UPDATE mtl_system_items msi

261: mtl_parameters p2
262: WHERE p1.organization_id = p_Org_Id
263: AND p1.master_organization_id = p2.master_organization_id)));
264:
265: UPDATE mtl_system_items msi
266: SET msi.mtl_transactions_enabled_flag =
267: ( SELECT DECODE (mti.stock_enabled_flag,'N','N', v.attribute_value)
268: FROM mtl_status_attribute_values v,
269: mtl_item_attributes a,

Line 270: mtl_system_items mti

266: SET msi.mtl_transactions_enabled_flag =
267: ( SELECT DECODE (mti.stock_enabled_flag,'N','N', v.attribute_value)
268: FROM mtl_status_attribute_values v,
269: mtl_item_attributes a,
270: mtl_system_items mti
271: WHERE v.inventory_item_status_code = p_pending_status
272: AND a.attribute_name = G_TRANSACTIONS_ENABLED
273: AND a.attribute_name = v.attribute_name
274: AND mti.inventory_item_id = p_Item_Id

Line 290: UPDATE mtl_system_items msi

286: WHERE p1.organization_id = p_Org_Id
287: AND p1.master_organization_id = p2.master_organization_id)));
288:
289: /* Updating pending Item Status */
290: UPDATE mtl_system_items msi
291: SET msi.purchasing_enabled_flag =
292: (SELECT DECODE(mti.purchasing_item_flag,'N','N',v.attribute_value)
293: FROM mtl_status_attribute_values v,
294: mtl_item_attributes a,

Line 295: mtl_system_items mti

291: SET msi.purchasing_enabled_flag =
292: (SELECT DECODE(mti.purchasing_item_flag,'N','N',v.attribute_value)
293: FROM mtl_status_attribute_values v,
294: mtl_item_attributes a,
295: mtl_system_items mti
296: WHERE v.inventory_item_status_code = p_pending_status
297: AND a.attribute_name = G_PURCHASING_ENABLED
298: AND a.attribute_name = v.attribute_name
299: AND mti.inventory_item_id = p_Item_Id

Line 314: UPDATE mtl_system_items msi

310: mtl_parameters p2
311: WHERE p1.organization_id = p_Org_Id
312: AND p1.master_organization_id = p2.master_organization_id)));
313:
314: UPDATE mtl_system_items msi
315: SET msi.invoice_enabled_flag =
316: ( SELECT DECODE(mti.invoiceable_item_flag,'N','N',v.attribute_value)
317: FROM mtl_status_attribute_values v,
318: mtl_item_attributes a,

Line 319: mtl_system_items mti

315: SET msi.invoice_enabled_flag =
316: ( SELECT DECODE(mti.invoiceable_item_flag,'N','N',v.attribute_value)
317: FROM mtl_status_attribute_values v,
318: mtl_item_attributes a,
319: mtl_system_items mti
320: WHERE v.inventory_item_status_code = p_pending_status
321: AND a.attribute_name = G_INVOICE_ENABLED
322: AND a.attribute_name = v.attribute_name
323: AND mti.inventory_item_id = p_Item_Id

Line 338: UPDATE mtl_system_items msi

334: mtl_parameters p2
335: WHERE p1.organization_id = p_Org_Id
336: AND p1.master_organization_id = p2.master_organization_id)));
337:
338: UPDATE mtl_system_items msi
339: SET msi.build_in_wip_flag =
340: ( SELECT DECODE(mti.inventory_item_flag,'N','N',decode(mti.bom_item_type,4,v.attribute_value,'N'))
341: FROM mtl_status_attribute_values v,
342: mtl_item_attributes a,

Line 343: mtl_system_items mti

339: SET msi.build_in_wip_flag =
340: ( SELECT DECODE(mti.inventory_item_flag,'N','N',decode(mti.bom_item_type,4,v.attribute_value,'N'))
341: FROM mtl_status_attribute_values v,
342: mtl_item_attributes a,
343: mtl_system_items mti
344: WHERE v.inventory_item_status_code = p_pending_status
345: AND a.attribute_name = G_BUILD_IN_WIP
346: AND a.attribute_name = v.attribute_name
347: AND mti.inventory_item_id = p_Item_Id

Line 363: UPDATE mtl_system_items msi

359: mtl_parameters p2
360: WHERE p1.organization_id = p_Org_Id
361: AND p1.master_organization_id = p2.master_organization_id)));
362:
363: UPDATE mtl_system_items msi
364: SET msi.customer_order_enabled_flag =
365: ( SELECT DECODE(mti.customer_order_flag,'N','N',v.attribute_value)
366: FROM mtl_status_attribute_values v,
367: mtl_item_attributes a,

Line 368: mtl_system_items mti

364: SET msi.customer_order_enabled_flag =
365: ( SELECT DECODE(mti.customer_order_flag,'N','N',v.attribute_value)
366: FROM mtl_status_attribute_values v,
367: mtl_item_attributes a,
368: mtl_system_items mti
369: WHERE v.inventory_item_status_code = p_pending_status
370: AND a.attribute_name = G_CUSTOMER_ENABLED
371: AND a.attribute_name = v.attribute_name
372: AND mti.inventory_item_id = p_Item_Id

Line 388: UPDATE mtl_system_items msi

384: WHERE p1.organization_id = p_Org_Id
385: AND p1.master_organization_id = p2.master_organization_id)));
386:
387:
388: UPDATE mtl_system_items msi
389: SET msi.internal_order_enabled_flag =
390: ( SELECT DECODE(mti.internal_order_flag,'N','N',v.attribute_value)
391: FROM mtl_status_attribute_values v,
392: mtl_item_attributes a,

Line 393: mtl_system_items mti

389: SET msi.internal_order_enabled_flag =
390: ( SELECT DECODE(mti.internal_order_flag,'N','N',v.attribute_value)
391: FROM mtl_status_attribute_values v,
392: mtl_item_attributes a,
393: mtl_system_items mti
394: WHERE v.inventory_item_status_code = p_pending_status
395: AND a.attribute_name = G_INTERNAL_ENABLED
396: AND a.attribute_name = v.attribute_name
397: AND mti.inventory_item_id = p_Item_Id

Line 413: UPDATE mtl_system_items msi

409: WHERE p1.organization_id = p_Org_Id
410: AND p1.master_organization_id = p2.master_organization_id)));
411:
412:
413: UPDATE mtl_system_items msi
414: SET msi.bom_enabled_flag =
415: ( SELECT v.attribute_value --Bug:3546140DECODE(mti.inventory_item_flag,'N','N',v.attribute_value)
416: FROM mtl_status_attribute_values v,
417: mtl_item_attributes a

Line 418: --Bug:3546140 ,mtl_system_items mti

414: SET msi.bom_enabled_flag =
415: ( SELECT v.attribute_value --Bug:3546140DECODE(mti.inventory_item_flag,'N','N',v.attribute_value)
416: FROM mtl_status_attribute_values v,
417: mtl_item_attributes a
418: --Bug:3546140 ,mtl_system_items mti
419: WHERE v.inventory_item_status_code = p_pending_status
420: AND a.attribute_name = G_BOM_ENABLED
421: AND a.attribute_name = v.attribute_name
422: -- AND mti.inventory_item_id = p_Item_Id

Line 440: UPDATE mtl_system_items msi

436: AND p1.master_organization_id = p2.master_organization_id)));
437:
438: /* Start Bug 3713912 */
439: --update recipe enabled flag based on status
440: UPDATE mtl_system_items msi
441: SET msi.recipe_enabled_flag =
442: (SELECT v.attribute_value
443: FROM mtl_status_attribute_values v,
444: mtl_item_attributes a

Line 462: UPDATE mtl_system_items msi

458: AND p1.master_organization_id = p2.master_organization_id)));
459:
460: --update process_execution enabled flag based on status
461: --Bug 5346921 process execution enabled should not be enabled if either inventory flag is 'N' or recipe enabled is 'N'
462: UPDATE mtl_system_items msi
463: SET msi.PROCESS_EXECUTION_ENABLED_FLAG =
464: (SELECT decode(msi.inventory_item_flag,'N','N',
465: decode(msi.recipe_enabled_flag,'N','N',v.attribute_value))
466: FROM mtl_status_attribute_values v,