PN Generate Lease Details

Description
Categories: BI Publisher
Application: Property Manager
Source: Generate Lease Details Report
Short Name: PNGLDR_XML
DB package:
SELECT payment_term_id,
       currency_code payment_currency,
       (SELECT meaning
        FROM fnd_lookups
        WHERE lookup_type = 'PN_PAYMENT_PURPOSE_TYPE'
        AND lookup_code = payment_purpose_code) payment_purpose,
       actual_amount,
       to_char(start_date, 'DD-Mon-YY') start_date,
       to_char(end_date, 'DD-Mon-YY') end_date,
       decode(:payment_term_proration_rule,'365 Days/Year',
              CEIL(months_between(last_day(end_date),TO_DATE(TO_CHAR(start_date,'YYYY/MM'),'YYYY/MM'))) + 
              decode(to_char(start_date,'DD'),'01',0,(last_day(start_date)+1-start_date)/365*12-1) + 
              decode(to_char(end_date,'DD'),to_char(last_day(end_date),'DD'),0,TO_NUMBER(TO_CHAR(end_date,'DD'))/365*12-1),
              '360 Days/Year',
              CEIL(months_between(last_day(end_date),TO_DATE(TO_CHAR(start_date,'YYYY/MM'),'YYYY/MM'))) + 
              decode(to_char(start_date,'DD'),'01',0,(last_day(start_date)+1-start_date)/360*12-1) + 
              decode(to_char(end_date,'DD'),to_char(last_day(end_date),'DD'),0,TO_NUMBER(TO_CHAR(end_date,'DD'))/360*12-1),
              'Days/Month',
              CEIL(months_between(last_day(end_date),TO_DATE(TO_CHAR(start_date,'YYYY/MM'),'YYYY/MM'))) + 
              decode(to_char(start_date,'DD'),'01',0,(last_day(start_date)+1-start_date)/TO_NUMBER(TO_CHAR(LAST_DAY(START_DATE),'DD'))-1) + 
              decode(to_char(end_date,'DD'),to_char(last_day(end_date),'DD'),0,
                     TO_NUMBER(TO_CHAR(end_date,'DD'))/TO_NUMBER(TO_CHAR(LAST_DAY(END_DATE),'DD')))-1) duration,
       decode(liability_flag, 'Y', 'Yes', 'No') liability_flag,
       decode(rou_asset_flag, 'Y', 'Yes', 'No') rou_asset_flag,
	   decode(rept_inception_flag, 'Y', 'Yes', 'No') rept_inception_flag,
       schedule_day,
       (SELECT meaning
        FROM fnd_lookups
        WHERE lookup_type = 'PN_PAYMENT_FREQUENCY_TYPE'
        AND lookup_code = frequency_code) payment_frequency,
	    (SELECT meaning
        FROM fnd_lookups
        WHERE lookup_type = 'PN_PAYMENT_TERM_TYPE'
        AND lookup_code = payment_term_type_code) payment_type,
		:rate_value term_rate_value,
		decode(to_char(:initial_rate),null,-99999,:initial_rate) term_initial_rate,
		:accounting_method term_accounting_method
FROM pn_payment_terms_all pta
WHERE pta.lease_id = :lease_id
AND PN_ACCNTING_BAL_STREAMS.GET_LEASE_DATA_SOURCE(:as_of_date,:ledger_id) = 'P'
AND (nvl(pn_transaction_util.get_transition_date(:org_id),TRUNC(:as_of_date)) >= 
    TRUNC(:as_of_date) OR pn_system_pub.get_frozen_flag (:org_id) = 'N')
AND (((pta.index_period_id IS NOT NULL OR pta.var_rent_inv_id IS NOT NULL OR pta.period_billrec_id IS NOT NULL OR pta.opex_agr_id IS NOT NULL)
       and pta.status = 'APPROVED') OR 
     (pta.index_period_id IS NULL AND pta.var_rent_inv_id IS NULL AND pta.period_billrec_id IS NULL AND pta.opex_agr_id IS NULL) OR 
       (pta.opex_agr_id IS NOT NULL AND pta.status IS NULL))
