OKS Products Not Renewed
Description
Categories: BI Publisher
Application: Service Contracts
Source: OKS Products Not Renewed Report (XML)
Short Name: OKSNREPD_XML
DB package: OKS_OKSNREPD_XMLP_PKG
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 |