VIEW: APPS.PN_TERM_HISTORY_HEADER_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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