UNION
SELECT payment_term_id,
       currency_code payment_currency,
	   (SELECT meaning
        FROM fnd_lookups
        WHERE lookup_type = 'PN_PAYMENT_PURPOSE_TYPE'
        AND lookup_code = payment_purpose_code) payment_purpose,
       actual_amount,
       to_char(start_date, 'DD-Mon-YY') start_date,
       to_char(end_date, 'DD-Mon-YY') end_date,
       decode(:payment_term_proration_rule,'365 Days/Year',
              CEIL(months_between(last_day(end_date),TO_DATE(TO_CHAR(start_date,'YYYY/MM'),'YYYY/MM'))) + 
              decode(to_char(start_date,'DD'),'01',0,(last_day(start_date)+1-start_date)/365*12-1) + 
              decode(to_char(end_date,'DD'),to_char(last_day(end_date),'DD'),0,TO_NUMBER(TO_CHAR(end_date,'DD'))/365*12-1),
              '360 Days/Year',
              CEIL(months_between(last_day(end_date),TO_DATE(TO_CHAR(start_date,'YYYY/MM'),'YYYY/MM'))) + 
              decode(to_char(start_date,'DD'),'01',0,(last_day(start_date)+1-start_date)/360*12-1) + 
              decode(to_char(end_date,'DD'),to_char(last_day(end_date),'DD'),0,TO_NUMBER(TO_CHAR(end_date,'DD'))/360*12-1),
              'Days/Month',
              CEIL(months_between(last_day(end_date),TO_DATE(TO_CHAR(start_date,'YYYY/MM'),'YYYY/MM'))) + 
              decode(to_char(start_date,'DD'),'01',0,(last_day(start_date)+1-start_date)/TO_NUMBER(TO_CHAR(LAST_DAY(START_DATE),'DD'))-1) + 
              decode(to_char(end_date,'DD'),to_char(last_day(end_date),'DD'),0,
                     TO_NUMBER(TO_CHAR(end_date,'DD'))/TO_NUMBER(TO_CHAR(LAST_DAY(END_DATE),'DD')))-1) duration,
       decode(liability_flag, 'Y', 'Yes', 'No') liability_flag,
       decode(rou_asset_flag, 'Y', 'Yes', 'No') rou_asset_flag,
	   decode(rept_inception_flag, 'Y', 'Yes', 'No') rept_inception_flag,
       schedule_day,
       (SELECT meaning
        FROM fnd_lookups
        WHERE lookup_type = 'PN_PAYMENT_FREQUENCY_TYPE'
        AND lookup_code = frequency_code) payment_frequency,
	    (SELECT meaning
        FROM fnd_lookups
        WHERE lookup_type = 'PN_PAYMENT_TERM_TYPE'
        AND lookup_code = payment_term_type_code) payment_type,
		:rate_value term_rate_value,
		decode(to_char(:initial_rate),null,-99999,:initial_rate) term_initial_rate,
		:accounting_method term_accounting_method
FROM pn_payment_terms_hist
WHERE lease_id = :lease_id
AND PN_ACCNTING_BAL_STREAMS.GET_LEASE_DATA_SOURCE(:as_of_date,:ledger_id) = 'A'
AND (((index_period_id is not null or var_rent_inv_id is not null or period_billrec_id IS NOT NULL or opex_agr_id is not null)and status = 'APPROVED') or (index_period_id is null and var_rent_inv_id is null and period_billrec_id IS NULL and opex_agr_id is null) or 
(opex_agr_id is not null and status is NULL))
AND TRUNC(as_of_date) = TRUNC((SELECT max(as_of_date) FROM pn_leases_hist plhh
                                WHERE plhh.lease_num=:p_lease_num
                                AND TRUNC(plhh.as_of_date) <= TRUNC(:as_of_date)))
AND EXISTS (SELECT 1 FROM pn_leases_hist plh 
            WHERE plh.lease_num=:p_lease_num)
AND NOT EXISTS (SELECT 1 FROM pn_payment_terms_all pt
    WHERE pt.lease_id=:lease_id AND pt.rept_inception_flag = 'Y'
    UNION ALL
    SELECT 1 FROM pn_options_all po
    WHERE po.lease_id=:lease_id AND po.rept_inception_flag='Y')
AND (nvl(pn_transaction_util.get_transition_date(:org_id),TRUNC(:as_of_date)) >= 
    TRUNC(:as_of_date) OR pn_system_pub.get_frozen_flag (:org_id) = 'N')
UNION
SELECT payment_term_id,
       currency_code payment_currency,
	   (SELECT meaning
        FROM fnd_lookups
        WHERE lookup_type = 'PN_PAYMENT_PURPOSE_TYPE'
        AND lookup_code = payment_purpose_code) payment_purpose,
       actual_amount,
       to_char(start_date, 'DD-Mon-YY') start_date,
       to_char(end_date, 'DD-Mon-YY') end_date,
       decode(:payment_term_proration_rule,'365 Days/Year',
              CEIL(months_between(last_day(end_date),TO_DATE(TO_CHAR(start_date,'YYYY/MM'),'YYYY/MM'))) + 
              decode(to_char(start_date,'DD'),'01',0,(last_day(start_date)+1-start_date)/365*12-1) + 
              decode(to_char(end_date,'DD'),to_char(last_day(end_date),'DD'),0,TO_NUMBER(TO_CHAR(end_date,'DD'))/365*12-1),
              '360 Days/Year',
              CEIL(months_between(last_day(end_date),TO_DATE(TO_CHAR(start_date,'YYYY/MM'),'YYYY/MM'))) + 
              decode(to_char(start_date,'DD'),'01',0,(last_day(start_date)+1-start_date)/360*12-1) + 
              decode(to_char(end_date,'DD'),to_char(last_day(end_date),'DD'),0,TO_NUMBER(TO_CHAR(end_date,'DD'))/360*12-1),
              'Days/Month',
              CEIL(months_between(last_day(end_date),TO_DATE(TO_CHAR(start_date,'YYYY/MM'),'YYYY/MM'))) + 
              decode(to_char(start_date,'DD'),'01',0,(last_day(start_date)+1-start_date)/TO_NUMBER(TO_CHAR(LAST_DAY(START_DATE),'DD'))-1) + 
              decode(to_char(end_date,'DD'),to_char(last_day(end_date),'DD'),0,
                     TO_NUMBER(TO_CHAR(end_date,'DD'))/TO_NUMBER(TO_CHAR(LAST_DAY(END_DATE),'DD')))-1) duration,
       decode(liability_flag, 'Y', 'Yes', 'No') liability_flag,
       decode(rou_asset_flag, 'Y', 'Yes', 'No') rou_asset_flag,
	   decode(rept_inception_flag, 'Y', 'Yes', 'No') rept_inception_flag,
       schedule_day,
       (SELECT meaning
        FROM fnd_lookups
        WHERE lookup_type = 'PN_PAYMENT_FREQUENCY_TYPE'
        AND lookup_code = frequency_code) payment_frequency,
	    (SELECT meaning
        FROM fnd_lookups
        WHERE lookup_type = 'PN_PAYMENT_TERM_TYPE'
        AND lookup_code = payment_term_type_code) payment_type,
		:rate_value term_rate_value,
		decode(to_char(:initial_rate),null,-99999,:initial_rate) term_initial_rate,
		:accounting_method term_accounting_method
FROM pn_payment_terms_all
WHERE lease_id = :lease_id
AND PN_ACCNTING_BAL_STREAMS.GET_LEASE_DATA_SOURCE(:as_of_date,:ledger_id) = 'A'
AND (((index_period_id is not null or var_rent_inv_id is not null or period_billrec_id IS NOT NULL or opex_agr_id is not null)and status = 'APPROVED') or (index_period_id is null and var_rent_inv_id is null and period_billrec_id IS NULL and opex_agr_id is null) or 
(opex_agr_id is not null and status is NULL))
AND NOT EXISTS (SELECT 1 FROM pn_leases_hist plh 
            WHERE plh.lease_num=:p_lease_num)
AND NOT EXISTS (SELECT 1 FROM pn_payment_terms_all pt
    WHERE pt.lease_id=:lease_id AND pt.rept_inception_flag = 'Y'
    UNION ALL
    SELECT 1 FROM pn_options_all po
    WHERE po.lease_id=:lease_id AND po.rept_inception_flag='Y')
AND (nvl(pn_transaction_util.get_transition_date(:org_id),TRUNC(:as_of_date)) >= 
    TRUNC(:as_of_date) OR pn_system_pub.get_frozen_flag (:org_id) = 'N')
