APPS.BOM_BOMRBOMS_XMLP_PKG dependencies on MTL_DESCRIPTIVE_ELEMENTS

Line 575: MTL_DESCRIPTIVE_ELEMENTS

571: SELECT
572: DESCRIPTION
573: INTO L_DESC
574: FROM
575: MTL_DESCRIPTIVE_ELEMENTS
576: WHERE ITEM_CATALOG_GROUP_ID = L_CATALOG_GROUP_ID
577: AND ELEMENT_NAME = L_ELEMENT_NAME;
578: ELSIF L_ITEM_TYPE = 2 THEN
579: SELECT

Line 583: MTL_DESCRIPTIVE_ELEMENTS

579: SELECT
580: MIN(DESCRIPTION)
581: INTO L_DESC
582: FROM
583: MTL_DESCRIPTIVE_ELEMENTS
584: WHERE ELEMENT_NAME = L_ELEMENT_NAME;
585: END IF;
586: RETURN (L_DESC);
587: END GET_ELE_DESC;