DBA Data[Home] [Help]

APPS.EAM_FAILURE_ANALYSIS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 322: MTL_SYSTEM_ITEMS_KFV MSIKFV,

318: FROM WIP_DISCRETE_JOBS WDJ,
319: WIP_ENTITIES WE,
320: CSI_ITEM_INSTANCES CII,
321: MTL_CATEGORIES_KFV MCKFV,
322: MTL_SYSTEM_ITEMS_KFV MSIKFV,
323: MTL_EAM_LOCATIONS MEL,
324: BOM_DEPARTMENTS BD,
325: EAM_ASSET_FAILURE_CODES EAFC,
326: EAM_ASSET_FAILURES EAF,

Line 514: MTL_SYSTEM_ITEMS_KFV MSIKFV,

510: FROM WIP_DISCRETE_JOBS WDJ,
511: WIP_ENTITIES WE,
512: CSI_ITEM_INSTANCES CII,
513: MTL_CATEGORIES_KFV MCKFV,
514: MTL_SYSTEM_ITEMS_KFV MSIKFV,
515: MTL_EAM_LOCATIONS MEL,
516: BOM_DEPARTMENTS BD,
517: EAM_ASSET_FAILURE_CODES EAFC,
518: EAM_ASSET_FAILURES EAF,

Line 673: MTL_SYSTEM_ITEMS_KFV MSIKFV,

669: FROM WIP_DISCRETE_JOBS WDJ,
670: WIP_ENTITIES WE,
671: CSI_ITEM_INSTANCES CII,
672: MTL_CATEGORIES_KFV MCKFV,
673: MTL_SYSTEM_ITEMS_KFV MSIKFV,
674: MTL_EAM_LOCATIONS MEL,
675: BOM_DEPARTMENTS BD,
676: EAM_ASSET_FAILURE_CODES EAFC,
677: EAM_ASSET_FAILURES EAF,

Line 916: MTL_SYSTEM_ITEMS_KFV MSIKFV,

912: FROM WIP_DISCRETE_JOBS WDJ,
913: WIP_ENTITIES WE,
914: CSI_ITEM_INSTANCES CII,
915: MTL_CATEGORIES_KFV MCKFV,
916: MTL_SYSTEM_ITEMS_KFV MSIKFV,
917: MTL_EAM_LOCATIONS MEL,
918: BOM_DEPARTMENTS BD,
919: EAM_ASSET_FAILURE_CODES EAFC,
920: EAM_ASSET_FAILURES EAF,

Line 1017: MTL_SYSTEM_ITEMS_KFV MSIKFV,

1013: FROM WIP_DISCRETE_JOBS WDJ,
1014: WIP_ENTITIES WE,
1015: CSI_ITEM_INSTANCES CII,
1016: MTL_CATEGORIES_KFV MCKFV,
1017: MTL_SYSTEM_ITEMS_KFV MSIKFV,
1018: MTL_EAM_LOCATIONS MEL,
1019: BOM_DEPARTMENTS BD,
1020: EAM_ASSET_FAILURE_CODES EAFC,
1021: EAM_ASSET_FAILURES EAF,

Line 1119: MTL_SYSTEM_ITEMS_KFV MSIKFV,

1115: FROM WIP_DISCRETE_JOBS WDJ,
1116: WIP_ENTITIES WE,
1117: CSI_ITEM_INSTANCES CII,
1118: MTL_CATEGORIES_KFV MCKFV,
1119: MTL_SYSTEM_ITEMS_KFV MSIKFV,
1120: MTL_EAM_LOCATIONS MEL,
1121: BOM_DEPARTMENTS BD,
1122: EAM_ASSET_FAILURE_CODES EAFC,
1123: EAM_ASSET_FAILURES EAF,

Line 1262: MTL_SYSTEM_ITEMS_KFV MSIKFV,

1258: FROM WIP_DISCRETE_JOBS WDJ,
1259: WIP_ENTITIES WE,
1260: CSI_ITEM_INSTANCES CII,
1261: MTL_CATEGORIES_KFV MCKFV,
1262: MTL_SYSTEM_ITEMS_KFV MSIKFV,
1263: MTL_EAM_LOCATIONS MEL,
1264: BOM_DEPARTMENTS BD,
1265: EAM_ASSET_FAILURE_CODES EAFC,
1266: EAM_ASSET_FAILURES EAF,

Line 1792: MTL_SYSTEM_ITEMS_KFV MSIKFV,

1788: FROM WIP_DISCRETE_JOBS WDJ,
1789: WIP_ENTITIES WE,
1790: CSI_ITEM_INSTANCES CII,
1791: MTL_CATEGORIES_KFV MCKFV,
1792: MTL_SYSTEM_ITEMS_KFV MSIKFV,
1793: MTL_EAM_LOCATIONS MEL,
1794: BOM_DEPARTMENTS BD,
1795: EAM_ASSET_FAILURE_CODES EAFC,
1796: EAM_ASSET_FAILURES EAF,

Line 1882: MTL_SYSTEM_ITEMS_KFV MSIKFV,

1878: 'Y' INCLUDE_FOR_COST_AGGR
1879: FROM WIP_DISCRETE_JOBS WDJ,
1880: WIP_ENTITIES WE,
1881: MTL_CATEGORIES_KFV MCKFV,
1882: MTL_SYSTEM_ITEMS_KFV MSIKFV,
1883: MTL_EAM_LOCATIONS MEL,
1884: BOM_DEPARTMENTS BD,
1885: EAM_ASSET_FAILURE_CODES EAFC,
1886: EAM_ASSET_FAILURES EAF,

Line 1981: MTL_SYSTEM_ITEMS_KFV MSIKFV,

1977: 'Y' INCLUDE_FOR_COST_AGGR
1978: FROM WIP_DISCRETE_JOBS WDJ,
1979: WIP_ENTITIES WE,
1980: MTL_CATEGORIES_KFV MCKFV,
1981: MTL_SYSTEM_ITEMS_KFV MSIKFV,
1982: MTL_EAM_LOCATIONS MEL,
1983: BOM_DEPARTMENTS BD,
1984: EAM_ASSET_FAILURE_CODES EAFC,
1985: EAM_ASSET_FAILURES EAF,

Line 2065: MTL_SYSTEM_ITEMS_KFV MSIKFV,

2061: FROM WIP_DISCRETE_JOBS WDJ,
2062: WIP_ENTITIES WE,
2063: CSI_ITEM_INSTANCES CII,
2064: MTL_CATEGORIES_KFV MCKFV,
2065: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2066: MTL_EAM_LOCATIONS MEL,
2067: BOM_DEPARTMENTS BD,
2068: EAM_ASSET_FAILURE_CODES EAFC,
2069: EAM_ASSET_FAILURES EAF,

Line 2153: MTL_SYSTEM_ITEMS_KFV MSIKFV,

2149: 'Y' INCLUDE_FOR_COST_AGGR
2150: FROM WIP_DISCRETE_JOBS WDJ,
2151: WIP_ENTITIES WE,
2152: MTL_CATEGORIES_KFV MCKFV,
2153: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2154: MTL_EAM_LOCATIONS MEL,
2155: BOM_DEPARTMENTS BD,
2156: EAM_ASSET_FAILURE_CODES EAFC,
2157: EAM_ASSET_FAILURES EAF,

Line 2248: MTL_SYSTEM_ITEMS_KFV MSIKFV,

2244: 'Y' INCLUDE_FOR_COST_AGGR
2245: FROM WIP_DISCRETE_JOBS WDJ,
2246: WIP_ENTITIES WE,
2247: MTL_CATEGORIES_KFV MCKFV,
2248: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2249: MTL_EAM_LOCATIONS MEL,
2250: BOM_DEPARTMENTS BD,
2251: EAM_ASSET_FAILURE_CODES EAFC,
2252: EAM_ASSET_FAILURES EAF,

Line 2332: MTL_SYSTEM_ITEMS_KFV MSIKFV,

2328: FROM WIP_DISCRETE_JOBS WDJ,
2329: WIP_ENTITIES WE,
2330: CSI_ITEM_INSTANCES CII,
2331: MTL_CATEGORIES_KFV MCKFV,
2332: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2333: MTL_EAM_LOCATIONS MEL,
2334: BOM_DEPARTMENTS BD,
2335: EAM_ASSET_FAILURE_CODES EAFC,
2336: EAM_ASSET_FAILURES EAF,

Line 2449: MTL_SYSTEM_ITEMS_KFV MSIKFV,

2445: 'Y' INCLUDE_FOR_COST_AGGR
2446: FROM WIP_DISCRETE_JOBS WDJ,
2447: WIP_ENTITIES WE,
2448: MTL_CATEGORIES_KFV MCKFV,
2449: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2450: MTL_EAM_LOCATIONS MEL,
2451: BOM_DEPARTMENTS BD,
2452: EAM_ASSET_FAILURE_CODES EAFC,
2453: EAM_ASSET_FAILURES EAF,

Line 2542: MTL_SYSTEM_ITEMS_KFV MSIKFV,

2538: 'Y' INCLUDE_FOR_COST_AGGR
2539: FROM WIP_DISCRETE_JOBS WDJ,
2540: WIP_ENTITIES WE,
2541: MTL_CATEGORIES_KFV MCKFV,
2542: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2543: MTL_EAM_LOCATIONS MEL,
2544: BOM_DEPARTMENTS BD,
2545: EAM_ASSET_FAILURE_CODES EAFC,
2546: EAM_ASSET_FAILURES EAF,

Line 2665: MTL_SYSTEM_ITEMS_KFV MSIKFV,

2661: 'Y' INCLUDE_FOR_COST_AGGR
2662: FROM WIP_DISCRETE_JOBS WDJ,
2663: WIP_ENTITIES WE,
2664: MTL_CATEGORIES_KFV MCKFV,
2665: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2666: MTL_EAM_LOCATIONS MEL,
2667: BOM_DEPARTMENTS BD,
2668: EAM_ASSET_FAILURE_CODES EAFC,
2669: EAM_ASSET_FAILURES EAF,

