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,control_level /*Bug#6911195 Added control_level*/
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 282: FROM mtl_status_attribute_values status, mtl_item_attributes control

278:
279: -- bug 9944329, get org level controlled status attributes
280: CURSOR org_status_attr_values_csr (p_item_status_code VARCHAR2) IS
281: SELECT status.attribute_name, attribute_value, status_control_code
282: FROM mtl_status_attribute_values status, mtl_item_attributes control
283: WHERE inventory_item_status_code =p_item_status_code
284: AND status.attribute_name = control.attribute_name
285: AND control_level = 2;
286:

Line 692: FROM mtl_item_attributes

688:
689: -- bug 9944329, get status code attribute control level
690: SELECT control_level
691: INTO l_status_code_control_level
692: FROM mtl_item_attributes
693: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
694: --------------------------------
695: LOOP -- loop through org items
696:

Line 4859: AND (1=(select control_level from mtl_item_attributes

4855: OR ORGANIZATION_ID IN
4856: (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS
4857: WHERE MASTER_ORGANIZATION_ID = org_id
4858: AND PRIMARY_COST_METHOD in (2,5,6)
4859: AND (1=(select control_level from mtl_item_attributes
4860: where attribute_name= 'MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG')
4861: )
4862: );
4863: -- Bug 8512945 with base bug 8417326 : End

Line 4869: from mtl_item_attributes

4865: BEGIN
4866:
4867: -- Bug 8512945 with base bug 8417326 : Start
4868: select control_level INTO l_control_level
4869: from mtl_item_attributes
4870: where attribute_name= 'MTL_SYSTEM_ITEMS.PLANNING_MAKE_BUY_CODE';
4871:
4872: -- Loop through the child orgs if the inv asset flag are controlled at master level
4873: OPEN c_get_child_costing_orgs(org_id => P_Item_rec.organization_id);

Line 6480: l_desc_control mtl_item_attributes.control_level%type;

6476: AND ORGANIZATION_ID <> X_ORGANIZATION_ID)
6477: AND LANGUAGE = X_LANGUAGE
6478: FOR UPDATE OF INVENTORY_ITEM_ID;
6479:
6480: l_desc_control mtl_item_attributes.control_level%type;
6481: l_longdesc_control mtl_item_attributes.control_level%type;
6482:
6483: BEGIN
6484:

Line 6481: l_longdesc_control mtl_item_attributes.control_level%type;

6477: AND LANGUAGE = X_LANGUAGE
6478: FOR UPDATE OF INVENTORY_ITEM_ID;
6479:
6480: l_desc_control mtl_item_attributes.control_level%type;
6481: l_longdesc_control mtl_item_attributes.control_level%type;
6482:
6483: BEGIN
6484:
6485: begin

Line 6488: from mtl_item_attributes

6484:
6485: begin
6486: select control_level
6487: into l_desc_control
6488: from mtl_item_attributes
6489: where attribute_name = 'MTL_SYSTEM_ITEMS.DESCRIPTION';
6490: exception
6491: when no_data_found then
6492: l_desc_control := 0;

Line 6498: from mtl_item_attributes

6494:
6495: begin
6496: select control_level
6497: into l_longdesc_control
6498: from mtl_item_attributes
6499: where attribute_name = 'MTL_SYSTEM_ITEMS.LONG_DESCRIPTION';
6500: exception
6501: when no_data_found then
6502: l_longdesc_control := 0;