DBA Data[Home] [Help]

APPS.CSF_GPS_PUB dependencies on CSF_GPS_VENDOR_STATUS_MAPS

Line 135: SELECT NVL(fl.meaning, stmap.internal_status_code) FROM fnd_lookups fl, csf_gps_vendor_status_maps stmap

131: , l.parked_time
132: , l.address
133: , d.device_tag
134: , (
135: SELECT NVL(fl.meaning, stmap.internal_status_code) FROM fnd_lookups fl, csf_gps_vendor_status_maps stmap
136: WHERE fl.lookup_type = 'CSF_GPS_DEVICE_STATUSES' AND fl.lookup_code = stmap.internal_status_code AND stmap.vendor_status_code = l.status
137: ) status_code_meaning
138: , l.creation_date
139: FROM csf_gps_location_feeds l

Line 160: SELECT NVL(fl.meaning, stmap.internal_status_code) FROM fnd_lookups fl, csf_gps_vendor_status_maps stmap

156: , l.parked_time
157: , l.address
158: , d.device_tag
159: , (
160: SELECT NVL(fl.meaning, stmap.internal_status_code) FROM fnd_lookups fl, csf_gps_vendor_status_maps stmap
161: WHERE fl.lookup_type = 'CSF_GPS_DEVICE_STATUSES' AND fl.lookup_code = stmap.internal_status_code AND stmap.vendor_status_code = l.status
162: ) status_code_meaning
163: , l.creation_date
164: FROM csf_gps_location_feeds l