DBA Data[Home] [Help]

APPS.INVUPD2B dependencies on MTL_ITEM_ATTRIBUTES

Line 368: FROM mtl_item_attributes

364: CURSOR C_item_attributes
365: IS
366: SELECT attribute_name
367: , control_level
368: FROM mtl_item_attributes
369: WHERE
370: control_level = 1
371: AND attribute_group_id_gui IN
372: (20, 25, 30, 31, 35, 40, 41, 51,

Line 810: FROM MTL_ITEM_ATTRIBUTES

806: ) IS
807:
808: CURSOR c_master_attributes IS
809: SELECT SUBSTR(ATTRIBUTE_NAME,18) Attribute_Code
810: FROM MTL_ITEM_ATTRIBUTES
811: WHERE CONTROL_LEVEL = 1
812: AND (ATTRIBUTE_GROUP_ID_GUI IN
813: (20, 25, 30, 31, 35, 40, 41, 51, 60,
814: 62, 65, 70, 80, 90, 100, 120, 130));

Line 816: l_Attribute_Code mtl_item_attributes.attribute_name%TYPE;

812: AND (ATTRIBUTE_GROUP_ID_GUI IN
813: (20, 25, 30, 31, 35, 40, 41, 51, 60,
814: 62, 65, 70, 80, 90, 100, 120, 130));
815:
816: l_Attribute_Code mtl_item_attributes.attribute_name%TYPE;
817: m_Item_rec MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;
818: l_Item_rec MTL_SYSTEM_ITEMS_VL%ROWTYPE;
819: l_create_child BOOLEAN := FALSE;
820: