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_ITEM_ATTRIBUTES

Line 64: FROM mtl_item_attributes

60: IS
61: CURSOR c_get_status_control (cp_attrib_name VARCHAR2)
62: IS
63: SELECT status_control_code
64: FROM mtl_item_attributes
65: WHERE attribute_name = cp_attrib_name;
66:
67: l_stock_cntrl_level mtl_item_attributes.status_control_code%TYPE;
68: l_trans_cntrl_level mtl_item_attributes.status_control_code%TYPE;

Line 67: l_stock_cntrl_level mtl_item_attributes.status_control_code%TYPE;

63: SELECT status_control_code
64: FROM mtl_item_attributes
65: WHERE attribute_name = cp_attrib_name;
66:
67: l_stock_cntrl_level mtl_item_attributes.status_control_code%TYPE;
68: l_trans_cntrl_level mtl_item_attributes.status_control_code%TYPE;
69: l_purch_cntrl_level mtl_item_attributes.status_control_code%TYPE;
70: l_invoice_cntrl_level mtl_item_attributes.status_control_code%TYPE;
71: l_wip_cntrl_level mtl_item_attributes.status_control_code%TYPE;

Line 68: l_trans_cntrl_level mtl_item_attributes.status_control_code%TYPE;

64: FROM mtl_item_attributes
65: WHERE attribute_name = cp_attrib_name;
66:
67: l_stock_cntrl_level mtl_item_attributes.status_control_code%TYPE;
68: l_trans_cntrl_level mtl_item_attributes.status_control_code%TYPE;
69: l_purch_cntrl_level mtl_item_attributes.status_control_code%TYPE;
70: l_invoice_cntrl_level mtl_item_attributes.status_control_code%TYPE;
71: l_wip_cntrl_level mtl_item_attributes.status_control_code%TYPE;
72: l_cust_cntrl_level mtl_item_attributes.status_control_code%TYPE;

Line 69: l_purch_cntrl_level mtl_item_attributes.status_control_code%TYPE;

65: WHERE attribute_name = cp_attrib_name;
66:
67: l_stock_cntrl_level mtl_item_attributes.status_control_code%TYPE;
68: l_trans_cntrl_level mtl_item_attributes.status_control_code%TYPE;
69: l_purch_cntrl_level mtl_item_attributes.status_control_code%TYPE;
70: l_invoice_cntrl_level mtl_item_attributes.status_control_code%TYPE;
71: l_wip_cntrl_level mtl_item_attributes.status_control_code%TYPE;
72: l_cust_cntrl_level mtl_item_attributes.status_control_code%TYPE;
73: l_int_cntrl_level mtl_item_attributes.status_control_code%TYPE;

Line 70: l_invoice_cntrl_level mtl_item_attributes.status_control_code%TYPE;

66:
67: l_stock_cntrl_level mtl_item_attributes.status_control_code%TYPE;
68: l_trans_cntrl_level mtl_item_attributes.status_control_code%TYPE;
69: l_purch_cntrl_level mtl_item_attributes.status_control_code%TYPE;
70: l_invoice_cntrl_level mtl_item_attributes.status_control_code%TYPE;
71: l_wip_cntrl_level mtl_item_attributes.status_control_code%TYPE;
72: l_cust_cntrl_level mtl_item_attributes.status_control_code%TYPE;
73: l_int_cntrl_level mtl_item_attributes.status_control_code%TYPE;
74: l_bom_cntrl_level mtl_item_attributes.status_control_code%TYPE;

Line 71: l_wip_cntrl_level mtl_item_attributes.status_control_code%TYPE;

67: l_stock_cntrl_level mtl_item_attributes.status_control_code%TYPE;
68: l_trans_cntrl_level mtl_item_attributes.status_control_code%TYPE;
69: l_purch_cntrl_level mtl_item_attributes.status_control_code%TYPE;
70: l_invoice_cntrl_level mtl_item_attributes.status_control_code%TYPE;
71: l_wip_cntrl_level mtl_item_attributes.status_control_code%TYPE;
72: l_cust_cntrl_level mtl_item_attributes.status_control_code%TYPE;
73: l_int_cntrl_level mtl_item_attributes.status_control_code%TYPE;
74: l_bom_cntrl_level mtl_item_attributes.status_control_code%TYPE;
75: l_row_temp NUMBER :=0;

Line 72: l_cust_cntrl_level mtl_item_attributes.status_control_code%TYPE;

68: l_trans_cntrl_level mtl_item_attributes.status_control_code%TYPE;
69: l_purch_cntrl_level mtl_item_attributes.status_control_code%TYPE;
70: l_invoice_cntrl_level mtl_item_attributes.status_control_code%TYPE;
71: l_wip_cntrl_level mtl_item_attributes.status_control_code%TYPE;
72: l_cust_cntrl_level mtl_item_attributes.status_control_code%TYPE;
73: l_int_cntrl_level mtl_item_attributes.status_control_code%TYPE;
74: l_bom_cntrl_level mtl_item_attributes.status_control_code%TYPE;
75: l_row_temp NUMBER :=0;
76: /* Start Bug 3713912 */

Line 73: l_int_cntrl_level mtl_item_attributes.status_control_code%TYPE;

