VIEW: APPS.JTF_TYPE_TRANSACTIONS_V

Source

View Text - Preformatted

SELECT J1.ROWID ROW_ID , J1.TYPE_QTYPE_USG_ID TYPE_QTYPE_USG_ID , J1.LAST_UPDATED_BY LAST_UPDATED_BY , J1.LAST_UPDATE_DATE LAST_UPDATE_DATE , J1.CREATED_BY CREATED_BY , J1.CREATION_DATE CREATION_DATE , J1.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , J1.TERR_TYPE_ID TERR_TYPE_ID , J1.QUAL_TYPE_USG_ID QUAL_TYPE_USG_ID , J1.ORG_ID ORG_ID , J2.SOURCE_ID SOURCE_ID , J3.QUAL_TYPE_ID QUAL_TYPE_ID , J3.NAME QUALIFIER_TYPE_NAME , J3.DESCRIPTION QUALIFIER_TYPE_DESCRIPTION FROM JTF_TYPE_QTYPE_USGS J1 , JTF_QUAL_TYPE_USGS J2 , JTF_QUAL_TYPES J3 WHERE J1.QUAL_TYPE_USG_ID = J2.QUAL_TYPE_USG_ID AND J2.QUAL_TYPE_ID = J3.QUAL_TYPE_ID

View Text - HTML Formatted

SELECT J1.ROWID ROW_ID
, J1.TYPE_QTYPE_USG_ID TYPE_QTYPE_USG_ID
, J1.LAST_UPDATED_BY LAST_UPDATED_BY
, J1.LAST_UPDATE_DATE LAST_UPDATE_DATE
, J1.CREATED_BY CREATED_BY
, J1.CREATION_DATE CREATION_DATE
, J1.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, J1.TERR_TYPE_ID TERR_TYPE_ID
, J1.QUAL_TYPE_USG_ID QUAL_TYPE_USG_ID
, J1.ORG_ID ORG_ID
, J2.SOURCE_ID SOURCE_ID
, J3.QUAL_TYPE_ID QUAL_TYPE_ID
, J3.NAME QUALIFIER_TYPE_NAME
, J3.DESCRIPTION QUALIFIER_TYPE_DESCRIPTION
FROM JTF_TYPE_QTYPE_USGS J1
, JTF_QUAL_TYPE_USGS J2
, JTF_QUAL_TYPES J3
WHERE J1.QUAL_TYPE_USG_ID = J2.QUAL_TYPE_USG_ID
AND J2.QUAL_TYPE_ID = J3.QUAL_TYPE_ID