Line 2775: MTL_SYSTEM_ITEMS_KFV MSIKFV,

2771: FROM WIP_DISCRETE_JOBS WDJ,
2772: WIP_ENTITIES WE,
2773: CSI_ITEM_INSTANCES CII,
2774: MTL_CATEGORIES_KFV MCKFV,
2775: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2776: MTL_EAM_LOCATIONS MEL,
2777: BOM_DEPARTMENTS BD,
2778: EAM_ASSET_FAILURE_CODES EAFC,
2779: EAM_ASSET_FAILURES EAF,

Line 2903: MTL_SYSTEM_ITEMS_KFV MSIKFV,

2899: 'Y' INCLUDE_FOR_COST_AGGR
2900: FROM WIP_DISCRETE_JOBS WDJ,
2901: WIP_ENTITIES WE,
2902: MTL_CATEGORIES_KFV MCKFV,
2903: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2904: MTL_EAM_LOCATIONS MEL,
2905: BOM_DEPARTMENTS BD,
2906: EAM_ASSET_FAILURE_CODES EAFC,
2907: EAM_ASSET_FAILURES EAF,

Line 3025: MTL_SYSTEM_ITEMS_KFV MSIKFV,

3021: 'Y' INCLUDE_FOR_COST_AGGR
3022: FROM WIP_DISCRETE_JOBS WDJ,
3023: WIP_ENTITIES WE,
3024: MTL_CATEGORIES_KFV MCKFV,
3025: MTL_SYSTEM_ITEMS_KFV MSIKFV,
3026: MTL_EAM_LOCATIONS MEL,
3027: BOM_DEPARTMENTS BD,
3028: EAM_ASSET_FAILURE_CODES EAFC,
3029: EAM_ASSET_FAILURES EAF,

Line 3560: MTL_SYSTEM_ITEMS_KFV MSIKFV,

3556: l_sql_stmt2 := ' FROM WIP_DISCRETE_JOBS WDJ,
3557: WIP_ENTITIES WE,
3558: CSI_ITEM_INSTANCES CII,
3559: MTL_CATEGORIES_KFV MCKFV,
3560: MTL_SYSTEM_ITEMS_KFV MSIKFV,
3561: MTL_EAM_LOCATIONS MEL,
3562: BOM_DEPARTMENTS BD,
3563: EAM_ASSET_FAILURE_CODES EAFC,
3564: EAM_ASSET_FAILURES EAF,

Line 3615: MTL_SYSTEM_ITEMS_KFV MSIKFV,

3611: EAFC.COMMENTS
3612: FROM WIP_DISCRETE_JOBS WDJ,
3613: CSI_ITEM_INSTANCES CII,
3614: MTL_CATEGORIES_KFV MCKFV,
3615: MTL_SYSTEM_ITEMS_KFV MSIKFV,
3616: MTL_EAM_LOCATIONS MEL,
3617: BOM_DEPARTMENTS BD,
3618: EAM_ASSET_FAILURE_CODES EAFC,
3619: EAM_ASSET_FAILURES EAF,

Line 3658: MTL_SYSTEM_ITEMS_KFV MSIKFV,

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,
3661: CSI_ITEM_INSTANCES CII,
3662: (SELECT * FROM EAM_ORG_MAINT_DEFAULTS WHERE ORGANIZATION_ID= '||l_org_id|| ' ) EOMD1 ' ||

Line 3794: MTL_SYSTEM_ITEMS_KFV MSIKFV,

3790: FROM WIP_DISCRETE_JOBS WDJ,
3791: WIP_ENTITIES WE,
3792: CSI_ITEM_INSTANCES CII,
3793: MTL_CATEGORIES_KFV MCKFV,
3794: MTL_SYSTEM_ITEMS_KFV MSIKFV,
3795: MTL_EAM_LOCATIONS MEL,
3796: BOM_DEPARTMENTS BD,
3797: EAM_ASSET_FAILURE_CODES EAFC,
3798: EAM_ASSET_FAILURES EAF,

Line 3884: MTL_SYSTEM_ITEMS_KFV MSIKFV,

3880:
3881: FROM WIP_DISCRETE_JOBS WDJ,
3882: CSI_ITEM_INSTANCES CII,
3883: MTL_CATEGORIES_KFV MCKFV,
3884: MTL_SYSTEM_ITEMS_KFV MSIKFV,
3885: MTL_EAM_LOCATIONS MEL,
3886: BOM_DEPARTMENTS BD,
3887: EAM_ASSET_FAILURE_CODES EAFC,
3888: EAM_ASSET_FAILURES EAF,

Line 3928: MTL_SYSTEM_ITEMS_KFV MSIKFV,

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,
3931: CSI_ITEM_INSTANCES CII,
3932: (SELECT * FROM EAM_ORG_MAINT_DEFAULTS WHERE ORGANIZATION_ID= '||l_org_id|| ' ) EOMD1 ' ||