PSC_LNP_STATUS_HISTORY_V

Details

• Schema: FUSION

• Object owner: PSC_PER

• Object type: VIEW

Columns

Name
TRANSACTION_KEY LNP_RECORD_KEY TRANSACTION_TYPE RECORD_TYPE_CODE RECORD_TYPE_ID FROM_STATUS FROM_SYS_STATUS FROM_STATUS_DATE TO_STATUS TO_STATUS_DATE

Query

SQL_Statement

SELECT hist.transaction_key, hist.lnp_record_key, hist.TRANSACTION_TYPE, rectype.RECORD_TYPE_CODE , rectype.RECORD_TYPE_ID, hist.new_value AS from_status, hist.rel_new_value AS from_sys_status, hist.change_date AS from_status_date, LEAD(hist.new_value) OVER(PARTITION BY hist.transaction_key ORDER BY hist.change_date ) AS to_status, LEAD(hist.change_date) OVER(PARTITION BY hist.transaction_key ORDER BY hist.change_date ) AS to_status_date FROM psc_lnp_status_history hist, psc_lnp_record_type_b rectype WHERE hist.record_type_code = rectype.record_type_code