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.EAM_FAILURE_ANALYSIS_PVT dependencies on MTL_OBJECT_GENEALOGY

Line 1821: FROM MTL_OBJECT_GENEALOGY

1817: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
1818: AND MSN.gen_object_id IN
1819: (
1820: SELECT OBJECT_ID --This part will select all children assets
1821: FROM MTL_OBJECT_GENEALOGY
1822: START WITH PARENT_OBJECT_ID IN
1823: (
1824: SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
1825: FROM MTL_SERIAL_NUMBERS MSN,

Line 1913: FROM MTL_OBJECT_GENEALOGY

1909: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
1910: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
1911: AND MSN.gen_object_id IN (
1912: SELECT OBJECT_ID --This part will select all children assets
1913: FROM MTL_OBJECT_GENEALOGY
1914: START WITH PARENT_OBJECT_ID IN
1915: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
1916: FROM CSI_ITEM_INSTANCES CII,
1917: EAM_ASSET_FAILURE_CODES EAFC,

Line 2093: FROM MTL_OBJECT_GENEALOGY

2089: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
2090: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
2091: AND MSN.gen_object_id IN
2092: (SELECT OBJECT_ID --This part will select all children assets
2093: FROM MTL_OBJECT_GENEALOGY
2094: START WITH PARENT_OBJECT_ID IN
2095: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2096: FROM MTL_SERIAL_NUMBERS MSN,
2097: CSI_ITEM_INSTANCES CII

Line 2184: FROM MTL_OBJECT_GENEALOGY

2180: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
2181: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
2182: AND MSN.gen_object_id IN
2183: (SELECT OBJECT_ID --This part will select all children assets
2184: FROM MTL_OBJECT_GENEALOGY
2185: START WITH PARENT_OBJECT_ID IN
2186: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2187: FROM EAM_ASSET_FAILURE_CODES EAFC,
2188: EAM_ASSET_FAILURES EAF,

Line 2396: FROM MTL_OBJECT_GENEALOGY

2392: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
2393: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
2394: AND MSN.gen_object_id IN
2395: (SELECT OBJECT_ID --This part will select all children assets
2396: FROM MTL_OBJECT_GENEALOGY
2397: START WITH PARENT_OBJECT_ID IN
2398: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2399: FROM MTL_SERIAL_NUMBERS MSN,
2400: CSI_ITEM_INSTANCES CII

Line 2601: FROM MTL_OBJECT_GENEALOGY

2597: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
2598: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
2599: AND MSN.gen_object_id IN
2600: (SELECT OBJECT_ID --This part will select all children assets
2601: FROM MTL_OBJECT_GENEALOGY
2602: START WITH PARENT_OBJECT_ID IN
2603: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2604: FROM CSI_ITEM_INSTANCES CII,
2605: EAM_ASSET_FAILURE_CODES EAFC,

Line 2839: FROM MTL_OBJECT_GENEALOGY

2835: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
2836: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
2837: AND MSN.gen_object_id IN
2838: (SELECT OBJECT_ID --This part will select all children assets
2839: FROM MTL_OBJECT_GENEALOGY
2840: START WITH PARENT_OBJECT_ID IN
2841: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2842: FROM MTL_SERIAL_NUMBERS MSN,
2843: CSI_ITEM_INSTANCES CII

Line 2957: FROM MTL_OBJECT_GENEALOGY

2953: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
2954: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
2955: AND MSN.GEN_OBJECT_ID IN
2956: (SELECT OBJECT_ID --This part will select all children assets
2957: FROM MTL_OBJECT_GENEALOGY
2958: START WITH PARENT_OBJECT_ID IN
2959: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2960: FROM CSI_ITEM_INSTANCES CII,
2961: EAM_ASSET_FAILURE_CODES EAFC,

Line 3590: FROM MTL_OBJECT_GENEALOGY

3586: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
3587: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
3588: AND MSN.GEN_OBJECT_ID IN
3589: ( SELECT OBJECT_ID
3590: FROM MTL_OBJECT_GENEALOGY
3591: START WITH PARENT_OBJECT_ID IN
3592: (SELECT GEN_OBJECT_ID PARENT_OBJECT_ID FROM ';
3593: --when it IS required to have a parent failure wo, in order to select the children assets.
3594:

Line 3858: FROM MTL_OBJECT_GENEALOGY

3854: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
3855: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
3856: AND MSN.gen_object_id IN
3857: (SELECT OBJECT_ID
3858: FROM MTL_OBJECT_GENEALOGY
3859: START WITH PARENT_OBJECT_ID IN
3860: (SELECT GEN_OBJECT_ID PARENT_OBJECT_ID FROM';
3861: --when it IS required to have a parent failure wo, in order to select the children assets.
3862: