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.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.15.12020000.4 2012/08/31 02:26:04 ecchang 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.15.12020000.4 2012/08/31 02:26:04 ecchang 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.15.12020000.4 2012/08/31 02:26:04 ecchang 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: G_PKG_NAME VARCHAR2(50) := 'INV_ITEM_STATUS_CP';

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: G_PKG_NAME VARCHAR2(50) := 'INV_ITEM_STATUS_CP';
14:

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: G_PKG_NAME VARCHAR2(50) := 'INV_ITEM_STATUS_CP';
14:
15: G_ITEM NUMBER := 1;

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: G_PKG_NAME VARCHAR2(50) := 'INV_ITEM_STATUS_CP';
14:
15: G_ITEM NUMBER := 1;
16: G_ITEM_ORG NUMBER := 2;

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

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

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

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

Line 64: from mtl_system_items_b table.

60:
61: IS
62: /* Start Bug#7454766
63: Declaring Cursor c_get_values_from_msib to fetch values of INVENTORY_ITEM_STATUS_CODE, INTERNAL_ORDER_ENABLED_FLAG, PURCHASING_ENABLED_FLAG,
64: from mtl_system_items_b table.
65: */
66:
67: CURSOR c_get_values_from_msib (p_item_id number,p_org_id number)
68: IS

Line 70: FROM mtl_system_items_b msib

66:
67: CURSOR c_get_values_from_msib (p_item_id number,p_org_id number)
68: IS
69: SELECT INVENTORY_ITEM_STATUS_CODE, INTERNAL_ORDER_ENABLED_FLAG, PURCHASING_ENABLED_FLAG
70: FROM mtl_system_items_b msib
71: WHERE msib.inventory_item_id = p_Item_Id
72: AND msib.organization_id = p_Org_Id;
73:
74: l_status_code mtl_system_items_b.INVENTORY_ITEM_STATUS_CODE%TYPE;

Line 74: l_status_code mtl_system_items_b.INVENTORY_ITEM_STATUS_CODE%TYPE;

70: FROM mtl_system_items_b msib
71: WHERE msib.inventory_item_id = p_Item_Id
72: AND msib.organization_id = p_Org_Id;
73:
74: l_status_code mtl_system_items_b.INVENTORY_ITEM_STATUS_CODE%TYPE;
75: l_purch_enbl mtl_system_items_b.PURCHASING_ENABLED_FLAG%TYPE;
76: l_int_ordr_enbl mtl_system_items_b.INTERNAL_ORDER_ENABLED_FLAG%TYPE;
77:
78: /* End Bug#7454766 */

Line 75: l_purch_enbl mtl_system_items_b.PURCHASING_ENABLED_FLAG%TYPE;

71: WHERE msib.inventory_item_id = p_Item_Id
72: AND msib.organization_id = p_Org_Id;
73:
74: l_status_code mtl_system_items_b.INVENTORY_ITEM_STATUS_CODE%TYPE;
75: l_purch_enbl mtl_system_items_b.PURCHASING_ENABLED_FLAG%TYPE;
76: l_int_ordr_enbl mtl_system_items_b.INTERNAL_ORDER_ENABLED_FLAG%TYPE;
77:
78: /* End Bug#7454766 */
79:

Line 76: l_int_ordr_enbl mtl_system_items_b.INTERNAL_ORDER_ENABLED_FLAG%TYPE;

72: AND msib.organization_id = p_Org_Id;
73:
74: l_status_code mtl_system_items_b.INVENTORY_ITEM_STATUS_CODE%TYPE;
75: l_purch_enbl mtl_system_items_b.PURCHASING_ENABLED_FLAG%TYPE;
76: l_int_ordr_enbl mtl_system_items_b.INTERNAL_ORDER_ENABLED_FLAG%TYPE;
77:
78: /* End Bug#7454766 */
79:
80:

Line 151: FROM mtl_system_items msi