UNION
SELECT payment_term_id,
       currency_code payment_currency,
	   (SELECT meaning
        FROM fnd_lookups
        WHERE lookup_type = 'PN_PAYMENT_PURPOSE_TYPE'
        AND lookup_code = payment_purpose_code) payment_purpose,
       actual_amount,
       to_char(start_date, 'DD-Mon-YY') start_date,
       to_char(end_date, 'DD-Mon-YY') end_date,
       decode(:payment_term_proration_rule,'365 Days/Year',
              CEIL(months_between(last_day(end_date),TO_DATE(TO_CHAR(start_date,'YYYY/MM'),'YYYY/MM'))) + 
              decode(to_char(start_date,'DD'),'01',0,(last_day(start_date)+1-start_date)/365*12-1) + 
              decode(to_char(end_date,'DD'),to_char(last_day(end_date),'DD'),0,TO_NUMBER(TO_CHAR(end_date,'DD'))/365*12-1),
              '360 Days/Year',
              CEIL(months_between(last_day(end_date),TO_DATE(TO_CHAR(start_date,'YYYY/MM'),'YYYY/MM'))) + 
              decode(to_char(start_date,'DD'),'01',0,(last_day(start_date)+1-start_date)/360*12-1) + 
              decode(to_char(end_date,'DD'),to_char(last_day(end_date),'DD'),0,TO_NUMBER(TO_CHAR(end_date,'DD'))/360*12-1),
              'Days/Month',
              CEIL(months_between(last_day(end_date),TO_DATE(TO_CHAR(start_date,'YYYY/MM'),'YYYY/MM'))) + 
              decode(to_char(start_date,'DD'),'01',0,(last_day(start_date)+1-start_date)/TO_NUMBER(TO_CHAR(LAST_DAY(START_DATE),'DD'))-1) + 
              decode(to_char(end_date,'DD'),to_char(last_day(end_date),'DD'),0,
                     TO_NUMBER(TO_CHAR(end_date,'DD'))/TO_NUMBER(TO_CHAR(LAST_DAY(END_DATE),'DD')))-1) duration,
       decode(liability_flag, 'Y', 'Yes', 'No') liability_flag,
       decode(rou_asset_flag, 'Y', 'Yes', 'No') rou_asset_flag,
	   decode(rept_inception_flag, 'Y', 'Yes', 'No') rept_inception_flag,
       schedule_day,
       (SELECT meaning
        FROM fnd_lookups
        WHERE lookup_type = 'PN_PAYMENT_FREQUENCY_TYPE'
        AND lookup_code = frequency_code) payment_frequency,
	    (SELECT meaning
        FROM fnd_lookups
        WHERE lookup_type = 'PN_PAYMENT_TERM_TYPE'
        AND lookup_code = payment_term_type_code) payment_type,
		:rate_value term_rate_value,
		decode(to_char(:initial_rate),null,-99999,:initial_rate) term_initial_rate,
		:accounting_method term_accounting_method
FROM pn_payment_terms_all pta
WHERE pta.lease_id = :lease_id
AND PN_ACCNTING_BAL_STREAMS.GET_LEASE_DATA_SOURCE(:as_of_date,:ledger_id) = 'A'
AND (((pta.index_period_id IS NOT NULL OR pta.var_rent_inv_id IS NOT NULL OR pta.period_billrec_id IS NOT NULL OR pta.opex_agr_id IS NOT NULL)
       and pta.status = 'APPROVED') OR 
     (pta.index_period_id IS NULL AND pta.var_rent_inv_id IS NULL AND pta.period_billrec_id IS NULL AND pta.opex_agr_id IS NULL) OR 
       (pta.opex_agr_id IS NOT NULL AND pta.status IS NULL))
AND EXISTS (SELECT 1 FROM pn_pmt_item_pv_all pivh 
            WHERE pivh.lease_id=pta.lease_id
            AND pivh.as_of_date = :as_of_date) 
AND EXISTS (SELECT 1 FROM pn_payment_terms_all pt
    WHERE pt.lease_id=:lease_id AND pt.rept_inception_flag = 'Y'
    UNION ALL
    SELECT 1 FROM pn_options_all po
    WHERE po.lease_id=:lease_id AND po.rept_inception_flag='Y')
AND (nvl(pn_transaction_util.get_transition_date(:org_id),TRUNC(:as_of_date)) >= 
    TRUNC(:as_of_date) OR pn_system_pub.get_frozen_flag (:org_id) = 'N')
UNION
SELECT payment_term_id,
	   currency_code payment_currency,
       (SELECT meaning
        FROM fnd_lookups
        WHERE lookup_type = 'PN_PAYMENT_PURPOSE_TYPE'
        AND lookup_code = payment_purpose_code) payment_purpose,
       actual_amount,
       to_char(start_date, 'DD-Mon-YY') start_date,
       to_char(end_date, 'DD-Mon-YY') end_date,
       decode(:payment_term_proration_rule,'365 Days/Year',
              CEIL(months_between(last_day(end_date),TO_DATE(TO_CHAR(start_date,'YYYY/MM'),'YYYY/MM'))) + 
              decode(to_char(start_date,'DD'),'01',0,(last_day(start_date)+1-start_date)/365*12-1) + 
              decode(to_char(end_date,'DD'),to_char(last_day(end_date),'DD'),0,TO_NUMBER(TO_CHAR(end_date,'DD'))/365*12-1),
              '360 Days/Year',
              CEIL(months_between(last_day(end_date),TO_DATE(TO_CHAR(start_date,'YYYY/MM'),'YYYY/MM'))) + 
              decode(to_char(start_date,'DD'),'01',0,(last_day(start_date)+1-start_date)/360*12-1) + 
              decode(to_char(end_date,'DD'),to_char(last_day(end_date),'DD'),0,TO_NUMBER(TO_CHAR(end_date,'DD'))/360*12-1),
              'Days/Month',
              CEIL(months_between(last_day(end_date),TO_DATE(TO_CHAR(start_date,'YYYY/MM'),'YYYY/MM'))) + 
              decode(to_char(start_date,'DD'),'01',0,(last_day(start_date)+1-start_date)/TO_NUMBER(TO_CHAR(LAST_DAY(START_DATE),'DD'))-1) + 
              decode(to_char(end_date,'DD'),to_char(last_day(end_date),'DD'),0,
                     TO_NUMBER(TO_CHAR(end_date,'DD'))/TO_NUMBER(TO_CHAR(LAST_DAY(END_DATE),'DD')))-1) duration,
       decode(liability_flag, 'Y', 'Yes', 'No') liability_flag,
       decode(rou_asset_flag, 'Y', 'Yes', 'No') rou_asset_flag,
	   decode(rept_inception_flag, 'Y', 'Yes', 'No') rept_inception_flag,
       schedule_day,
       (SELECT meaning
        FROM fnd_lookups
        WHERE lookup_type = 'PN_PAYMENT_FREQUENCY_TYPE'
        AND lookup_code = frequency_code) payment_frequency,
	    (SELECT meaning
        FROM fnd_lookups
        WHERE lookup_type = 'PN_PAYMENT_TERM_TYPE'
        AND lookup_code = payment_term_type_code) payment_type,
		:rate_value term_rate_value,
		decode(to_char(:initial_rate),null,-99999,:initial_rate) term_initial_rate,
		:accounting_method term_accounting_method
FROM pn_payment_terms_hist pta
WHERE pta.lease_id = :lease_id
AND PN_ACCNTING_BAL_STREAMS.GET_LEASE_DATA_SOURCE(:as_of_date,:ledger_id) = 'A'
AND (((pta.index_period_id IS NOT NULL OR pta.var_rent_inv_id IS NOT NULL OR pta.period_billrec_id IS NOT NULL OR pta.opex_agr_id IS NOT NULL)
       and pta.status = 'APPROVED') OR 
     (pta.index_period_id IS NULL AND pta.var_rent_inv_id IS NULL AND pta.period_billrec_id IS NULL AND pta.opex_agr_id IS NULL) OR 
       (pta.opex_agr_id IS NOT NULL AND pta.status IS NULL))
AND NOT EXISTS (SELECT 1 FROM pn_pmt_item_pv_all pivh 
            WHERE pivh.lease_id=pta.lease_id
            AND pivh.as_of_date = :as_of_date)
AND TRUNC(as_of_date) = TRUNC((SELECT max(as_of_date) FROM pn_leases_hist plhh
                                WHERE plhh.lease_num=:p_lease_num
                                AND TRUNC(plhh.as_of_date) <= TRUNC(:as_of_date)))
AND EXISTS (SELECT 1 FROM pn_payment_terms_all pt
    WHERE pt.lease_id=:lease_id AND pt.rept_inception_flag = 'Y'
    UNION ALL
    SELECT 1 FROM pn_options_all po
    WHERE po.lease_id=:lease_id AND po.rept_inception_flag='Y')
