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 ...
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
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 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 |