VIEW: APPS.PN_VAR_PERIODS_DATES_V

Source

View Text - Preformatted

SELECT per.rowid ,per.period_id ,per.period_num ,per.var_rent_id ,per.start_date ,per.end_date ,varent.uom_code ,varent.rent_num ,varent.lease_id ,varent_dates.invg_freq_code ,varent_dates.recon_freq_code ,varent_dates.reptg_freq_code ,varent_dates.audit_freq_code ,per.last_update_date ,per.last_updated_by ,per.creation_date ,per.created_by ,per.last_update_login ,varent.org_id ,(select sum(rent_inv.actual_invoiced_amount) from pn_var_rent_inv_all rent_inv WHERE rent_inv.period_id = per.period_id) tot_var_rent FROM pn_var_rent_dates_all varent_dates, pn_var_rents varent, pn_var_periods_all per WHERE per.var_rent_id = varent.var_rent_id AND varent.var_rent_id = varent_dates.var_rent_id

View Text - HTML Formatted

SELECT PER.ROWID
, PER.PERIOD_ID
, PER.PERIOD_NUM
, PER.VAR_RENT_ID
, PER.START_DATE
, PER.END_DATE
, VARENT.UOM_CODE
, VARENT.RENT_NUM
, VARENT.LEASE_ID
, VARENT_DATES.INVG_FREQ_CODE
, VARENT_DATES.RECON_FREQ_CODE
, VARENT_DATES.REPTG_FREQ_CODE
, VARENT_DATES.AUDIT_FREQ_CODE
, PER.LAST_UPDATE_DATE
, PER.LAST_UPDATED_BY
, PER.CREATION_DATE
, PER.CREATED_BY
, PER.LAST_UPDATE_LOGIN
, VARENT.ORG_ID
, (SELECT SUM(RENT_INV.ACTUAL_INVOICED_AMOUNT)
FROM PN_VAR_RENT_INV_ALL RENT_INV
WHERE RENT_INV.PERIOD_ID = PER.PERIOD_ID) TOT_VAR_RENT
FROM PN_VAR_RENT_DATES_ALL VARENT_DATES
, PN_VAR_RENTS VARENT
, PN_VAR_PERIODS_ALL PER
WHERE PER.VAR_RENT_ID = VARENT.VAR_RENT_ID
AND VARENT.VAR_RENT_ID = VARENT_DATES.VAR_RENT_ID