OKS Products Not Renewed

➜ Back to Library
Description
Categories: BI Publisher
Application: Service Contracts
Source: OKS Products Not Renewed Report (XML)
Short Name: OKSNREPD_XML
DB package: OKS_OKSNREPD_XMLP_PKG
Run OKS Products Not Renewed and other Oracle EBS reports with Blitz Report™ on our demo environment
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 Name SQL text Validation
Contract Group 
 
 LOV Oracle
Operating Unit 
 
 LOV Oracle
Sales Rep 
 
 LOV Oracle
Customer 
 
 LOV Oracle
From End Date 
 
 Date
To End Date 
 
 Date
Download
Related Blitz Reports
OKS Service Contracts Billing History AR Transactions and Lines Avalara VAT listing RK: AR Transactions and Lines XX AR Transactions and Lines OKS Service Contracts Forecast Summary OKS Service Contracts Bookings ECC Service Contracts, Service Contract Details INV Item Statuses
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™