147:
148: /* Check to see wether the row is locked */
149:
150: SELECT 1 INTO l_row_temp
151: FROM mtl_system_items msi
152: WHERE inventory_item_id = p_Item_Id
153: AND ((p_control_level = G_ITEM_ORG and msi.organization_id = p_Org_Id)
154: OR
155: (p_control_level = G_ITEM

Line 169: (SELECT 'X' FROM mtl_system_items

165: /* 5523531 - Condition only applies when Transactable flag of item is changed by the status */
166: SELECT count(*) INTO is_transactable_upd
167: FROM DUAL
168: WHERE EXISTS
169: (SELECT 'X' FROM mtl_system_items
170: WHERE inventory_item_id = p_item_id
171: AND organization_id = p_org_id
172: AND mtl_transactions_enabled_flag <>
173: (SELECT attribute_value FROM mtl_status_attribute_values

Line 174: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG'

170: WHERE inventory_item_id = p_item_id
171: AND organization_id = p_org_id
172: AND mtl_transactions_enabled_flag <>
173: (SELECT attribute_value FROM mtl_status_attribute_values
174: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG'
175: AND inventory_item_status_code = p_pending_status));
176:
177: --Added for Bug: 5230429
178: if (l_trans_cntrl_level in ( G_UNDER_STATUS_CONTROL,G_DEFAULT_CONTROL) AND is_transactable_upd = 1) then

Line 184: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'

180: end if;
181: /* 5523531 - Condition only applies when Transactable flag of item is changed by the status */
182: SELECT count(*) INTO is_bom_enabled_upd
183: FROM mtl_status_attribute_values
184: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'
185: AND attribute_value = 'N'
186: AND inventory_item_status_code = p_pending_status;
187:
188: /*commented for bug 5479302

Line 219: FROM mtl_system_items_b msi

215: 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
216: INTO G_TRANSACTABLE
217: ,G_PURCHASABLE
218: ,G_ORDERABLE
219: FROM mtl_system_items_b msi
220: ,mtl_status_attribute_values mav
221: WHERE msi.inventory_item_id = p_Item_Id
222: AND msi.organization_id = p_Org_Id
223: AND mav.inventory_item_status_code = p_pending_status

Line 235: UPDATE mtl_system_items msi

231: ) THEN
232:
233: /* Lock is success - Update Item status */
234:
235: UPDATE mtl_system_items msi
236: SET (inventory_item_status_code,
237: last_update_date,
238: last_updated_by,
239: last_update_login) =

Line 262: UPDATE mtl_system_items msi

258: AND p1.master_organization_id = p2.master_organization_id)));
259:
260: /* Update all the Eight Item Attributes */
261:
262: UPDATE mtl_system_items msi
263: SET msi.stock_enabled_flag =
264: ( SELECT DECODE(mti.inventory_item_flag,'N','N',v.attribute_value)
265: FROM mtl_status_attribute_values v,
266: mtl_item_attributes a,

Line 267: mtl_system_items mti

263: SET msi.stock_enabled_flag =
264: ( SELECT DECODE(mti.inventory_item_flag,'N','N',v.attribute_value)
265: FROM mtl_status_attribute_values v,
266: mtl_item_attributes a,
267: mtl_system_items mti
268: WHERE v.inventory_item_status_code = p_pending_status
269: AND a.attribute_name = G_STOCK_ENABLED
270: AND a.attribute_name = v.attribute_name
271: AND mti.inventory_item_id = p_Item_Id

Line 286: UPDATE mtl_system_items msi

282: mtl_parameters p2
283: WHERE p1.organization_id = p_Org_Id
284: AND p1.master_organization_id = p2.master_organization_id)));
285:
286: UPDATE mtl_system_items msi
287: SET msi.mtl_transactions_enabled_flag =
288: ( SELECT DECODE (mti.stock_enabled_flag,'N','N', v.attribute_value)
289: FROM mtl_status_attribute_values v,
290: mtl_item_attributes a,

Line 291: mtl_system_items mti

287: SET msi.mtl_transactions_enabled_flag =
288: ( SELECT DECODE (mti.stock_enabled_flag,'N','N', v.attribute_value)
289: FROM mtl_status_attribute_values v,
290: mtl_item_attributes a,
291: mtl_system_items mti
292: WHERE v.inventory_item_status_code = p_pending_status
293: AND a.attribute_name = G_TRANSACTIONS_ENABLED
294: AND a.attribute_name = v.attribute_name
295: AND mti.inventory_item_id = p_Item_Id

Line 311: UPDATE mtl_system_items msi

307: WHERE p1.organization_id = p_Org_Id
308: AND p1.master_organization_id = p2.master_organization_id)));
309:
310: /* Updating pending Item Status */
311: UPDATE mtl_system_items msi
312: SET msi.purchasing_enabled_flag =
313: (SELECT DECODE(mti.purchasing_item_flag,'N','N',v.attribute_value)
314: FROM mtl_status_attribute_values v,
315: mtl_item_attributes a,

Line 316: mtl_system_items mti

312: SET msi.purchasing_enabled_flag =
313: (SELECT DECODE(mti.purchasing_item_flag,'N','N',v.attribute_value)
314: FROM mtl_status_attribute_values v,
315: mtl_item_attributes a,
316: mtl_system_items mti
317: WHERE v.inventory_item_status_code = p_pending_status
318: AND a.attribute_name = G_PURCHASING_ENABLED
319: AND a.attribute_name = v.attribute_name
320: AND mti.inventory_item_id = p_Item_Id

Line 335: UPDATE mtl_system_items msi

331: mtl_parameters p2
332: WHERE p1.organization_id = p_Org_Id
333: AND p1.master_organization_id = p2.master_organization_id)));
334:
335: UPDATE mtl_system_items msi
336: SET msi.invoice_enabled_flag =
337: ( SELECT DECODE(mti.invoiceable_item_flag,'N','N',v.attribute_value)
338: FROM mtl_status_attribute_values v,
339: mtl_item_attributes a,

Line 340: mtl_system_items mti

336: SET msi.invoice_enabled_flag =
337: ( SELECT DECODE(mti.invoiceable_item_flag,'N','N',v.attribute_value)
338: FROM mtl_status_attribute_values v,
339: mtl_item_attributes a,
340: mtl_system_items mti
341: WHERE v.inventory_item_status_code = p_pending_status
342: AND a.attribute_name = G_INVOICE_ENABLED
343: AND a.attribute_name = v.attribute_name
344: AND mti.inventory_item_id = p_Item_Id

Line 359: UPDATE mtl_system_items msi

355: mtl_parameters p2
356: WHERE p1.organization_id = p_Org_Id
357: AND p1.master_organization_id = p2.master_organization_id)));
358:
359: UPDATE mtl_system_items msi
360: SET msi.build_in_wip_flag =
361: ( SELECT DECODE(mti.inventory_item_flag,'N','N',decode(mti.bom_item_type,4,v.attribute_value,'N'))
362: FROM mtl_status_attribute_values v,
363: mtl_item_attributes a,

Line 364: mtl_system_items mti

360: SET msi.build_in_wip_flag =
361: ( SELECT DECODE(mti.inventory_item_flag,'N','N',decode(mti.bom_item_type,4,v.attribute_value,'N'))
362: FROM mtl_status_attribute_values v,
363: mtl_item_attributes a,
364: mtl_system_items mti
365: WHERE v.inventory_item_status_code = p_pending_status
366: AND a.attribute_name = G_BUILD_IN_WIP
367: AND a.attribute_name = v.attribute_name
368: AND mti.inventory_item_id = p_Item_Id

Line 384: UPDATE mtl_system_items msi

380: mtl_parameters p2
381: WHERE p1.organization_id = p_Org_Id
382: AND p1.master_organization_id = p2.master_organization_id)));
383:
384: UPDATE mtl_system_items msi
385: SET msi.customer_order_enabled_flag =
386: ( SELECT DECODE(mti.customer_order_flag,'N','N',v.attribute_value)
387: FROM mtl_status_attribute_values v,
388: mtl_item_attributes a,

Line 389: mtl_system_items mti

385: SET msi.customer_order_enabled_flag =
386: ( SELECT DECODE(mti.customer_order_flag,'N','N',v.attribute_value)
387: FROM mtl_status_attribute_values v,
388: mtl_item_attributes a,
389: mtl_system_items mti
390: WHERE v.inventory_item_status_code = p_pending_status
391: AND a.attribute_name = G_CUSTOMER_ENABLED
392: AND a.attribute_name = v.attribute_name
393: AND mti.inventory_item_id = p_Item_Id

Line 409: UPDATE mtl_system_items msi

405: WHERE p1.organization_id = p_Org_Id
406: AND p1.master_organization_id = p2.master_organization_id)));
407:
408:
409: UPDATE mtl_system_items msi
410: SET msi.internal_order_enabled_flag =
411: ( SELECT DECODE(mti.internal_order_flag,'N','N',v.attribute_value)
412: FROM mtl_status_attribute_values v,
413: mtl_item_attributes a,

Line 414: mtl_system_items mti

410: SET msi.internal_order_enabled_flag =
411: ( SELECT DECODE(mti.internal_order_flag,'N','N',v.attribute_value)
412: FROM mtl_status_attribute_values v,
413: mtl_item_attributes a,
414: mtl_system_items mti
415: WHERE v.inventory_item_status_code = p_pending_status
416: AND a.attribute_name = G_INTERNAL_ENABLED
417: AND a.attribute_name = v.attribute_name
418: AND mti.inventory_item_id = p_Item_Id

Line 434: UPDATE mtl_system_items msi

430: WHERE p1.organization_id = p_Org_Id
431: AND p1.master_organization_id = p2.master_organization_id)));
432:
433:
434: UPDATE mtl_system_items msi
435: SET msi.bom_enabled_flag =
436: ( SELECT v.attribute_value --Bug:3546140DECODE(mti.inventory_item_flag,'N','N',v.attribute_value)
437: FROM mtl_status_attribute_values v,
438: mtl_item_attributes a

Line 439: --Bug:3546140 ,mtl_system_items mti

435: SET msi.bom_enabled_flag =
436: ( SELECT v.attribute_value --Bug:3546140DECODE(mti.inventory_item_flag,'N','N',v.attribute_value)
437: FROM mtl_status_attribute_values v,
438: mtl_item_attributes a
439: --Bug:3546140 ,mtl_system_items mti
440: WHERE v.inventory_item_status_code = p_pending_status
441: AND a.attribute_name = G_BOM_ENABLED
442: AND a.attribute_name = v.attribute_name
443: -- AND mti.inventory_item_id = p_Item_Id

Line 461: UPDATE mtl_system_items msi

457: AND p1.master_organization_id = p2.master_organization_id)));
458:
459: /* Start Bug 3713912 */
460: --update recipe enabled flag based on status
461: UPDATE mtl_system_items msi
462: SET msi.recipe_enabled_flag =
463: (SELECT v.attribute_value
464: FROM mtl_status_attribute_values v,
465: mtl_item_attributes a

Line 483: UPDATE mtl_system_items msi

479: AND p1.master_organization_id = p2.master_organization_id)));
480:
481: --update process_execution enabled flag based on status
482: --Bug 5346921 process execution enabled should not be enabled if either inventory flag is 'N' or recipe enabled is 'N'
483: UPDATE mtl_system_items msi
484: SET msi.PROCESS_EXECUTION_ENABLED_FLAG =
485: (SELECT decode(msi.inventory_item_flag,'N','N',
486: decode(msi.recipe_enabled_flag,'N','N',v.attribute_value))
487: FROM mtl_status_attribute_values v,

Line 910: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';

906: CURSOR c_get_control_level
907: IS
908: SELECT control_level
909: FROM mtl_item_attributes
910: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
911:
912: BEGIN
913:
914: -- Standard Start of API savepoint