APPS.CZ_BOM_SYNCH dependencies on MTL_DESCR_ELEMENT_VALUES

Line 582: elementValue mtl_descr_element_values.element_value%TYPE;

578:
579: PROCEDURE verify_item_properties(j IN PLS_INTEGER) IS
580:
581: TL_TEXT_TYPE CONSTANT NUMBER := 8;
582: elementValue mtl_descr_element_values.element_value%TYPE;
583: l_val VARCHAR2(4000);
584: l_flag PLS_INTEGER;
585: position NUMBER;
586: l_src_application_id cz_properties.src_application_id%TYPE;

Line 668: 'SELECT element_value FROM mtl_descr_element_values' || targetLinkName ||

664: ELSE
665: -- not an APC attribute
666:
667: EXECUTE IMMEDIATE
668: 'SELECT element_value FROM mtl_descr_element_values' || targetLinkName ||
669: ' WHERE inventory_item_id = :1' ||
670: ' AND element_name = :2'
671: INTO elementValue
672: USING itemInventoryId, c_prop.name;