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 1838: FROM MTL_OBJECT_GENEALOGY

1834: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
1835: AND MSN.gen_object_id IN
1836: (
1837: SELECT OBJECT_ID --This part will select all children assets
1838: FROM MTL_OBJECT_GENEALOGY
1839: START WITH PARENT_OBJECT_ID IN
1840: (
1841: SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
1842: FROM MTL_SERIAL_NUMBERS MSN,

Line 1930: FROM MTL_OBJECT_GENEALOGY

1926: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
1927: AND MSN.gen_object_id IN
1928: (
1929: SELECT OBJECT_ID --This part will select all children assets
1930: FROM MTL_OBJECT_GENEALOGY
1931: START WITH PARENT_OBJECT_ID IN
1932: (
1933: SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
1934: FROM MTL_SERIAL_NUMBERS MSN,

Line 2024: FROM MTL_OBJECT_GENEALOGY

2020: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
2021: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
2022: AND MSN.gen_object_id IN (
2023: SELECT OBJECT_ID --This part will select all children assets
2024: FROM MTL_OBJECT_GENEALOGY
2025: START WITH PARENT_OBJECT_ID IN
2026: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2027: FROM CSI_ITEM_INSTANCES CII,
2028: EAM_ASSET_FAILURE_CODES EAFC,

Line 2205: FROM MTL_OBJECT_GENEALOGY

2201: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
2202: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
2203: AND MSN.gen_object_id IN
2204: (SELECT OBJECT_ID --This part will select all children assets
2205: FROM MTL_OBJECT_GENEALOGY
2206: START WITH PARENT_OBJECT_ID IN
2207: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2208: FROM MTL_SERIAL_NUMBERS MSN,
2209: CSI_ITEM_INSTANCES CII

Line 2295: FROM MTL_OBJECT_GENEALOGY

2291: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
2292: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
2293: AND MSN.gen_object_id IN
2294: (SELECT OBJECT_ID --This part will select all children assets
2295: FROM MTL_OBJECT_GENEALOGY
2296: START WITH PARENT_OBJECT_ID IN
2297: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2298: FROM MTL_SERIAL_NUMBERS MSN,
2299: CSI_ITEM_INSTANCES CII

Line 2387: FROM MTL_OBJECT_GENEALOGY

2383: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
2384: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
2385: AND MSN.gen_object_id IN
2386: (SELECT OBJECT_ID --This part will select all children assets
2387: FROM MTL_OBJECT_GENEALOGY
2388: START WITH PARENT_OBJECT_ID IN
2389: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2390: FROM EAM_ASSET_FAILURE_CODES EAFC,
2391: EAM_ASSET_FAILURES EAF,

Line 2600: FROM MTL_OBJECT_GENEALOGY

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

Line 2812: FROM MTL_OBJECT_GENEALOGY

2808: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
2809: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
2810: AND MSN.gen_object_id IN
2811: (SELECT OBJECT_ID --This part will select all children assets
2812: FROM MTL_OBJECT_GENEALOGY
2813: START WITH PARENT_OBJECT_ID IN
2814: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2815: FROM MTL_SERIAL_NUMBERS MSN,
2816: CSI_ITEM_INSTANCES CII

Line 3019: FROM MTL_OBJECT_GENEALOGY

3015: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
3016: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
3017: AND MSN.gen_object_id IN
3018: (SELECT OBJECT_ID --This part will select all children assets
3019: FROM MTL_OBJECT_GENEALOGY
3020: START WITH PARENT_OBJECT_ID IN
3021: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
3022: FROM CSI_ITEM_INSTANCES CII,
3023: EAM_ASSET_FAILURE_CODES EAFC,

Line 3258: FROM MTL_OBJECT_GENEALOGY

3254: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
3255: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
3256: AND MSN.gen_object_id IN
3257: (SELECT OBJECT_ID --This part will select all children assets
3258: FROM MTL_OBJECT_GENEALOGY
3259: START WITH PARENT_OBJECT_ID IN
3260: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
3261: FROM MTL_SERIAL_NUMBERS MSN,
3262: CSI_ITEM_INSTANCES CII

Line 3388: FROM MTL_OBJECT_GENEALOGY

3384: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
3385: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
3386: AND MSN.gen_object_id IN
3387: (SELECT OBJECT_ID --This part will select all children assets
3388: FROM MTL_OBJECT_GENEALOGY
3389: START WITH PARENT_OBJECT_ID IN
3390: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
3391: FROM MTL_SERIAL_NUMBERS MSN,
3392: CSI_ITEM_INSTANCES CII

Line 3508: FROM MTL_OBJECT_GENEALOGY

3504: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
3505: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
3506: AND MSN.GEN_OBJECT_ID IN
3507: (SELECT OBJECT_ID --This part will select all children assets
3508: FROM MTL_OBJECT_GENEALOGY
3509: START WITH PARENT_OBJECT_ID IN
3510: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
3511: FROM CSI_ITEM_INSTANCES CII,
3512: EAM_ASSET_FAILURE_CODES EAFC,

Line 4266: FROM MTL_OBJECT_GENEALOGY

4262: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
4263: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
4264: AND MSN.GEN_OBJECT_ID IN
4265: ( SELECT OBJECT_ID
4266: FROM MTL_OBJECT_GENEALOGY
4267: START WITH PARENT_OBJECT_ID IN
4268: (SELECT GEN_OBJECT_ID PARENT_OBJECT_ID FROM ';
4269: --when it IS required to have a parent failure wo, in order to select the children assets.
4270:

Line 4534: FROM MTL_OBJECT_GENEALOGY

4530: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
4531: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
4532: AND MSN.gen_object_id IN
4533: (SELECT OBJECT_ID
4534: FROM MTL_OBJECT_GENEALOGY
4535: START WITH PARENT_OBJECT_ID IN
4536: (SELECT GEN_OBJECT_ID PARENT_OBJECT_ID FROM';
4537: --when it IS required to have a parent failure wo, in order to select the children assets.
4538: