APPS.INV_ITEM_PVT dependencies on MTL_ITEM_ATTRIBUTES

Line 27: SUBTYPE Attribute_Code_type IS mtl_item_attributes.attribute_name%TYPE; -- VARCHAR2(50)

23: G_EXC_ERROR EXCEPTION;
24: G_EXC_UNEXPECTED_ERROR EXCEPTION;
25: */
26:
27: SUBTYPE Attribute_Code_type IS mtl_item_attributes.attribute_name%TYPE; -- VARCHAR2(50)
28:
29: TYPE Attribute_Code_tbl_type IS TABLE OF Attribute_Code_type
30: INDEX BY BINARY_INTEGER;
31:

Line 77: FROM mtl_item_attributes

73:
74: CURSOR Master_Attribute_csr
75: IS
76: SELECT SUBSTR(attribute_name, 18) Attribute_Code
77: FROM mtl_item_attributes
78: WHERE control_level = 1
79: AND attribute_group_id_gui IN
80: (20, 25, 30, 31, 35, 40, 41, 51,
81: 60, 62, 65, 70, 80, 90, 100, 120 /* Start Bug 3713912 */,130/* End Bug 3713912 */);

Line 271: FROM mtl_item_attributes

267:
268: -- Added for bug 5236494
269: CURSOR status_attr_control IS
270: SELECT attribute_name, status_control_code
271: FROM mtl_item_attributes
272: WHERE status_control_code IS NOT NULL;
273:
274: CURSOR status_attr_values (p_item_status_code VARCHAR2) IS
275: SELECT attribute_name, attribute_value

Line 5991: l_desc_control mtl_item_attributes.control_level%type;

5987: AND ORGANIZATION_ID <> X_ORGANIZATION_ID)
5988: AND LANGUAGE = X_LANGUAGE
5989: FOR UPDATE OF INVENTORY_ITEM_ID;
5990:
5991: l_desc_control mtl_item_attributes.control_level%type;
5992: l_longdesc_control mtl_item_attributes.control_level%type;
5993:
5994: BEGIN
5995:

Line 5992: l_longdesc_control mtl_item_attributes.control_level%type;

5988: AND LANGUAGE = X_LANGUAGE
5989: FOR UPDATE OF INVENTORY_ITEM_ID;
5990:
5991: l_desc_control mtl_item_attributes.control_level%type;
5992: l_longdesc_control mtl_item_attributes.control_level%type;
5993:
5994: BEGIN
5995:
5996: begin

Line 5999: from mtl_item_attributes

5995:
5996: begin
5997: select control_level
5998: into l_desc_control
5999: from mtl_item_attributes
6000: where attribute_name = 'MTL_SYSTEM_ITEMS.DESCRIPTION';
6001: exception
6002: when no_data_found then
6003: l_desc_control := 0;

Line 6009: from mtl_item_attributes

6005:
6006: begin
6007: select control_level
6008: into l_longdesc_control
6009: from mtl_item_attributes
6010: where attribute_name = 'MTL_SYSTEM_ITEMS.LONG_DESCRIPTION';
6011: exception
6012: when no_data_found then
6013: l_longdesc_control := 0;