APPS.EGO_PUBLICATION_PKG dependencies on MTL_SYSTEM_ITEMS_TL

Line 301: MSIT.description))) FROM MTL_SYSTEM_ITEMS_TL MSIT WHERE MSIT.INVENTORY_ITEM_ID = '|| itemId || 'AND MSIT.ORGANIZATION_ID = ' || orgId || '

297:
298: IF (p_language IS NOT NULL) THEN
299:
300: x_query := 'SELECT XMLAGG(XMLCONCAT(XMLELEMENT("DESCRIPTION",XMLATTRIBUTES(MSIT.language AS "languageId"),
301: MSIT.description))) FROM MTL_SYSTEM_ITEMS_TL MSIT WHERE MSIT.INVENTORY_ITEM_ID = '|| itemId || 'AND MSIT.ORGANIZATION_ID = ' || orgId || '
302: AND MSIT.language = '|| '''' || p_language || '''' ;
303:
304: Execute Immediate x_query
305: INTO x_temp;

Line 313: FROM MTL_SYSTEM_ITEMS_TL msit

309: --- Generate Description Elements without Language clause--------
310: SELECT XMLAGG(XMLCONCAT(XMLELEMENT("Description",XMLATTRIBUTES(MSIT.language AS "languageID"),
311: MSIT.description)))
312: INTO x_temp
313: FROM MTL_SYSTEM_ITEMS_TL msit
314: WHERE msit.INVENTORY_ITEM_ID = itemId
315: AND msit.ORGANIZATION_ID = orgId;
316: END IF;
317: