ECC Service Contracts, Service Contract Service Request Details
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: oks-contract-sr
Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info
Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Dataset Key: oks-contract-sr
Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info
Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Run
ECC Service Contracts, Service Contract Service Request Details and other Oracle EBS reports with Blitz Report™ on our demo environment
select x.* from ( select * from (SELECT /*+ leading(v.oks_hdr) use_nl(v.oks_hdr v.inc.b v.hzp) use_nl(v.inc.tl) */ ecc_spec_id, incident_id, language_code, sr_number, operating_unit, incident_status_id, sr_status, incident_type_id, sr_type, incident_urgency_id, urgency, incident_severity_id, sr_severity, customer_id, account_id, customer_site_id, contract_id, contract_number, contract_type, contract_service_id, coverage_type, incident_date, inc_date_year, inc_date_year_month, inc_date_ym_week, expected_resolution_date, actual_resolution_date, close_date, close_flag, problem_code, problem_summary, resolution_code, resolution_summary, incident_owner_id, owner, inv_organization_id, escalated, inventory_item_id, inventory_item_name, fa_corp_category, serial_num, item_instance, system_id, system_number, coverage_name, service_name, customer_party_name, customer_country, customer_city, customer_state, customer_party_id, customer_party_number, contract_operating_unit_id, sr_status_code, escalated_yn_code, item_category, sr_last_update_date, contract_status, contract_start_date, contract_end_date, contract_termination_date, contract_booked_amount, sr_operating_unit, sr_org_id, contract_currency, contract_status_group FROM oks_ecc_srs_v v WHERE ( contract_end_date >= NVL(fnd_date.canonical_to_date(fnd_profile.value('OKS_ECC_CONTARCT_FROM_DATE')),sysdate) and language_code in ('US') )) pivot ( max(sr_status) as sr_status , max(sr_type) as sr_type , max(urgency) as urgency, max(sr_severity) as sr_severity, max(sr_operating_unit) as sr_operating_unit, max(problem_code) as problem_code, max(resolution_code) as resolution_code for language_code in ('US' "US")) ) x where 2=2 |
Blitz Report™