View: JTF_QUAL_TYPES

Product:	JTF - CRM Foundation
Description:	Same as JTF_QUAL_TYPES_ALL table
Implementation/DBA Data:	APPS.JTF_QUAL_TYPES

View Text

SELECT QTY.QUAL_TYPE_ID
, QTY.LAST_UPDATE_DATE
, QTY.LAST_UPDATED_BY
, QTY.CREATION_DATE
, QTY.CREATED_BY
, QTY.LAST_UPDATE_LOGIN
, QTY.NAME
, LKP.MEANING DESCRIPTION
, QTY.SELECT_CLAUSE
, QTY.WHERE_CLAUSE
, QTY.VIEW_NAME
, QTY.VIEW_DDL_FILENAME
, QTY.RELATED_ID1
, QTY.RELATED_ID2
, QTY.RELATED_ID3
, QTY.RELATED_ID4
, QTY.RELATED_ID5
, QTY.ORG_ID
FROM FND_LOOKUPS LKP
, JTF_QUAL_TYPES_ALL QTY
WHERE QTY.NAME = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'JTF_TERR_QUAL_TYPES'

Columns