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.

[Home] [Help]

APPS.INV_ITEM_STATUS_CP dependencies on MTL_ITEM_ATTRIBUTES

Line 85: FROM mtl_item_attributes

81:
82: CURSOR c_get_status_control (cp_attrib_name VARCHAR2)
83: IS
84: SELECT status_control_code
85: FROM mtl_item_attributes
86: WHERE attribute_name = cp_attrib_name;
87:
88: l_stock_cntrl_level mtl_item_attributes.status_control_code%TYPE;
89: l_trans_cntrl_level mtl_item_attributes.status_control_code%TYPE;

Line 88: l_stock_cntrl_level mtl_item_attributes.status_control_code%TYPE;

84: SELECT status_control_code
85: FROM mtl_item_attributes
86: WHERE attribute_name = cp_attrib_name;
87:
88: l_stock_cntrl_level mtl_item_attributes.status_control_code%TYPE;
89: l_trans_cntrl_level mtl_item_attributes.status_control_code%TYPE;
90: l_purch_cntrl_level mtl_item_attributes.status_control_code%TYPE;
91: l_invoice_cntrl_level mtl_item_attributes.status_control_code%TYPE;
92: l_wip_cntrl_level mtl_item_attributes.status_control_code%TYPE;

Line 89: l_trans_cntrl_level mtl_item_attributes.status_control_code%TYPE;

85: FROM mtl_item_attributes
86: WHERE attribute_name = cp_attrib_name;
87:
88: l_stock_cntrl_level mtl_item_attributes.status_control_code%TYPE;
89: l_trans_cntrl_level mtl_item_attributes.status_control_code%TYPE;
90: l_purch_cntrl_level mtl_item_attributes.status_control_code%TYPE;
91: l_invoice_cntrl_level mtl_item_attributes.status_control_code%TYPE;
92: l_wip_cntrl_level mtl_item_attributes.status_control_code%TYPE;
93: l_cust_cntrl_level mtl_item_attributes.status_control_code%TYPE;

Line 90: l_purch_cntrl_level mtl_item_attributes.status_control_code%TYPE;

86: WHERE attribute_name = cp_attrib_name;
87:
88: l_stock_cntrl_level mtl_item_attributes.status_control_code%TYPE;
89: l_trans_cntrl_level mtl_item_attributes.status_control_code%TYPE;
90: l_purch_cntrl_level mtl_item_attributes.status_control_code%TYPE;
91: l_invoice_cntrl_level mtl_item_attributes.status_control_code%TYPE;
92: l_wip_cntrl_level mtl_item_attributes.status_control_code%TYPE;
93: l_cust_cntrl_level mtl_item_attributes.status_control_code%TYPE;
94: l_int_cntrl_level mtl_item_attributes.status_control_code%TYPE;

Line 91: l_invoice_cntrl_level mtl_item_attributes.status_control_code%TYPE;

87:
88: l_stock_cntrl_level mtl_item_attributes.status_control_code%TYPE;
89: l_trans_cntrl_level mtl_item_attributes.status_control_code%TYPE;
90: l_purch_cntrl_level mtl_item_attributes.status_control_code%TYPE;
91: l_invoice_cntrl_level mtl_item_attributes.status_control_code%TYPE;
92: l_wip_cntrl_level mtl_item_attributes.status_control_code%TYPE;
93: l_cust_cntrl_level mtl_item_attributes.status_control_code%TYPE;
94: l_int_cntrl_level mtl_item_attributes.status_control_code%TYPE;
95: l_bom_cntrl_level mtl_item_attributes.status_control_code%TYPE;

Line 92: l_wip_cntrl_level mtl_item_attributes.status_control_code%TYPE;

88: l_stock_cntrl_level mtl_item_attributes.status_control_code%TYPE;
89: l_trans_cntrl_level mtl_item_attributes.status_control_code%TYPE;
90: l_purch_cntrl_level mtl_item_attributes.status_control_code%TYPE;
91: l_invoice_cntrl_level mtl_item_attributes.status_control_code%TYPE;
92: l_wip_cntrl_level mtl_item_attributes.status_control_code%TYPE;
93: l_cust_cntrl_level mtl_item_attributes.status_control_code%TYPE;
94: l_int_cntrl_level mtl_item_attributes.status_control_code%TYPE;
95: l_bom_cntrl_level mtl_item_attributes.status_control_code%TYPE;
96: l_row_temp NUMBER :=0;

Line 93: l_cust_cntrl_level mtl_item_attributes.status_control_code%TYPE;

89: l_trans_cntrl_level mtl_item_attributes.status_control_code%TYPE;
90: l_purch_cntrl_level mtl_item_attributes.status_control_code%TYPE;
91: l_invoice_cntrl_level mtl_item_attributes.status_control_code%TYPE;
92: l_wip_cntrl_level mtl_item_attributes.status_control_code%TYPE;
93: l_cust_cntrl_level mtl_item_attributes.status_control_code%TYPE;
94: l_int_cntrl_level mtl_item_attributes.status_control_code%TYPE;
95: l_bom_cntrl_level mtl_item_attributes.status_control_code%TYPE;
96: l_row_temp NUMBER :=0;
97: /* Start Bug 3713912 */

