APPS.MTH_PROCESS_STATUS_PKG dependencies on FND_LOOKUPS

Line 1096: FROM fnd_lookups flk,

1092: stg.FROM_date,
1093: stg.to_date,
1094: stg.downtime_reason_code,
1095: stg.status
1096: FROM fnd_lookups flk,
1097: mth_equip_statuses_stg stg
1098: WHERE flk.lookup_type (+) = 'MTH_EQUIP_DOWNTIME_REASON'
1099: AND stg.downtime_reason_code = flk.lookup_code (+)
1100: AND stg.status = 3) dtr

Line 1121: FROM fnd_lookups flk,

1117: stg.FROM_date,
1118: stg.to_date,
1119: stg.downtime_reason_code,
1120: stg.status
1121: FROM fnd_lookups flk,
1122: mth_equip_statuses_stg stg
1123: WHERE flk.lookup_type (+) = 'MTH_EQUIP_IDLE_REASON'
1124: AND stg.downtime_reason_code = flk.lookup_code (+)
1125: AND stg.status = 2) dtr

Line 1408: fnd_lookups lkp,

1404: mth_user_dim_entities_mst mue2,
1405: mth_user_dim_entities_mst mue3,
1406: mth_user_dim_entities_mst mue4,
1407: mth_user_dim_entities_mst mue5,
1408: fnd_lookups lkp,
1409: mth_hour_d mhd
1410: WHERE stg.EQUIPMENT_FK = med.EQUIPMENT_PK (+)
1411: AND stg.SHIFT_WORKDAY_FK = wds.SHIFT_WORKDAY_PK (+)
1412: AND mhd.to_time >= stg.from_date

Line 1466: fnd_lookups lkp,

1462: mth_user_dim_entities_mst mue2,
1463: mth_user_dim_entities_mst mue3,
1464: mth_user_dim_entities_mst mue4,
1465: mth_user_dim_entities_mst mue5,
1466: fnd_lookups lkp,
1467: mth_hour_d mhd
1468: WHERE stg.EQUIPMENT_FK = med.EQUIPMENT_PK (+)
1469: AND stg.SHIFT_WORKDAY_FK = wds.SHIFT_WORKDAY_PK (+)
1470: AND stg.from_date BETWEEN mhd.from_time AND mhd.to_time

Line 1836: FROM fnd_lookups flk,

1832: stg.FROM_date,
1833: stg.to_date,
1834: stg.downtime_reason_code,
1835: stg.status
1836: FROM fnd_lookups flk,
1837: mth_equip_statuses_stg stg
1838: WHERE flk.lookup_type (+) = 'MTH_EQUIP_DOWNTIME_REASON'
1839: AND stg.downtime_reason_code = flk.lookup_code (+)
1840: AND stg.status = 3) dtr

Line 1861: FROM fnd_lookups flk,

1857: stg.FROM_date,
1858: stg.to_date,
1859: stg.downtime_reason_code,
1860: stg.status
1861: FROM fnd_lookups flk,
1862: mth_equip_statuses_stg stg
1863: WHERE flk.lookup_type (+) = 'MTH_EQUIP_IDLE_REASON'
1864: AND stg.downtime_reason_code = flk.lookup_code (+)
1865: AND stg.status = 2) dtr

Line 2112: fnd_lookups lkp,

2108: mth_user_dim_entities_mst mue2,
2109: mth_user_dim_entities_mst mue3,
2110: mth_user_dim_entities_mst mue4,
2111: mth_user_dim_entities_mst mue5,
2112: fnd_lookups lkp,
2113: mth_hour_d mhd
2114: WHERE stg.EQUIPMENT_FK = med.EQUIPMENT_PK (+)
2115: AND stg.SHIFT_WORKDAY_FK = wds.SHIFT_WORKDAY_PK (+)
2116: AND mhd.to_time >= stg.from_date

Line 2163: fnd_lookups lkp,

2159: mth_user_dim_entities_mst mue2,
2160: mth_user_dim_entities_mst mue3,
2161: mth_user_dim_entities_mst mue4,
2162: mth_user_dim_entities_mst mue5,
2163: fnd_lookups lkp,
2164: mth_hour_d mhd
2165: WHERE stg.EQUIPMENT_FK = med.EQUIPMENT_PK (+)
2166: AND stg.SHIFT_WORKDAY_FK = wds.SHIFT_WORKDAY_PK (+)
2167: AND stg.from_date BETWEEN mhd.from_time AND mhd.to_time

Line 2826: FROM fnd_lookups flk,

2822: stg.FROM_date,
2823: stg.to_date,
2824: stg.downtime_reason_code,
2825: stg.status
2826: FROM fnd_lookups flk,
2827: mth_equip_statuses_stg stg
2828: WHERE flk.lookup_type (+) = 'MTH_EQUIP_DOWNTIME_REASON'
2829: AND stg.downtime_reason_code = flk.lookup_code (+)
2830: AND stg.status = 3) dtr

Line 2850: FROM fnd_lookups flk,

2846: stg.FROM_date,
2847: stg.to_date,
2848: stg.downtime_reason_code,
2849: stg.status
2850: FROM fnd_lookups flk,
2851: mth_equip_statuses_stg stg
2852: WHERE flk.lookup_type (+) = 'MTH_EQUIP_IDLE_REASON'
2853: AND stg.downtime_reason_code = flk.lookup_code (+)
2854: AND stg.status = 2) dtr

Line 3146: fnd_lookups lkp,

3142: mth_user_dim_entities_mst mue2,
3143: mth_user_dim_entities_mst mue3,
3144: mth_user_dim_entities_mst mue4,
3145: mth_user_dim_entities_mst mue5,
3146: fnd_lookups lkp,
3147: mth_hour_d mhd
3148: WHERE stg.EQUIPMENT_FK = med.EQUIPMENT_PK (+)
3149: AND stg.SHIFT_WORKDAY_FK = wds.SHIFT_WORKDAY_PK (+)
3150: AND mhd.to_time >= stg.from_date

Line 3203: fnd_lookups lkp,

3199: mth_user_dim_entities_mst mue2,
3200: mth_user_dim_entities_mst mue3,
3201: mth_user_dim_entities_mst mue4,
3202: mth_user_dim_entities_mst mue5,
3203: fnd_lookups lkp,
3204: mth_hour_d mhd
3205: WHERE stg.EQUIPMENT_FK = med.EQUIPMENT_PK (+)
3206: AND stg.SHIFT_WORKDAY_FK = wds.SHIFT_WORKDAY_PK (+)
3207: AND stg.from_date BETWEEN mhd.from_time AND mhd.to_time