DBA Data[Home] [Help]

APPS.MTH_SUSTAIN_ASPECT_PKG dependencies on MTH_ALL_ENTITIES_V

Line 2186: FROM mth_all_entities_v f, fnd_lookup_values_vl g

2182: WHERE m.site_sustain_pk_key = n.site_sustain_pk_key
2183: AND p_shift(i).to_time BETWEEN m.effective_date AND Nvl(m.expiration_date, SYSDATE)
2184: ) y,
2185: (SELECT f.*, g.meaning entity_type_name
2186: FROM mth_all_entities_v f, fnd_lookup_values_vl g
2187: WHERE Upper(f.entity_type) = g.lookup_code
2188: AND (g.lookup_type = 'MTH_USER_DEFINED_ENTITIES' OR
2189: g.lookup_type = 'MTH_OTHER_ENTITY_TYPE')
2190: ) z,

Line 2282: FROM mth_all_entities_v f, fnd_lookup_values_vl g

2278: FROM MTH_SITE_SUSTAINABILITIES m
2279: WHERE p_shift(i).to_time BETWEEN m.effective_date AND Nvl(m.expiration_date, SYSDATE)
2280: ) y,
2281: (SELECT f.*, g.meaning entity_type_name
2282: FROM mth_all_entities_v f, fnd_lookup_values_vl g
2283: WHERE Upper(f.entity_type) = g.lookup_code
2284: AND (g.lookup_type = 'MTH_USER_DEFINED_ENTITIES' OR
2285: g.lookup_type = 'MTH_OTHER_ENTITY_TYPE')
2286: ) z,