OKS Products Not Renewed

Description
Categories: BI Publisher
Columns: Salesrep Id, Customer Name, Contract Number, Contract Number Modifier, Contract Status Type, Contract Status Code, Line Amount, Customer Product Id, Serial Number, Product Start Date ...
Application: Service Contracts
Source: OKS Products Not Renewed Report (XML)
Short Name: OKSNREPD_XML
DB package: OKS_OKSNREPD_XMLP_PKG
select exp.salesrep_id,
           exp.customer_name,
           exp.contract_number,
           exp.contract_number_modifier,
           exp.contract_status_type,
           exp.contract_status_code,
           exp.line_amount,
           exp.customer_product_id,
           exp.serial_number,
           exp.product_start_date,
           exp.product_end_date,
          exp.org_id,
          exp.organization_id,
	OKS_OKSNREPD_XMLP_PKG.cf_salesrep_nameformula(exp.salesrep_id, exp.org_id) CF_salesrep_name,
	OKS_OKSNREPD_XMLP_PKG.cf_2formula(exp.customer_product_id, exp.organization_id) CF_part_number,
	OKS_OKSNREPD_XMLP_PKG.cf_1formula(exp.customer_product_id) CF_csi_number,
	OKS_OKSNREPD_XMLP_PKG.CP_description_p CP_description
from   oks_expired_contracts_v exp
where
   not exists ( select '*' from oks_approved_contracts_v app where app.customer_product_id = exp.customer_product_id
                            and exp.product_end_date < app.start_date )
&p_from_end_date_where
&p_to_end_date_where
&p_org_id_where
&p_salesrep_where
&p_customer_name_where
&p_contract_group_where
Parameter NameSQL textValidation
Contract Group
 
LOV Oracle
Operating Unit
 
LOV Oracle
Sales Rep
 
LOV Oracle
Customer
 
LOV Oracle
From End Date
 
Date
To End Date
 
Date