Line 94: l_int_cntrl_level mtl_item_attributes.status_control_code%TYPE;

90: l_purch_cntrl_level mtl_item_attributes.status_control_code%TYPE;
91: l_invoice_cntrl_level mtl_item_attributes.status_control_code%TYPE;
92: l_wip_cntrl_level mtl_item_attributes.status_control_code%TYPE;
93: l_cust_cntrl_level mtl_item_attributes.status_control_code%TYPE;
94: l_int_cntrl_level mtl_item_attributes.status_control_code%TYPE;
95: l_bom_cntrl_level mtl_item_attributes.status_control_code%TYPE;
96: l_row_temp NUMBER :=0;
97: /* Start Bug 3713912 */
98: l_recipe_cntrl_level mtl_item_attributes.status_control_code%TYPE;

Line 95: l_bom_cntrl_level mtl_item_attributes.status_control_code%TYPE;

91: l_invoice_cntrl_level mtl_item_attributes.status_control_code%TYPE;
92: l_wip_cntrl_level mtl_item_attributes.status_control_code%TYPE;
93: l_cust_cntrl_level mtl_item_attributes.status_control_code%TYPE;
94: l_int_cntrl_level mtl_item_attributes.status_control_code%TYPE;
95: l_bom_cntrl_level mtl_item_attributes.status_control_code%TYPE;
96: l_row_temp NUMBER :=0;
97: /* Start Bug 3713912 */
98: l_recipe_cntrl_level mtl_item_attributes.status_control_code%TYPE;
99: l_process_exec_cntrl_level mtl_item_attributes.status_control_code%TYPE;

Line 98: l_recipe_cntrl_level mtl_item_attributes.status_control_code%TYPE;

94: l_int_cntrl_level mtl_item_attributes.status_control_code%TYPE;
95: l_bom_cntrl_level mtl_item_attributes.status_control_code%TYPE;
96: l_row_temp NUMBER :=0;
97: /* Start Bug 3713912 */
98: l_recipe_cntrl_level mtl_item_attributes.status_control_code%TYPE;
99: l_process_exec_cntrl_level mtl_item_attributes.status_control_code%TYPE;
100: /* End Bug 3713912 */
101: is_transactable_upd NUMBER;
102: is_bom_enabled_upd NUMBER;

Line 99: l_process_exec_cntrl_level mtl_item_attributes.status_control_code%TYPE;

95: l_bom_cntrl_level mtl_item_attributes.status_control_code%TYPE;
96: l_row_temp NUMBER :=0;
97: /* Start Bug 3713912 */
98: l_recipe_cntrl_level mtl_item_attributes.status_control_code%TYPE;
99: l_process_exec_cntrl_level mtl_item_attributes.status_control_code%TYPE;
100: /* End Bug 3713912 */
101: is_transactable_upd NUMBER;
102: is_bom_enabled_upd NUMBER;
103:

Line 245: mtl_item_attributes a

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

Line 266: mtl_item_attributes a,

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

Line 290: mtl_item_attributes a,

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

Line 315: mtl_item_attributes a,

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

Line 339: mtl_item_attributes a,

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

Line 363: mtl_item_attributes a,

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

Line 388: mtl_item_attributes a,

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

Line 413: mtl_item_attributes a,

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

Line 438: mtl_item_attributes a

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

Line 465: mtl_item_attributes a

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

Line 488: mtl_item_attributes a

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

Line 637: FROM mtl_item_attributes

633:
634: CURSOR c_get_control_level
635: IS
636: SELECT control_level
637: FROM mtl_item_attributes
638: WHERE attribute_name = G_STATUS_CODE;
639:
640: CURSOR c_get_status_control (cp_attrib_name VARCHAR2)
641: IS

Line 643: FROM mtl_item_attributes

639:
640: CURSOR c_get_status_control (cp_attrib_name VARCHAR2)
641: IS
642: SELECT status_control_code
643: FROM mtl_item_attributes
644: WHERE attribute_name = cp_attrib_name;
645:
646: l_status_code mtl_pending_item_status.status_code%TYPE;
647: l_item_id mtl_pending_item_status.inventory_item_id%TYPE;

Line 649: l_control_level mtl_item_attributes.control_level%TYPE;

645:
646: l_status_code mtl_pending_item_status.status_code%TYPE;
647: l_item_id mtl_pending_item_status.inventory_item_id%TYPE;
648: l_org_id mtl_pending_item_status.organization_id%TYPE;
649: l_control_level mtl_item_attributes.control_level%TYPE;
650: l_done BOOLEAN := FALSE;
651: l_counter NUMBER := 1;
652:
653: l_has_expired_status BOOLEAN := FALSE;

Line 909: FROM mtl_item_attributes

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