View: PN_TERM_HISTORY_HEADER_V

Product:	PN - Property Manager
Description:	Term History Header Form View.
Implementation/DBA Data:	APPS.PN_TERM_HISTORY_HEADER_V

View Text

SELECT PTH.TERM_HISTORY_ID TERM_HISTORY_ID
, PTH.PAYMENT_TERM_ID PAYMENT_TERM_ID
, PTH.LEASE_CHANGE_ID LEASE_CHANGE_ID
, PTH.PREV_TERM_HISTORY_ID PREV_TERM_HISTORY_ID
, LC.CHANGE_TYPE_LOOKUP_CODE CHANGE_TYPE_LOOKUP_CODE
, FLC.MEANING CHANGE_TYPE
, LC.CREATION_DATE CHANGE_DATE
, LC.CREATED_BY CREATED_BY
, FU.USER_NAME USER_RESPONSIBLE
, PTH.TOTAL_ADJ_AMOUNT TOTAL_ADJ_AMOUNT
, DECODE(LC.LEASE_CHANGE_NAME
, 'EDIT'
, NULL
, LC.LEASE_CHANGE_NAME) AMEND_NAME
, LC.CHANGE_COMMENCEMENT_DATE CHANGE_COMMENCEMENT_DATE
, LC.CHANGE_TERMINATION_DATE CHANGE_TERMINATION_DATE
, LC.CHANGE_EXECUTION_DATE CHANGE_EXECUTION_DATE
, PT.ORG_ID ORG_ID
, PL.LEASE_ID LEASE_ID
, PL.NAME LEASE_NAME
, PL.LEASE_NUM LEASE_NUMBER
FROM FND_USER FU
, FND_LOOKUPS FLC
, PN_LEASE_CHANGES_ALL LC
, PN_LEASES_ALL PL
, PN_PAYMENT_TERMS_ALL PT
, PN_PAYMENT_TERMS_HISTORY PTH
WHERE LC.LEASE_CHANGE_ID = PTH.LEASE_CHANGE_ID
AND PTH.PAYMENT_TERM_ID = PT.PAYMENT_TERM_ID
AND LC.LEASE_ID = PL.LEASE_ID
AND FLC.LOOKUP_TYPE (+) = 'PN_LEASE_CHANGE_TYPE'
AND FLC.LOOKUP_CODE (+) = LC.CHANGE_TYPE_LOOKUP_CODE
AND FU.USER_ID (+) = LC.CREATED_BY

Columns