APPS.MTH_PROCESS_OUTPUT_PKG dependencies on FND_LOOKUPS

Line 889: FROM fnd_lookups flk,

885: -- Validation for SPR
886: UPDATE mth_equip_output_stg stg
887: SET stg.err_code = stg.err_code || 'SPR '
888: WHERE EXISTS (SELECT * FROM (SELECT flk.lookup_code, flk.lookup_type,stg.reading_time,stg.qty_scrap,stg.scrap_reason_code
889: FROM fnd_lookups flk,
890: mth_equip_output_stg stg
891: WHERE stg.scrap_reason_code = flk.lookup_code (+)
892: AND flk.lookup_type(+) = 'MTH_SCRAP_REASON') dtr
893: WHERE ((stg.qty_scrap IS NULL OR stg.qty_scrap <= 0) AND stg.scrap_reason_code IS NOT NULL) OR

Line 1114: fnd_lookups lkp,

1110: mth_user_dim_entities_mst mue2,
1111: mth_user_dim_entities_mst mue3,
1112: mth_user_dim_entities_mst mue4,
1113: mth_user_dim_entities_mst mue5,
1114: fnd_lookups lkp,
1115: mth_hour_d mhd
1116: WHERE stg.EQUIPMENT_FK = med.EQUIPMENT_PK (+)
1117: AND stg.SHIFT_WORKDAY_FK = wds.SHIFT_WORKDAY_PK (+)
1118: AND stg.ITEM_FK = mid.ITEM_PK (+)

Line 1449: FROM fnd_lookups flk,

1445: -- Validation for SPR
1446: UPDATE mth_equip_output_stg stg
1447: SET stg.err_code = stg.err_code || 'SPR '
1448: WHERE EXISTS (SELECT * FROM (SELECT flk.lookup_code, flk.lookup_type,stg.reading_time,stg.qty_scrap,stg.scrap_reason_code
1449: FROM fnd_lookups flk,
1450: mth_equip_output_stg stg
1451: WHERE stg.scrap_reason_code = flk.lookup_code (+)
1452: AND flk.lookup_type(+) = 'MTH_SCRAP_REASON') dtr
1453: WHERE ((stg.qty_scrap IS NULL OR stg.qty_scrap <= 0) AND stg.scrap_reason_code IS NOT NULL) OR

Line 1677: fnd_lookups lkp,

1673: mth_user_dim_entities_mst mue2,
1674: mth_user_dim_entities_mst mue3,
1675: mth_user_dim_entities_mst mue4,
1676: mth_user_dim_entities_mst mue5,
1677: fnd_lookups lkp,
1678: mth_hour_d mhd
1679: WHERE stg.EQUIPMENT_FK = med.EQUIPMENT_PK (+)
1680: AND stg.SHIFT_WORKDAY_FK = wds.SHIFT_WORKDAY_PK (+)
1681: AND stg.ITEM_FK = mid.ITEM_PK (+)

Line 2058: FROM fnd_lookups flk,

2054: -- Validation for SPR
2055: UPDATE mth_equip_output_stg stg
2056: SET stg.err_code = stg.err_code || 'SPR '
2057: WHERE EXISTS (SELECT * FROM (SELECT flk.lookup_code, flk.lookup_type,stg.reading_time,stg.qty_scrap,stg.scrap_reason_code
2058: FROM fnd_lookups flk,
2059: mth_equip_output_stg stg
2060: WHERE stg.scrap_reason_code = flk.lookup_code (+)
2061: AND flk.lookup_type(+) = 'MTH_SCRAP_REASON') dtr
2062: WHERE ((stg.qty_scrap IS NULL OR stg.qty_scrap <= 0) AND stg.scrap_reason_code IS NOT NULL) OR

Line 2236: fnd_lookups lkp,

2232: mth_user_dim_entities_mst mue2,
2233: mth_user_dim_entities_mst mue3,
2234: mth_user_dim_entities_mst mue4,
2235: mth_user_dim_entities_mst mue5,
2236: fnd_lookups lkp,
2237: mth_hour_d mhd
2238: WHERE stg.EQUIPMENT_FK = med.EQUIPMENT_PK (+)
2239: AND stg.SHIFT_WORKDAY_FK = wds.SHIFT_WORKDAY_PK (+)
2240: AND stg.ITEM_FK = mid.ITEM_PK (+)