VIEW: APPS.PN_LEASE_TRANSACTIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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