Product: | JTF - CRM Foundation |
---|---|
Description: | Shows Territory Type's qualifer type usage and the qualifer details. |
Implementation/DBA Data: | APPS.JTF_TERR_TYPE_QUALIFIERS_V |
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