VIEW: APPS.PN_VAR_RENT_ADJ_V

Source

View Text - Preformatted

SELECT pn_inv.ROWID row_id ,pn_inv.VAR_RENT_INV_ID var_rent_inv_id ,pn_inv.INVOICE_DATE invoice_date ,pn_inv.ADJUST_NUM adjust_num ,pn_inv.TOT_ACT_VOL tot_act_vol ,pn_inv.FOR_PER_RENT for_per_rent ,pn_inv.ACT_PER_RENT act_per_rent ,pn_inv.CONSTR_ACTUAL_RENT constr_actual_rent ,pn_inv.ABATEMENT_APPL abatement_appl ,pn_var_rent_calc_pkg.actual_rent(pn_inv.PERIOD_ID,pn_inv.INVOICE_DATE,pn_inv.TRUE_UP_AMT,pn_inv.VAR_RENT_INV_ID) AS actual_invoiced_amount ,decode(pn_inv.adjust_num ,0,(pn_inv.ACTUAL_INVOICED_AMOUNT - nvl(pn_inv.FOR_PER_RENT,0)) ,pn_inv.ACTUAL_INVOICED_AMOUNT) adjustment ,pn_var_rent_calc_pkg.prev_invoiced_amt(pn_inv.VAR_RENT_INV_ID, pn_inv.PERIOD_ID,pn_inv.INVOICE_DATE) AS PREV_INVOICED_AMOUNT ,pn_inv.NEGATIVE_RENT negative_rent ,(pn_inv.ACT_PER_RENT - pn_inv.FOR_PER_RENT) variance ,pn_inv.ACTUAL_TERM_STATUS actual_term_status ,pn_inv.FORECASTED_TERM_STATUS forecasted_term_status ,pn_inv.VARIANCE_TERM_STATUS variance_term_status ,pn_inv.TRUE_UP_STATUS true_up_status ,pn_inv.COMMENTS comments ,pn_inv.ACTUAL_EXP_CODE actual_exp_code ,pn_inv.FORECASTED_EXP_CODE forecasted_exp_code ,pn_inv.VARIANCE_EXP_CODE variance_exp_code ,pn_inv.REC_ABATEMENT rec_abatement ,pn_inv.REC_ABATEMENT_OVERRIDE rec_abatement_override ,pn_inv.PERIOD_ID period_id ,pn_inv.VAR_RENT_ID var_rent_id ,pn_inv.LAST_UPDATE_DATE last_update_date ,pn_inv.LAST_UPDATED_BY last_updated_by ,pn_inv.CREATION_DATE creation_date ,pn_inv.CREATED_BY created_by ,pn_inv.LAST_UPDATE_LOGIN last_update_login ,pn_inv.ATTRIBUTE_CATEGORY attribute_category ,pn_inv.ATTRIBUTE1 attribute1 ,pn_inv.ATTRIBUTE2 attribute2 ,pn_inv.ATTRIBUTE3 attribute3 ,pn_inv.ATTRIBUTE4 attribute4 ,pn_inv.ATTRIBUTE5 attribute5 ,pn_inv.ATTRIBUTE6 attribute6 ,pn_inv.ATTRIBUTE7 attribute7 ,pn_inv.ATTRIBUTE8 attribute8 ,pn_inv.ATTRIBUTE9 attribute9 ,pn_inv.ATTRIBUTE10 attribute10 ,pn_inv.ATTRIBUTE11 attribute11 ,pn_inv.ATTRIBUTE12 attribute12 ,pn_inv.ATTRIBUTE13 attribute13 ,pn_inv.ATTRIBUTE14 attribute14 ,pn_inv.ATTRIBUTE15 attribute15 ,pn_inv.ORG_ID org_id ,pn_inv.true_up_amt true_up_amt ,pn_var_rent_calc_pkg.inv_sch_date(pn_inv.invoice_date,pn_inv.var_rent_id,pn_inv.period_id) as inv_schedule_date FROM pn_var_rent_inv pn_inv

View Text - HTML Formatted

