DBA Data[Home] [Help]

APPS.MTH_SUSTAIN_ASPECT_PKG dependencies on MTH_SUSTAIN_ASPECTS

Line 2193: FROM mth_sustain_aspects f, fnd_lookup_values_vl g

2189: g.lookup_type = 'MTH_OTHER_ENTITY_TYPE')
2190: ) z,
2191: (SELECT f.sustain_aspect_pk_key, f.sustain_aspect_code,
2192: f.usage_uom, g.meaning
2193: FROM mth_sustain_aspects f, fnd_lookup_values_vl g
2194: WHERE f.sustain_aspect_code = g.lookup_code
2195: AND g.lookup_type = 'MTH_SUSTAIN_ASPECT'
2196: ) w
2197: WHERE x.STATUS = 'ACTIVE'

Line 2289: FROM mth_sustain_aspects f, fnd_lookup_values_vl g

2285: g.lookup_type = 'MTH_OTHER_ENTITY_TYPE')
2286: ) z,
2287: (SELECT f.sustain_aspect_pk_key, f.sustain_aspect_code,
2288: f.usage_uom, g.meaning
2289: FROM mth_sustain_aspects f, fnd_lookup_values_vl g
2290: WHERE f.sustain_aspect_code = g.lookup_code
2291: AND g.lookup_type = 'MTH_SUSTAIN_ASPECT'
2292: ) w
2293: WHERE x.STATUS = 'ACTIVE'