APPS.BOM_BOMRBOMS_XMLP_PKG dependencies on MTL_DESCRIPTIVE_ELEMENTS

Line 646: MTL_DESCRIPTIVE_ELEMENTS

642: SELECT
643: DESCRIPTION
644: INTO L_DESC
645: FROM
646: MTL_DESCRIPTIVE_ELEMENTS
647: WHERE ITEM_CATALOG_GROUP_ID = L_CATALOG_GROUP_ID
648: AND ELEMENT_NAME = L_ELEMENT_NAME;
649: ELSIF L_ITEM_TYPE = 2 THEN
650: SELECT

Line 654: MTL_DESCRIPTIVE_ELEMENTS

650: SELECT
651: MIN(DESCRIPTION)
652: INTO L_DESC
653: FROM
654: MTL_DESCRIPTIVE_ELEMENTS
655: WHERE ELEMENT_NAME = L_ELEMENT_NAME;
656: END IF;
657: RETURN (L_DESC);
658: END GET_ELE_DESC;