SELECT PN_INV.ROWID ROW_ID
, PN_INV.VAR_RENT_INV_ID VAR_RENT_INV_ID
, PN_INV.INVOICE_DATE INVOICE_DATE
, PN_INV.ADJUST_NUM ADJUST_NUM
, PN_INV.TOT_ACT_VOL TOT_ACT_VOL
, PN_INV.FOR_PER_RENT FOR_PER_RENT
, PN_INV.ACT_PER_RENT ACT_PER_RENT
, PN_INV.CONSTR_ACTUAL_RENT CONSTR_ACTUAL_RENT
, PN_INV.ABATEMENT_APPL ABATEMENT_APPL
, PN_VAR_RENT_CALC_PKG.ACTUAL_RENT(PN_INV.PERIOD_ID
, PN_INV.INVOICE_DATE
, PN_INV.TRUE_UP_AMT
, PN_INV.VAR_RENT_INV_ID) AS ACTUAL_INVOICED_AMOUNT
, DECODE(PN_INV.ADJUST_NUM
, 0
, (PN_INV.ACTUAL_INVOICED_AMOUNT - NVL(PN_INV.FOR_PER_RENT
, 0))
, PN_INV.ACTUAL_INVOICED_AMOUNT) ADJUSTMENT
, PN_VAR_RENT_CALC_PKG.PREV_INVOICED_AMT(PN_INV.VAR_RENT_INV_ID
, PN_INV.PERIOD_ID
, PN_INV.INVOICE_DATE) AS PREV_INVOICED_AMOUNT
, PN_INV.NEGATIVE_RENT NEGATIVE_RENT
, (PN_INV.ACT_PER_RENT - PN_INV.FOR_PER_RENT) VARIANCE
, PN_INV.ACTUAL_TERM_STATUS ACTUAL_TERM_STATUS
, PN_INV.FORECASTED_TERM_STATUS FORECASTED_TERM_STATUS
, PN_INV.VARIANCE_TERM_STATUS VARIANCE_TERM_STATUS
, PN_INV.TRUE_UP_STATUS TRUE_UP_STATUS
, PN_INV.COMMENTS COMMENTS
, PN_INV.ACTUAL_EXP_CODE ACTUAL_EXP_CODE
, PN_INV.FORECASTED_EXP_CODE FORECASTED_EXP_CODE
, PN_INV.VARIANCE_EXP_CODE VARIANCE_EXP_CODE
, PN_INV.REC_ABATEMENT REC_ABATEMENT
, PN_INV.REC_ABATEMENT_OVERRIDE REC_ABATEMENT_OVERRIDE
, PN_INV.PERIOD_ID PERIOD_ID
, PN_INV.VAR_RENT_ID VAR_RENT_ID
, PN_INV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PN_INV.LAST_UPDATED_BY LAST_UPDATED_BY
, PN_INV.CREATION_DATE CREATION_DATE
, PN_INV.CREATED_BY CREATED_BY
, PN_INV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PN_INV.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PN_INV.ATTRIBUTE1 ATTRIBUTE1
, PN_INV.ATTRIBUTE2 ATTRIBUTE2
, PN_INV.ATTRIBUTE3 ATTRIBUTE3
, PN_INV.ATTRIBUTE4 ATTRIBUTE4
, PN_INV.ATTRIBUTE5 ATTRIBUTE5
, PN_INV.ATTRIBUTE6 ATTRIBUTE6
, PN_INV.ATTRIBUTE7 ATTRIBUTE7
, PN_INV.ATTRIBUTE8 ATTRIBUTE8
, PN_INV.ATTRIBUTE9 ATTRIBUTE9
, PN_INV.ATTRIBUTE10 ATTRIBUTE10
, PN_INV.ATTRIBUTE11 ATTRIBUTE11
, PN_INV.ATTRIBUTE12 ATTRIBUTE12
, PN_INV.ATTRIBUTE13 ATTRIBUTE13
, PN_INV.ATTRIBUTE14 ATTRIBUTE14
, PN_INV.ATTRIBUTE15 ATTRIBUTE15
, PN_INV.ORG_ID ORG_ID
, PN_INV.TRUE_UP_AMT TRUE_UP_AMT
, PN_VAR_RENT_CALC_PKG.INV_SCH_DATE(PN_INV.INVOICE_DATE
, PN_INV.VAR_RENT_ID
, PN_INV.PERIOD_ID) AS INV_SCHEDULE_DATE
FROM PN_VAR_RENT_INV PN_INV