View: PN_CONTACTS_V

Product:	PN - Property Manager
Description:
Implementation/DBA Data:	APPS.PN_CONTACTS_V

View Text

SELECT CO.ROWID ROW_ID
, CO.CONTACT_ID CONTACT_ID
, CO.COMPANY_SITE_ID COMPANY_SITE_ID
, CO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CO.LAST_UPDATED_BY LAST_UPDATED_BY
, CO.CREATION_DATE CREATION_DATE
, CO.CREATED_BY CREATED_BY
, CO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CO.STATUS STATUS
, CO.LAST_NAME LAST_NAME
, CO.FIRST_NAME FIRST_NAME
, CO.JOB_TITLE JOB_TITLE
, CO.MAIL_STOP MAIL_STOP
, CO.EMAIL_ADDRESS EMAIL_ADDRESS
, CO.PRIMARY_FLAG PRIMARY_FLAG
, CO.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CO.ATTRIBUTE1 ATTRIBUTE1
, CO.ATTRIBUTE2 ATTRIBUTE2
, CO.ATTRIBUTE3 ATTRIBUTE3
, CO.ATTRIBUTE4 ATTRIBUTE4
, CO.ATTRIBUTE5 ATTRIBUTE5
, CO.ATTRIBUTE6 ATTRIBUTE6
, CO.ATTRIBUTE7 ATTRIBUTE7
, CO.ATTRIBUTE8 ATTRIBUTE8
, CO.ATTRIBUTE9 ATTRIBUTE9
, CO.ATTRIBUTE10 ATTRIBUTE10
, CO.ATTRIBUTE11 ATTRIBUTE11
, CO.ATTRIBUTE12 ATTRIBUTE12
, CO.ATTRIBUTE13 ATTRIBUTE13
, CO.ATTRIBUTE14 ATTRIBUTE14
, CO.ATTRIBUTE15 ATTRIBUTE15
, JLOOK.MEANING JOB_TITLE_MEANING
, CO.ORG_ID ORG_ID
FROM FND_LOOKUPS JLOOK
, PN_CONTACTS CO
WHERE JLOOK.LOOKUP_TYPE (+) = 'PN_JOB_TITLE'
AND JLOOK.LOOKUP_CODE (+) = CO.JOB_TITLE

Columns