ECC Service Contracts, Service Contracts Follow-Up Details

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: oks-followup
Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info
Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Run ECC Service Contracts, Service Contracts Follow-Up Details and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
select * from (
  SELECT    HDR.ID ecc_spec_id,
  HDR.ID contract_id,
  KHDR.FOLLOW_UP_DATE FOLLOW_UP_DATE
  FROM OKS_K_HEADERS_B khdr,OKC_K_HEADERS_ALL_B hdr
 WHERE hdr.end_date >=  NVL(fnd_date.canonical_to_date(fnd_profile.value('OKS_ECC_CONTARCT_FROM_DATE')),sysdate)
 and    hdr.template_yn = 'N'
 AND     hdr.scs_code IN ('SERVICE', 'WARRANTY', 'SUBSCRIPTION')
 AND     hdr.id = khdr.chr_id
 AND  KHDR.FOLLOW_UP_DATE IS NOT NULL
 union
select ID ecc_spec_id,
  CHR_ID contract_id,
  FOLLOW_UP_DUE_DATE FOLLOW_UP_DATE
FROM  OKS_FOLLOW_UP_ACTIONS
WHERE FOLLOW_UP_COMPLETION_DATE IS NULL
AND   FOLLOW_UP_DUE_DATE >= NVL(fnd_date.canonical_to_date(fnd_profile.value('OKS_ECC_CONTARCT_FROM_DATE')),sysdate))
) x
where
2=2
Download
 
Related Blitz Reports
OKS Service Contracts Billing History ECC Service Contracts, Service Contract Counter Details OKS Service Contracts Billing Schedule OKC Contract Lines Summary OKS Service Contracts Bookings OKS Service Contract Forecast Management ECC Service Contracts, Service Contract Details OKS Service Contracts by Status OKS Service Contracts Detail
Blitz Report™

Blitz Report™ provides multiple benefits: