APPS.INV_ITEM_STATUS_CP dependencies on MTL_STATUS_ATTRIBUTE_VALUES

Line 173: (SELECT attribute_value FROM mtl_status_attribute_values

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
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

Line 183: FROM mtl_status_attribute_values

179: G_transactable_status := INV_ATTRIBUTE_CONTROL_PVT.transactable_uncheck(p_Org_Id,p_Item_Id);
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:

Line 220: ,mtl_status_attribute_values mav

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
224: AND mav.attribute_name IN (G_TRANSACTIONS_ENABLED,G_PURCHASING_ENABLED,G_CUSTOMER_ENABLED);

Line 244: FROM mtl_status_attribute_values v,

240: (SELECT p_pending_status,
241: sysdate,
242: G_USER_ID,
243: G_USER_ID
244: FROM mtl_status_attribute_values v,
245: mtl_item_attributes a
246: WHERE v.inventory_item_status_code = p_pending_status
247: AND a.attribute_name = G_STOCK_ENABLED
248: AND a.attribute_name = v.attribute_name)

Line 265: FROM mtl_status_attribute_values v,

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,
267: mtl_system_items mti
268: WHERE v.inventory_item_status_code = p_pending_status
269: AND a.attribute_name = G_STOCK_ENABLED

Line 289: FROM mtl_status_attribute_values v,

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,
291: mtl_system_items mti
292: WHERE v.inventory_item_status_code = p_pending_status
293: AND a.attribute_name = G_TRANSACTIONS_ENABLED

Line 314: FROM mtl_status_attribute_values v,

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,
316: mtl_system_items mti
317: WHERE v.inventory_item_status_code = p_pending_status
318: AND a.attribute_name = G_PURCHASING_ENABLED

Line 338: FROM mtl_status_attribute_values v,

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,
340: mtl_system_items mti
341: WHERE v.inventory_item_status_code = p_pending_status
342: AND a.attribute_name = G_INVOICE_ENABLED

Line 362: FROM mtl_status_attribute_values v,

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,
364: mtl_system_items mti
365: WHERE v.inventory_item_status_code = p_pending_status
366: AND a.attribute_name = G_BUILD_IN_WIP

Line 387: FROM mtl_status_attribute_values v,

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,
389: mtl_system_items mti
390: WHERE v.inventory_item_status_code = p_pending_status
391: AND a.attribute_name = G_CUSTOMER_ENABLED

Line 412: FROM mtl_status_attribute_values v,

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,
414: mtl_system_items mti
415: WHERE v.inventory_item_status_code = p_pending_status
416: AND a.attribute_name = G_INTERNAL_ENABLED

Line 437: FROM mtl_status_attribute_values v,

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
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

Line 464: FROM mtl_status_attribute_values v,

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
466: WHERE v.inventory_item_status_code = p_pending_status
467: AND a.attribute_name = G_RECIPE_ENABLED
468: AND a.attribute_name = v.attribute_name)

Line 487: FROM mtl_status_attribute_values v,

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,
488: mtl_item_attributes a
489: WHERE v.inventory_item_status_code = p_pending_status
490: AND a.attribute_name = G_PROCESS_EXECUTION_ENABLED
491: AND a.attribute_name = v.attribute_name)