APPS.INV_ITEM_STATUS_CP dependencies on MTL_STATUS_ATTRIBUTE_VALUES

Line 152: (SELECT attribute_value FROM mtl_status_attribute_values

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

Line 162: FROM mtl_status_attribute_values

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

Line 199: ,mtl_status_attribute_values mav

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

Line 223: FROM mtl_status_attribute_values v,

219: (SELECT p_pending_status,
220: sysdate,
221: G_USER_ID,
222: G_USER_ID
223: FROM mtl_status_attribute_values v,
224: mtl_item_attributes a
225: WHERE v.inventory_item_status_code = p_pending_status
226: AND a.attribute_name = G_STOCK_ENABLED
227: AND a.attribute_name = v.attribute_name)

Line 244: FROM mtl_status_attribute_values v,

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,
246: mtl_system_items mti
247: WHERE v.inventory_item_status_code = p_pending_status
248: AND a.attribute_name = G_STOCK_ENABLED

Line 268: FROM mtl_status_attribute_values v,

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,
270: mtl_system_items mti
271: WHERE v.inventory_item_status_code = p_pending_status
272: AND a.attribute_name = G_TRANSACTIONS_ENABLED

Line 293: FROM mtl_status_attribute_values v,

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,
295: mtl_system_items mti
296: WHERE v.inventory_item_status_code = p_pending_status
297: AND a.attribute_name = G_PURCHASING_ENABLED

Line 317: FROM mtl_status_attribute_values v,

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,
319: mtl_system_items mti
320: WHERE v.inventory_item_status_code = p_pending_status
321: AND a.attribute_name = G_INVOICE_ENABLED

Line 341: FROM mtl_status_attribute_values v,

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,
343: mtl_system_items mti
344: WHERE v.inventory_item_status_code = p_pending_status
345: AND a.attribute_name = G_BUILD_IN_WIP

Line 366: FROM mtl_status_attribute_values v,

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,
368: mtl_system_items mti
369: WHERE v.inventory_item_status_code = p_pending_status
370: AND a.attribute_name = G_CUSTOMER_ENABLED

Line 391: FROM mtl_status_attribute_values v,

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,
393: mtl_system_items mti
394: WHERE v.inventory_item_status_code = p_pending_status
395: AND a.attribute_name = G_INTERNAL_ENABLED

Line 416: FROM mtl_status_attribute_values v,

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

Line 443: FROM mtl_status_attribute_values v,

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
445: WHERE v.inventory_item_status_code = p_pending_status
446: AND a.attribute_name = G_RECIPE_ENABLED
447: AND a.attribute_name = v.attribute_name)

Line 466: FROM mtl_status_attribute_values v,

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,
467: mtl_item_attributes a
468: WHERE v.inventory_item_status_code = p_pending_status
469: AND a.attribute_name = G_PROCESS_EXECUTION_ENABLED
470: AND a.attribute_name = v.attribute_name)