eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PN_LEASE_TRANSACTIONS_V

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

View Text

SELECT LTRX.ROWID ROW_ID
, LTRX.LEASE_TRANSACTION_ID
, LTRX.LEASE_ID
, LTRX.LOCATION_ID
, LTRX.TRANSACTION_TYPE TRANSACTION_TYPE_CODE
, LTRX.LAST_UPDATE_DATE
, LTRX.LAST_UPDATED_BY
, LTRX.CREATION_DATE
, LTRX.CREATED_BY
, LTRX.LAST_UPDATE_LOGIN
, LTRX.DATE_EFFECTIVE
, FLV.MEANING TRANSACTION_TYPE
, FNC.USER_NAME CREATED_BY_NAME
, LCHANGE.LEASE_CHANGE_ID LEASE_CHANGE_ID
, LTRX.ORG_ID
FROM FND_LOOKUPS FLV
, FND_USER FNC
, PN_LEASE_CHANGES_ALL LCHANGE
, PN_LEASE_TRANSACTIONS LTRX
WHERE LCHANGE.LEASE_TRANSACTION_ID = LTRX.LEASE_TRANSACTION_ID AND FLV.LOOKUP_CODE = LTRX.TRANSACTION_TYPE AND FLV.LOOKUP_TYPE = 'PN_LEASE_CHANGE_TYPE' AND FNC.USER_ID = LTRX.CREATED_BY

Columns

Name
ROW_ID
LEASE_TRANSACTION_ID
LEASE_ID
LOCATION_ID
TRANSACTION_TYPE_CODE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
DATE_EFFECTIVE
TRANSACTION_TYPE
CREATED_BY_NAME
LEASE_CHANGE_ID
ORG_ID