eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_POR_EXT_DIAG dependencies on MTL_CATEGORIES_KFV

Line 424: FROM mtl_categories_kfv

420: xWebEnabledFlag,
421: xStartDate,
422: xEndDate,
423: xDisableDate
424: FROM mtl_categories_kfv
425: WHERE structure_id = gStructureId
426: AND concatenated_segments = pValue;
427: EXCEPTION
428: WHEN OTHERS THEN

Line 553: xCategoryName mtl_categories_kfv.concatenated_segments%TYPE;

549: RETURN NUMBER
550: IS
551: xErrLoc PLS_INTEGER := 100;
552: xStatus PLS_INTEGER := VALID_FOR_EXTRACT;
553: xCategoryName mtl_categories_kfv.concatenated_segments%TYPE;
554: xRtCategoryId NUMBER;
555:
556: BEGIN
557: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

Line 577: FROM mtl_categories_kfv

573: WHEN OTHERS THEN
574: xStatus := CATEGORY_NOT_EXTRACTED;
575: SELECT concatenated_segments
576: INTO xCategoryName
577: FROM mtl_categories_kfv
578: WHERE category_id = pCategoryId
579: AND rownum = 1;
580:
581: xErrLoc := 150;