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 1832: MTL_SERIAL_NUMBERS MSN

1828: AND MEL.LOCATION_ID (+) = EAF.AREA_ID
1829: AND BD.DEPARTMENT_ID (+) = EAF.DEPARTMENT_ID
1830: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
1831: FROM CSI_ITEM_INSTANCES CII,
1832: MTL_SERIAL_NUMBERS MSN
1833: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
1834: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
1835: AND MSN.gen_object_id IN
1836: (

Line 1842: FROM MTL_SERIAL_NUMBERS MSN,

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,
1843: CSI_ITEM_INSTANCES CII
1844: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
1845: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
1846: AND (l_gen_object_id IS NULL OR CII.INSTANCE_ID = l_gen_object_id)

Line 1924: MTL_SERIAL_NUMBERS MSN

1920: AND MEL.LOCATION_ID (+) = EAF.AREA_ID
1921: AND BD.DEPARTMENT_ID (+) = EAF.DEPARTMENT_ID
1922: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
1923: FROM CSI_ITEM_INSTANCES CII,
1924: MTL_SERIAL_NUMBERS MSN
1925: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
1926: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
1927: AND MSN.gen_object_id IN
1928: (

Line 1934: FROM MTL_SERIAL_NUMBERS MSN,

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,
1935: CSI_ITEM_INSTANCES CII
1936: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
1937: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
1938: AND CII.INSTANCE_ID = l_gen_object_id

Line 2019: MTL_SERIAL_NUMBERS MSN

2015: AND (p_to_date IS NULL OR FAILURE_DATE <= p_to_date)
2016: AND (p_from_date IS NULL OR FAILURE_DATE >= p_from_date)
2017: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
2018: FROM CSI_ITEM_INSTANCES CII,
2019: MTL_SERIAL_NUMBERS MSN
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

Line 2031: MTL_SERIAL_NUMBERS MSN

2027: FROM CSI_ITEM_INSTANCES CII,
2028: EAM_ASSET_FAILURE_CODES EAFC,
2029: EAM_ASSET_FAILURES EAF,
2030: WIP_DISCRETE_JOBS WDJ,
2031: MTL_SERIAL_NUMBERS MSN
2032: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2033: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
2034: AND WDJ.STATUS_TYPE IN (4,5,12)
2035: AND EAF.SOURCE_TYPE = 1

Line 2200: MTL_SERIAL_NUMBERS MSN

2196: AND MEL.LOCATION_ID (+) = EAF.AREA_ID
2197: AND BD.DEPARTMENT_ID (+) = EAF.DEPARTMENT_ID
2198: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
2199: FROM CSI_ITEM_INSTANCES CII,
2200: MTL_SERIAL_NUMBERS MSN
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

Line 2208: FROM MTL_SERIAL_NUMBERS MSN,

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

Line 2290: MTL_SERIAL_NUMBERS MSN

2286: AND MEL.LOCATION_ID (+) = EAF.AREA_ID
2287: AND BD.DEPARTMENT_ID (+) = EAF.DEPARTMENT_ID
2288: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
2289: FROM CSI_ITEM_INSTANCES CII,
2290: MTL_SERIAL_NUMBERS MSN
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

Line 2298: FROM MTL_SERIAL_NUMBERS MSN,

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
2300: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
2301: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
2302: AND CII.INSTANCE_ID = l_gen_object_id

Line 2382: MTL_SERIAL_NUMBERS MSN

2378: AND (p_to_date IS NULL OR FAILURE_DATE <= p_to_date)
2379: AND (p_from_date IS NULL OR FAILURE_DATE >= p_from_date)
2380: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
2381: FROM CSI_ITEM_INSTANCES CII,
2382: MTL_SERIAL_NUMBERS MSN
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

Line 2393: MTL_SERIAL_NUMBERS MSN,

2389: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2390: FROM EAM_ASSET_FAILURE_CODES EAFC,
2391: EAM_ASSET_FAILURES EAF,
2392: WIP_DISCRETE_JOBS WDJ,
2393: MTL_SERIAL_NUMBERS MSN,
2394: CSI_ITEM_INSTANCES CII
2395: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2396: AND WDJ.STATUS_TYPE IN (4,5,12)
2397: AND EAF.SOURCE_TYPE = 1

Line 2595: MTL_SERIAL_NUMBERS MSN

2591: AND EAF.OBJECT_ID = METER.MAINTENANCE_OBJECT_ID (+)
2592: AND METER.WIP_ENTITY_ID (+) = EAF.SOURCE_ID
2593: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
2594: FROM CSI_ITEM_INSTANCES CII,
2595: MTL_SERIAL_NUMBERS MSN
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

Line 2603: FROM MTL_SERIAL_NUMBERS MSN,

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

Line 2807: MTL_SERIAL_NUMBERS MSN

2803: AND EAF.OBJECT_ID = METER.MAINTENANCE_OBJECT_ID (+)
2804: AND METER.WIP_ENTITY_ID (+) = EAF.SOURCE_ID
2805: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
2806: FROM CSI_ITEM_INSTANCES CII,
2807: MTL_SERIAL_NUMBERS MSN
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

Line 2815: FROM MTL_SERIAL_NUMBERS MSN,

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
2817: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
2818: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
2819: AND CII.INSTANCE_ID = l_gen_object_id

Line 3014: MTL_SERIAL_NUMBERS MSN

3010: AND (p_to_date IS NULL OR FAILURE_DATE <= p_to_date)
3011: AND (p_from_date IS NULL OR FAILURE_DATE >= p_from_date)
3012: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
3013: FROM CSI_ITEM_INSTANCES CII,
3014: MTL_SERIAL_NUMBERS MSN
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

Line 3026: MTL_SERIAL_NUMBERS MSN

3022: FROM CSI_ITEM_INSTANCES CII,
3023: EAM_ASSET_FAILURE_CODES EAFC,
3024: EAM_ASSET_FAILURES EAF,
3025: WIP_DISCRETE_JOBS WDJ,
3026: MTL_SERIAL_NUMBERS MSN
3027: WHERE NVL(WDJ.STATUS_TYPE,4) IN (4,5,12)
3028: AND EAF.SOURCE_TYPE(+) = 1
3029: AND EAF.OBJECT_TYPE(+) = 3
3030: AND EAF.OBJECT_ID(+) = CII.INSTANCE_ID

Line 3253: MTL_SERIAL_NUMBERS MSN

3249: AND EAF.OBJECT_ID = METER.MAINTENANCE_OBJECT_ID (+)
3250: AND METER.WIP_ENTITY_ID (+) = EAF.SOURCE_ID
3251: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
3252: FROM CSI_ITEM_INSTANCES CII,
3253: MTL_SERIAL_NUMBERS MSN
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

Line 3261: FROM MTL_SERIAL_NUMBERS MSN,

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

Line 3383: MTL_SERIAL_NUMBERS MSN

3379: AND EAF.OBJECT_ID = METER.MAINTENANCE_OBJECT_ID (+)
3380: AND METER.WIP_ENTITY_ID (+) = EAF.SOURCE_ID
3381: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
3382: FROM CSI_ITEM_INSTANCES CII,
3383: MTL_SERIAL_NUMBERS MSN
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

Line 3391: FROM MTL_SERIAL_NUMBERS MSN,

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
3393: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
3394: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
3395: AND CII.INSTANCE_ID = l_gen_object_id

Line 3503: MTL_SERIAL_NUMBERS MSN

3499: AND (p_to_date IS NULL OR FAILURE_DATE <= p_to_date)
3500: AND (p_from_date IS NULL OR FAILURE_DATE >= p_from_date)
3501: AND EAF.OBJECT_ID IN (SELECT CII.INSTANCE_ID
3502: FROM CSI_ITEM_INSTANCES CII,
3503: MTL_SERIAL_NUMBERS MSN
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

Line 3515: MTL_SERIAL_NUMBERS MSN

3511: FROM CSI_ITEM_INSTANCES CII,
3512: EAM_ASSET_FAILURE_CODES EAFC,
3513: EAM_ASSET_FAILURES EAF,
3514: WIP_DISCRETE_JOBS WDJ,
3515: MTL_SERIAL_NUMBERS MSN
3516: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
3517: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
3518: AND WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
3519: AND WDJ.STATUS_TYPE IN (4,5,12)

Line 4261: MTL_SERIAL_NUMBERS MSN

4257: AND EAF.OBJECT_ID IN';
4258:
4259: l_sql_stmt3 := '(SELECT CII.INSTANCE_ID
4260: FROM CSI_ITEM_INSTANCES CII,
4261: MTL_SERIAL_NUMBERS MSN
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

Line 4298: MTL_SERIAL_NUMBERS MSN,

4294: EAM_ASSET_FAILURE_CODES EAFC,
4295: EAM_ASSET_FAILURES EAF,
4296: EAM_FAILURE_CODES EFC,
4297: EAM_CAUSE_CODES ECC,
4298: MTL_SERIAL_NUMBERS MSN,
4299: EAM_RESOLUTION_CODES ERC
4300: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
4301: AND WDJ.STATUS_TYPE IN (4,5,12)
4302: AND EAF.SOURCE_TYPE = 1

Line 4332: FROM MTL_SERIAL_NUMBERS MSN,

4328: MSIKFV.CONCATENATED_SEGMENTS MAINTAINED_GROUP,
4329: MCKFV.CONCATENATED_SEGMENTS ASSET_CATEGORY,
4330: MEL.LOCATION_CODES ASSET_LOCATION,
4331: BD.DEPARTMENT_CODE OWNING_DEPARTMENT
4332: FROM MTL_SERIAL_NUMBERS MSN,
4333: MTL_CATEGORIES_KFV MCKFV,
4334: MTL_SYSTEM_ITEMS_KFV MSIKFV,
4335: MTL_EAM_LOCATIONS MEL,
4336: BOM_DEPARTMENTS BD,

Line 4529: MTL_SERIAL_NUMBERS MSN

4525: AND METER.WIP_ENTITY_ID (+) = EAF.SOURCE_ID
4526: AND EAF.OBJECT_ID IN ';
4527: l_sql_stmt3 := '( SELECT CII.INSTANCE_ID
4528: FROM CSI_ITEM_INSTANCES CII,
4529: MTL_SERIAL_NUMBERS MSN
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

Line 4568: MTL_SERIAL_NUMBERS MSN

4564: EAM_ASSET_FAILURES EAF,
4565: EAM_FAILURE_CODES EFC,
4566: EAM_CAUSE_CODES ECC,
4567: EAM_RESOLUTION_CODES ERC,
4568: MTL_SERIAL_NUMBERS MSN
4569:
4570: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
4571: AND WDJ.STATUS_TYPE IN (4,5,12)
4572: AND EAF.SOURCE_TYPE = 1

Line 4602: FROM MTL_SERIAL_NUMBERS MSN,

4598: MSIKFV.CONCATENATED_SEGMENTS MAINTAINED_GROUP,
4599: MCKFV.CONCATENATED_SEGMENTS ASSET_CATEGORY,
4600: MEL.LOCATION_CODES ASSET_LOCATION,
4601: BD.DEPARTMENT_CODE OWNING_DEPARTMENT
4602: FROM MTL_SERIAL_NUMBERS MSN,
4603: MTL_CATEGORIES_KFV MCKFV,
4604: MTL_SYSTEM_ITEMS_KFV MSIKFV,
4605: MTL_EAM_LOCATIONS MEL,
4606: BOM_DEPARTMENTS BD,