PN Generate Lease Analysis

Description
Categories: BI Publisher
Application: Property Manager
Source: Generate Lease Analysis Report
Short Name: PNLAR_XML
DB package:
SELECT pn_transaction_util.get_lease_liability(p_lease_id         => pla.lease_id,
                                               p_org_id           => pla.org_id,
											   p_currency		  => :currency,
                                               p_as_of_date       => trunc(:as_of_date),
                                               p_termination_date => trunc(plda.lease_termination_date),
                                               p_month            => 12,
                                               p_mode             => 'U') und_less_one_year,
       pn_transaction_util.get_lease_liability(p_lease_id         => pla.lease_id,
                                               p_org_id           => pla.org_id,
											   p_currency		  => :currency,
                                               p_as_of_date       => trunc(:as_of_date),
                                               p_termination_date => trunc(plda.lease_termination_date),
                                               p_month            => 60,
                                               p_mode             => 'U') und_less_five_years,
       pn_transaction_util.get_liability_more(p_lease_id         => pla.lease_id,
                                              p_org_id           => pla.org_id,
											  p_currency		 => :currency,
                                              p_as_of_date       => trunc(:as_of_date),
                                              p_termination_date => trunc(plda.lease_termination_date),
                                              p_month            => 60,
                                              p_mode             => 'U') und_later_five_years,
       pn_transaction_util.get_lease_liability(p_lease_id         => pla.lease_id,
                                               p_org_id           => pla.org_id,
											   p_currency		  => :currency,
                                               p_as_of_date       => trunc(:as_of_date),
                                               p_termination_date => trunc(plda.lease_termination_date),
                                               p_month            => 12,
                                               p_mode             => 'D') dis_less_one_year,
       pn_transaction_util.get_lease_liability(p_lease_id         => pla.lease_id,
                                               p_org_id           => pla.org_id,
											   p_currency		  => :currency,
                                               p_as_of_date       => trunc(:as_of_date),
                                               p_termination_date => trunc(plda.lease_termination_date),
                                               p_month            => 60,
                                               p_mode             => 'D') dis_less_five_years,
       pn_transaction_util.get_liability_more(p_lease_id         => pla.lease_id,
                                              p_org_id           => pla.org_id,
											  p_currency		 => :currency,
                                              p_as_of_date       => trunc(:as_of_date),
                                              p_termination_date => trunc(plda.lease_termination_date),
                                              p_month            => 60,
                                              p_mode             => 'D') dis_later_five_years
  FROM pn_leases_all pla, pn_lease_details_all plda
 WHERE pla.lease_id = :lease_id
   AND pla.lease_id = plda.lease_id
Parameter Name SQL text Validation
Representation
 
LOV Oracle
As of Date
 
LOV Oracle