69: l_purch_cntrl_level mtl_item_attributes.status_control_code%TYPE;
70: l_invoice_cntrl_level mtl_item_attributes.status_control_code%TYPE;
71: l_wip_cntrl_level mtl_item_attributes.status_control_code%TYPE;
72: l_cust_cntrl_level mtl_item_attributes.status_control_code%TYPE;
73: l_int_cntrl_level mtl_item_attributes.status_control_code%TYPE;
74: l_bom_cntrl_level mtl_item_attributes.status_control_code%TYPE;
75: l_row_temp NUMBER :=0;
76: /* Start Bug 3713912 */
77: l_recipe_cntrl_level mtl_item_attributes.status_control_code%TYPE;

Line 74: l_bom_cntrl_level mtl_item_attributes.status_control_code%TYPE;

70: l_invoice_cntrl_level mtl_item_attributes.status_control_code%TYPE;
71: l_wip_cntrl_level mtl_item_attributes.status_control_code%TYPE;
72: l_cust_cntrl_level mtl_item_attributes.status_control_code%TYPE;
73: l_int_cntrl_level mtl_item_attributes.status_control_code%TYPE;
74: l_bom_cntrl_level mtl_item_attributes.status_control_code%TYPE;
75: l_row_temp NUMBER :=0;
76: /* Start Bug 3713912 */
77: l_recipe_cntrl_level mtl_item_attributes.status_control_code%TYPE;
78: l_process_exec_cntrl_level mtl_item_attributes.status_control_code%TYPE;

Line 77: l_recipe_cntrl_level mtl_item_attributes.status_control_code%TYPE;

73: l_int_cntrl_level mtl_item_attributes.status_control_code%TYPE;
74: l_bom_cntrl_level mtl_item_attributes.status_control_code%TYPE;
75: l_row_temp NUMBER :=0;
76: /* Start Bug 3713912 */
77: l_recipe_cntrl_level mtl_item_attributes.status_control_code%TYPE;
78: l_process_exec_cntrl_level mtl_item_attributes.status_control_code%TYPE;
79: /* End Bug 3713912 */
80: is_transactable_upd NUMBER;
81: is_bom_enabled_upd NUMBER;

Line 78: l_process_exec_cntrl_level mtl_item_attributes.status_control_code%TYPE;

74: l_bom_cntrl_level mtl_item_attributes.status_control_code%TYPE;
75: l_row_temp NUMBER :=0;
76: /* Start Bug 3713912 */
77: l_recipe_cntrl_level mtl_item_attributes.status_control_code%TYPE;
78: l_process_exec_cntrl_level mtl_item_attributes.status_control_code%TYPE;
79: /* End Bug 3713912 */
80: is_transactable_upd NUMBER;
81: is_bom_enabled_upd NUMBER;
82:

Line 224: mtl_item_attributes a

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)
228: WHERE msi.inventory_item_id = p_Item_Id

Line 245: mtl_item_attributes a,

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
249: AND a.attribute_name = v.attribute_name

Line 269: mtl_item_attributes a,

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
273: AND a.attribute_name = v.attribute_name

Line 294: mtl_item_attributes a,

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
298: AND a.attribute_name = v.attribute_name

Line 318: mtl_item_attributes a,

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
322: AND a.attribute_name = v.attribute_name

Line 342: mtl_item_attributes a,

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
346: AND a.attribute_name = v.attribute_name

Line 367: mtl_item_attributes a,

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
371: AND a.attribute_name = v.attribute_name

Line 392: mtl_item_attributes a,

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
396: AND a.attribute_name = v.attribute_name

Line 417: mtl_item_attributes a

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
421: AND a.attribute_name = v.attribute_name

Line 444: mtl_item_attributes a

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)
448: WHERE l_recipe_cntrl_level in ( G_UNDER_STATUS_CONTROL,G_DEFAULT_CONTROL )

Line 467: mtl_item_attributes a

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)
471: WHERE l_process_exec_cntrl_level in ( G_UNDER_STATUS_CONTROL,G_DEFAULT_CONTROL )

Line 563: FROM mtl_item_attributes

559:
560: CURSOR c_get_control_level
561: IS
562: SELECT control_level
563: FROM mtl_item_attributes
564: WHERE attribute_name = G_STATUS_CODE;
565:
566: CURSOR c_get_status_control (cp_attrib_name VARCHAR2)
567: IS

Line 569: FROM mtl_item_attributes

565:
566: CURSOR c_get_status_control (cp_attrib_name VARCHAR2)
567: IS
568: SELECT status_control_code
569: FROM mtl_item_attributes
570: WHERE attribute_name = cp_attrib_name;
571:
572: l_status_code mtl_pending_item_status.status_code%TYPE;
573: l_item_id mtl_pending_item_status.inventory_item_id%TYPE;

Line 575: l_control_level mtl_item_attributes.control_level%TYPE;

571:
572: l_status_code mtl_pending_item_status.status_code%TYPE;
573: l_item_id mtl_pending_item_status.inventory_item_id%TYPE;
574: l_org_id mtl_pending_item_status.organization_id%TYPE;
575: l_control_level mtl_item_attributes.control_level%TYPE;
576: l_done BOOLEAN := FALSE;
577: l_counter NUMBER := 1;
578:
579: BEGIN