[Home] [Help]
View: 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
TERM_HISTORY_ID |
PAYMENT_TERM_ID |
LEASE_CHANGE_ID |
PREV_TERM_HISTORY_ID |
CHANGE_TYPE_LOOKUP_CODE |
CHANGE_TYPE |
CHANGE_DATE |
CREATED_BY |
USER_RESPONSIBLE |
TOTAL_ADJ_AMOUNT |
AMEND_NAME |
CHANGE_COMMENCEMENT_DATE |
CHANGE_TERMINATION_DATE |
CHANGE_EXECUTION_DATE |
ORG_ID |
LEASE_ID |
LEASE_NAME |
LEASE_NUMBER |
Name |