View: PN_COMPANIES_V

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

View Text

SELECT COMP.ROWID ROW_ID
, COMP.COMPANY_ID COMPANY_ID
, COMP.COMPANY_NUMBER COMPANY_NUMBER
, COMP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, COMP.LAST_UPDATED_BY LAST_UPDATED_BY
, COMP.CREATION_DATE CREATION_DATE
, COMP.CREATED_BY CREATED_BY
, COMP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, COMP.NAME NAME
, COMP.ENABLED_FLAG ENABLED_FLAG
, COMP.PARENT_COMPANY_ID PARENT_COMPANY_ID
, COMP.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, COMP.ATTRIBUTE1 ATTRIBUTE1
, COMP.ATTRIBUTE2 ATTRIBUTE2
, COMP.ATTRIBUTE3 ATTRIBUTE3
, COMP.ATTRIBUTE4 ATTRIBUTE4
, COMP.ATTRIBUTE5 ATTRIBUTE5
, COMP.ATTRIBUTE6 ATTRIBUTE6
, COMP.ATTRIBUTE7 ATTRIBUTE7
, COMP.ATTRIBUTE8 ATTRIBUTE8
, COMP.ATTRIBUTE9 ATTRIBUTE9
, COMP.ATTRIBUTE10 ATTRIBUTE10
, COMP.ATTRIBUTE11 ATTRIBUTE11
, COMP.ATTRIBUTE12 ATTRIBUTE12
, COMP.ATTRIBUTE13 ATTRIBUTE13
, COMP.ATTRIBUTE14 ATTRIBUTE14
, COMP.ATTRIBUTE15 ATTRIBUTE15
, PCOMP.NAME PARENT_COMPANY_NAME
, COMP.ORG_ID ORG_ID
FROM PN_COMPANIES_ALL PCOMP
, PN_COMPANIES COMP
WHERE COMP.PARENT_COMPANY_ID = PCOMP.COMPANY_ID (+)

Columns