VIEW: APPS.JTF_TERR_TYPE_QUALIFIERS_V

Source

View Text - Preformatted

SELECT J1.ROWID ROW_ID , J1.TERR_TYPE_QUAL_ID TERR_TYPE_QUAL_ID , J1.LAST_UPDATE_DATE LAST_UPDATE_DATE , J1.LAST_UPDATED_BY LAST_UPDATED_BY , J1.CREATION_DATE CREATION_DATE , J1.CREATED_BY CREATED_BY , J1.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , J1.QUAL_USG_ID QUAL_USG_ID , J1.TERR_TYPE_ID TERR_TYPE_ID , J1.QUALIFIER_MODE QUALIFIER_MODE , J1.EXCLUSIVE_USE_FLAG EXCLUSIVE_USE_FLAG , J1.OVERLAP_ALLOWED_FLAG OVERLAP_ALLOWED_FLAG , J1.IN_USE_FLAG IN_USE_FLAG , J1.ORG_ID ORG_ID , J2.DISPLAY_TYPE DISPLAY_TYPE , J2.LOV_SQL LOV_SQL , J2.CONVERT_TO_ID_FLAG CONVERT_TO_ID_FLAG , J2.COLUMN_COUNT , J2.FORMATTING_FUNCTION_FLAG , J2.FORMATTING_FUNCTION_NAME , J2.SPECIAL_FUNCTION_FLAG , J2.SPECIAL_FUNCTION_NAME , J2.ENABLE_LOV_VALIDATION , J2.DISPLAY_SQL1 , J2.LOV_SQL2 , J2.DISPLAY_SQL2 , J2.LOV_SQL3 , J2.DISPLAY_SQL3 , J4.QUAL_TYPE_ID QUAL_TYPE_ID , J5.NAME QUALIFIER_TYPE_NAME , J5.DESCRIPTION QUALIFIER_TYPE_DESCRIPTION , J3.NAME QUALIFIER_NAME FROM JTF_TERR_TYPE_QUAL J1 , JTF_QUAL_USGS J2 , JTF_SEEDED_QUAL J3 , JTF_QUAL_TYPE_USGS J4 , JTF_QUAL_TYPES J5 WHERE J1.QUAL_USG_ID = J2.QUAL_USG_ID AND J2.SEEDED_QUAL_ID = J3.SEEDED_QUAL_ID AND J2.QUAL_TYPE_USG_ID = J4.QUAL_TYPE_USG_ID AND J4.QUAL_TYPE_ID = J5.QUAL_TYPE_ID

View Text - HTML Formatted

SELECT J1.ROWID ROW_ID
, J1.TERR_TYPE_QUAL_ID TERR_TYPE_QUAL_ID
, J1.LAST_UPDATE_DATE LAST_UPDATE_DATE
, J1.LAST_UPDATED_BY LAST_UPDATED_BY
, J1.CREATION_DATE CREATION_DATE
, J1.CREATED_BY CREATED_BY
, J1.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, J1.QUAL_USG_ID QUAL_USG_ID
, J1.TERR_TYPE_ID TERR_TYPE_ID
, J1.QUALIFIER_MODE QUALIFIER_MODE
, J1.EXCLUSIVE_USE_FLAG EXCLUSIVE_USE_FLAG
, J1.OVERLAP_ALLOWED_FLAG OVERLAP_ALLOWED_FLAG
, J1.IN_USE_FLAG IN_USE_FLAG
, J1.ORG_ID ORG_ID
, J2.DISPLAY_TYPE DISPLAY_TYPE
, J2.LOV_SQL LOV_SQL
, J2.CONVERT_TO_ID_FLAG CONVERT_TO_ID_FLAG
, J2.COLUMN_COUNT
, J2.FORMATTING_FUNCTION_FLAG
, J2.FORMATTING_FUNCTION_NAME
, J2.SPECIAL_FUNCTION_FLAG
, J2.SPECIAL_FUNCTION_NAME
, J2.ENABLE_LOV_VALIDATION
, J2.DISPLAY_SQL1
, J2.LOV_SQL2
, J2.DISPLAY_SQL2
, J2.LOV_SQL3
, J2.DISPLAY_SQL3
, J4.QUAL_TYPE_ID QUAL_TYPE_ID
, J5.NAME QUALIFIER_TYPE_NAME
, J5.DESCRIPTION QUALIFIER_TYPE_DESCRIPTION
, J3.NAME QUALIFIER_NAME
FROM JTF_TERR_TYPE_QUAL J1
, JTF_QUAL_USGS J2
, JTF_SEEDED_QUAL J3
, JTF_QUAL_TYPE_USGS J4
, JTF_QUAL_TYPES J5
WHERE J1.QUAL_USG_ID = J2.QUAL_USG_ID
AND J2.SEEDED_QUAL_ID = J3.SEEDED_QUAL_ID
AND J2.QUAL_TYPE_USG_ID = J4.QUAL_TYPE_USG_ID
AND J4.QUAL_TYPE_ID = J5.QUAL_TYPE_ID