View: PN_LANDLORD_SERVICES_V

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

View Text

SELECT LLS.ROWID ROW_ID
, LLS.LANDLORD_SERVICE_ID LANDLORD_SERVICE_ID
, LLS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LLS.LAST_UPDATED_BY LAST_UPDATED_BY
, LLS.CREATION_DATE CREATION_DATE
, LLS.CREATED_BY CREATED_BY
, LLS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LLS.LEASE_ID LEASE_ID
, LLS.LEASE_CHANGE_ID LEASE_CHANGE_ID
, LLS.SERVICE_TYPE_LOOKUP_CODE SERVICE_TYPE_LOOKUP_CODE
, LLS.START_DATE START_DATE
, LLS.END_DATE END_DATE
, LLS.STATUS STATUS
, LLS.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, LLS.ATTRIBUTE1 ATTRIBUTE1
, LLS.ATTRIBUTE2 ATTRIBUTE2
, LLS.ATTRIBUTE3 ATTRIBUTE3
, LLS.ATTRIBUTE4 ATTRIBUTE4
, LLS.ATTRIBUTE5 ATTRIBUTE5
, LLS.ATTRIBUTE6 ATTRIBUTE6
, LLS.ATTRIBUTE7 ATTRIBUTE7
, LLS.ATTRIBUTE8 ATTRIBUTE8
, LLS.ATTRIBUTE9 ATTRIBUTE9
, LLS.ATTRIBUTE10 ATTRIBUTE10
, LLS.ATTRIBUTE11 ATTRIBUTE11
, LLS.ATTRIBUTE12 ATTRIBUTE12
, LLS.ATTRIBUTE13 ATTRIBUTE13
, LLS.ATTRIBUTE14 ATTRIBUTE14
, LLS.ATTRIBUTE15 ATTRIBUTE15
, LOOK.MEANING SERVICE_TYPE
, LLS.OBLIGATION_NUM OBLIGATION_NUM
, LLS.RESPONSIBILITY_CODE RESPONSIBILITY_CODE
, TLOOK.MEANING RESPONSIBILITY_TYPE
, LLS.COMMON_AREA_RESP COMMON_AREA_RESP
, LLS.FINANCIAL_RESP_PARTY_CODE FINANCIAL_RESP_PARTY_CODE
, RLOOK.MEANING FINANCIAL_RESP_PARTY
, LLS.FINANCIAL_PCT_RESP FINANCIAL_PCT_RESP
, LLS.RESPONSIBILITY_MAINT RESPONSIBILITY_MAINT
, LLS.COMPANY_ID COMPANY_ID
, PNC.NAME RESPONSIBILITY_PROV_NAME
, LLS.OBLIGATION_REFERENCE OBLIGATION_REFERENCE
, LLS.OBLIGATION_COMMENTS OBLIGATION_COMMENTS
, LLS.ORG_ID ORG_ID
FROM FND_LOOKUPS LOOK
, FND_LOOKUPS TLOOK
, FND_LOOKUPS RLOOK
, PN_COMPANIES_ALL PNC
, PN_LANDLORD_SERVICES LLS
WHERE LOOK.LOOKUP_TYPE(+) = 'PN_LANDLORD_SERVICE_TYPE'
AND LOOK.LOOKUP_CODE(+) = LLS.SERVICE_TYPE_LOOKUP_CODE
AND TLOOK.LOOKUP_TYPE(+) = 'PN_OBLIGATION_RESP_TYPE'
AND TLOOK.LOOKUP_CODE(+) = LLS.RESPONSIBILITY_CODE
AND RLOOK.LOOKUP_TYPE(+) = 'PN_OBLIGATION_FIN_RESP_PARTY'
AND RLOOK.LOOKUP_CODE(+) = LLS.FINANCIAL_RESP_PARTY_CODE
AND PNC.COMPANY_ID(+) = LLS.COMPANY_ID ORDER BY TO_NUMBER(OBLIGATION_NUM)

Columns