VIEW: APPS.JTF_TERR_SRCH_ADV_TYPE_V

Source

View Text - Preformatted

SELECT JTTYPE.TERR_TYPE_ID, JTTYPE.NAME, JTTYPE.START_DATE_ACTIVE, JTTYPE.END_DATE_ACTIVE, JTS.MEANING TERR_USAGE, null, null, null FROM JTF_TERR_TYPE_USGS JTTU, JTF_TERR_TYPES JTTYPE, JTF_SOURCES JTS WHERE JTTU.TERR_TYPE_ID = JTTYPE.TERR_TYPE_ID and JTTU.SOURCE_ID = JTS.SOURCE_ID

View Text - HTML Formatted

SELECT JTTYPE.TERR_TYPE_ID
, JTTYPE.NAME
, JTTYPE.START_DATE_ACTIVE
, JTTYPE.END_DATE_ACTIVE
, JTS.MEANING TERR_USAGE
, NULL
, NULL
, NULL
FROM JTF_TERR_TYPE_USGS JTTU
, JTF_TERR_TYPES JTTYPE
, JTF_SOURCES JTS
WHERE JTTU.TERR_TYPE_ID = JTTYPE.TERR_TYPE_ID
AND JTTU.SOURCE_ID = JTS.SOURCE_ID