AND (nvl(pn_transaction_util.get_transition_date(:org_id),TRUNC(:as_of_date)) >= 
    TRUNC(:as_of_date) OR pn_system_pub.get_frozen_flag (:org_id) = 'N')
UNION
SELECT pta.payment_term_id,
       currency_code payment_currency,
	   (SELECT meaning
        FROM fnd_lookups
        WHERE lookup_type = 'PN_PAYMENT_PURPOSE_TYPE'
        AND lookup_code = pta.payment_purpose_code) payment_purpose,
       pta.actual_amount,
       to_char(pta.start_date, 'DD-Mon-YY') start_date,
       to_char(nvl(plc.payment_end_date,pta.end_date), 'DD-Mon-YY') end_date,
       decode(:payment_term_proration_rule,'365 Days/Year',
              CEIL(months_between(last_day(end_date),TO_DATE(TO_CHAR(start_date,'YYYY/MM'),'YYYY/MM'))) + 
              decode(to_char(start_date,'DD'),'01',0,(last_day(start_date)+1-start_date)/365*12-1) + 
              decode(to_char(end_date,'DD'),to_char(last_day(end_date),'DD'),0,TO_NUMBER(TO_CHAR(end_date,'DD'))/365*12-1),
              '360 Days/Year',
              CEIL(months_between(last_day(end_date),TO_DATE(TO_CHAR(start_date,'YYYY/MM'),'YYYY/MM'))) + 
              decode(to_char(start_date,'DD'),'01',0,(last_day(start_date)+1-start_date)/360*12-1) + 
              decode(to_char(end_date,'DD'),to_char(last_day(end_date),'DD'),0,TO_NUMBER(TO_CHAR(end_date,'DD'))/360*12-1),
              'Days/Month',
              CEIL(months_between(last_day(end_date),TO_DATE(TO_CHAR(start_date,'YYYY/MM'),'YYYY/MM'))) + 
              decode(to_char(start_date,'DD'),'01',0,(last_day(start_date)+1-start_date)/TO_NUMBER(TO_CHAR(LAST_DAY(START_DATE),'DD'))-1) + 
              decode(to_char(end_date,'DD'),to_char(last_day(end_date),'DD'),0,
                     TO_NUMBER(TO_CHAR(end_date,'DD'))/TO_NUMBER(TO_CHAR(LAST_DAY(END_DATE),'DD')))-1) duration,
       decode(nvl(plc.liability_flag,pta.liability_flag), 'Y', 'Yes', 'No') liability_flag,
       decode(nvl(plc.rou_asset_flag,pta.rou_asset_flag), 'Y', 'Yes', 'No') rou_asset_flag,
	   decode(nvl(plc.rept_inception_flag,pta.rept_inception_flag), 'Y', 'Yes', 'No') rept_inception_flag,
       pta.schedule_day,
       (SELECT meaning
        FROM fnd_lookups
        WHERE lookup_type = 'PN_PAYMENT_FREQUENCY_TYPE'
        AND lookup_code = pta.frequency_code) payment_frequency,
	    (SELECT meaning
        FROM fnd_lookups
        WHERE lookup_type = 'PN_PAYMENT_TERM_TYPE'
        AND lookup_code = pta.payment_term_type_code) payment_type,
		:rate_value term_rate_value,
		decode(to_char(:initial_rate),null,-99999,:initial_rate) term_initial_rate,
		:accounting_method term_accounting_method
 FROM pn_payment_terms_all pta,PN_LEASE_REPORT_V plc
WHERE pta.lease_id = :lease_id
  and pta.payment_term_id = plc.payment_term_id(+)
  and nvl(pn_transaction_util.get_transition_date(:org_id),TRUNC(:as_of_date))<
      TRUNC(:as_of_date)
  AND pn_system_pub.get_frozen_flag (:org_id) = 'Y'
  and TRUNC(:as_of_date) >= nvl(TRUNC(plc.as_of_date),TRUNC(:as_of_date))	  
ORDER BY liability_flag DESC , rou_asset_flag DESC
Parameter Name SQL text Validation
Lease Number
 
LOV Oracle
To Date
 
Date
As of Date
 
LOV Oracle