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_SERIAL_NUMBERS

Line 1815: MTL_SERIAL_NUMBERS MSN

1811: AND MEL.LOCATION_ID (+) = EAF.AREA_ID
1812: AND BD.DEPARTMENT_ID (+) = EAF.DEPARTMENT_ID
1813: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
1814: FROM CSI_ITEM_INSTANCES CII,
1815: MTL_SERIAL_NUMBERS MSN
1816: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
1817: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
1818: AND MSN.gen_object_id IN
1819: (

Line 1825: FROM MTL_SERIAL_NUMBERS MSN,

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,
1826: CSI_ITEM_INSTANCES CII
1827: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
1828: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
1829: AND (l_gen_object_id IS NULL OR CII.INSTANCE_ID = l_gen_object_id)

Line 1908: MTL_SERIAL_NUMBERS MSN

1904: AND (p_to_date IS NULL OR FAILURE_DATE <= p_to_date)
1905: AND (p_from_date IS NULL OR FAILURE_DATE >= p_from_date)
1906: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
1907: FROM CSI_ITEM_INSTANCES CII,
1908: MTL_SERIAL_NUMBERS MSN
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

Line 1920: MTL_SERIAL_NUMBERS MSN

1916: FROM CSI_ITEM_INSTANCES CII,
1917: EAM_ASSET_FAILURE_CODES EAFC,
1918: EAM_ASSET_FAILURES EAF,
1919: WIP_DISCRETE_JOBS WDJ,
1920: MTL_SERIAL_NUMBERS MSN
1921: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
1922: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
1923: AND WDJ.STATUS_TYPE IN (4,5,12)
1924: AND EAF.SOURCE_TYPE = 1

Line 2088: MTL_SERIAL_NUMBERS MSN

2084: AND MEL.LOCATION_ID (+) = EAF.AREA_ID
2085: AND BD.DEPARTMENT_ID (+) = EAF.DEPARTMENT_ID
2086: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
2087: FROM CSI_ITEM_INSTANCES CII,
2088: MTL_SERIAL_NUMBERS MSN
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

Line 2096: FROM MTL_SERIAL_NUMBERS MSN,

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
2098: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
2099: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
2100: AND (l_gen_object_id IS NULL OR CII.INSTANCE_ID = l_gen_object_id)

Line 2179: MTL_SERIAL_NUMBERS MSN

2175: AND (p_to_date IS NULL OR FAILURE_DATE <= p_to_date)
2176: AND (p_from_date IS NULL OR FAILURE_DATE >= p_from_date)
2177: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
2178: FROM CSI_ITEM_INSTANCES CII,
2179: MTL_SERIAL_NUMBERS MSN
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

Line 2190: MTL_SERIAL_NUMBERS MSN,

2186: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2187: FROM EAM_ASSET_FAILURE_CODES EAFC,
2188: EAM_ASSET_FAILURES EAF,
2189: WIP_DISCRETE_JOBS WDJ,
2190: MTL_SERIAL_NUMBERS MSN,
2191: CSI_ITEM_INSTANCES CII
2192: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2193: AND WDJ.STATUS_TYPE IN (4,5,12)
2194: AND EAF.SOURCE_TYPE = 1

Line 2391: MTL_SERIAL_NUMBERS MSN

2387: AND EAF.OBJECT_ID = METER.MAINTENANCE_OBJECT_ID (+)
2388: AND METER.WIP_ENTITY_ID (+) = EAF.SOURCE_ID
2389: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
2390: FROM CSI_ITEM_INSTANCES CII,
2391: MTL_SERIAL_NUMBERS MSN
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

Line 2399: FROM MTL_SERIAL_NUMBERS MSN,

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
2401: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
2402: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
2403: AND (l_gen_object_id IS NULL OR CII.INSTANCE_ID = l_gen_object_id)

Line 2596: MTL_SERIAL_NUMBERS MSN

2592: AND (p_to_date IS NULL OR FAILURE_DATE <= p_to_date)
2593: AND (p_from_date IS NULL OR FAILURE_DATE >= p_from_date)
2594: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
2595: FROM CSI_ITEM_INSTANCES CII,
2596: MTL_SERIAL_NUMBERS MSN
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

Line 2608: MTL_SERIAL_NUMBERS MSN

2604: FROM CSI_ITEM_INSTANCES CII,
2605: EAM_ASSET_FAILURE_CODES EAFC,
2606: EAM_ASSET_FAILURES EAF,
2607: WIP_DISCRETE_JOBS WDJ,
2608: MTL_SERIAL_NUMBERS MSN
2609: WHERE NVL(WDJ.STATUS_TYPE,4) IN (4,5,12)
2610: AND EAF.SOURCE_TYPE(+) = 1
2611: AND EAF.OBJECT_TYPE(+) = 3
2612: AND EAF.OBJECT_ID(+) = CII.INSTANCE_ID

Line 2834: MTL_SERIAL_NUMBERS MSN

2830: AND EAF.OBJECT_ID = METER.MAINTENANCE_OBJECT_ID (+)
2831: AND METER.WIP_ENTITY_ID (+) = EAF.SOURCE_ID
2832: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
2833: FROM CSI_ITEM_INSTANCES CII,
2834: MTL_SERIAL_NUMBERS MSN
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

Line 2842: FROM MTL_SERIAL_NUMBERS MSN,

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
2844: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
2845: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
2846: AND (l_gen_object_id IS NULL OR CII.INSTANCE_ID = l_gen_object_id)

Line 2952: MTL_SERIAL_NUMBERS MSN

2948: AND (p_to_date IS NULL OR FAILURE_DATE <= p_to_date)
2949: AND (p_from_date IS NULL OR FAILURE_DATE >= p_from_date)
2950: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
2951: FROM CSI_ITEM_INSTANCES CII,
2952: MTL_SERIAL_NUMBERS MSN
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

Line 2964: MTL_SERIAL_NUMBERS MSN

2960: FROM CSI_ITEM_INSTANCES CII,
2961: EAM_ASSET_FAILURE_CODES EAFC,
2962: EAM_ASSET_FAILURES EAF,
2963: WIP_DISCRETE_JOBS WDJ,
2964: MTL_SERIAL_NUMBERS MSN
2965: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
2966: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
2967: AND WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2968: AND WDJ.STATUS_TYPE IN (4,5,12)

Line 3585: MTL_SERIAL_NUMBERS MSN

3581: AND EAF.OBJECT_ID IN';
3582:
3583: l_sql_stmt3 := '(SELECT CII.INSTANCE_ID
3584: FROM CSI_ITEM_INSTANCES CII,
3585: MTL_SERIAL_NUMBERS MSN
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

Line 3622: MTL_SERIAL_NUMBERS MSN,

3618: EAM_ASSET_FAILURE_CODES EAFC,
3619: EAM_ASSET_FAILURES EAF,
3620: EAM_FAILURE_CODES EFC,
3621: EAM_CAUSE_CODES ECC,
3622: MTL_SERIAL_NUMBERS MSN,
3623: EAM_RESOLUTION_CODES ERC
3624: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
3625: AND WDJ.STATUS_TYPE IN (4,5,12)
3626: AND EAF.SOURCE_TYPE = 1

Line 3656: FROM MTL_SERIAL_NUMBERS MSN,

3652: MSIKFV.CONCATENATED_SEGMENTS MAINTAINED_GROUP,
3653: MCKFV.CONCATENATED_SEGMENTS ASSET_CATEGORY,
3654: MEL.LOCATION_CODES ASSET_LOCATION,
3655: BD.DEPARTMENT_CODE OWNING_DEPARTMENT
3656: FROM MTL_SERIAL_NUMBERS MSN,
3657: MTL_CATEGORIES_KFV MCKFV,
3658: MTL_SYSTEM_ITEMS_KFV MSIKFV,
3659: MTL_EAM_LOCATIONS MEL,
3660: BOM_DEPARTMENTS BD,

Line 3853: MTL_SERIAL_NUMBERS MSN

3849: AND METER.WIP_ENTITY_ID (+) = EAF.SOURCE_ID
3850: AND EAF.OBJECT_ID IN ';
3851: l_sql_stmt3 := '( SELECT CII.INSTANCE_ID
3852: FROM CSI_ITEM_INSTANCES CII,
3853: MTL_SERIAL_NUMBERS MSN
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

Line 3892: MTL_SERIAL_NUMBERS MSN

3888: EAM_ASSET_FAILURES EAF,
3889: EAM_FAILURE_CODES EFC,
3890: EAM_CAUSE_CODES ECC,
3891: EAM_RESOLUTION_CODES ERC,
3892: MTL_SERIAL_NUMBERS MSN
3893:
3894: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
3895: AND WDJ.STATUS_TYPE IN (4,5,12)
3896: AND EAF.SOURCE_TYPE = 1

Line 3926: FROM MTL_SERIAL_NUMBERS MSN,

3922: MSIKFV.CONCATENATED_SEGMENTS MAINTAINED_GROUP,
3923: MCKFV.CONCATENATED_SEGMENTS ASSET_CATEGORY,
3924: MEL.LOCATION_CODES ASSET_LOCATION,
3925: BD.DEPARTMENT_CODE OWNING_DEPARTMENT
3926: FROM MTL_SERIAL_NUMBERS MSN,
3927: MTL_CATEGORIES_KFV MCKFV,
3928: MTL_SYSTEM_ITEMS_KFV MSIKFV,
3929: MTL_EAM_LOCATIONS MEL,
3930: BOM_DEPARTMENTS BD,