ECC Service Contracts, Service Contract Sales Credit Details

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: oks-contract-salescredit
Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info
Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
x.*
from
(
select * from (SELECT    ecc_spec_id,
  language_code,
  linesalescreditid,
  linesalesperson,
  linesalesgroup,
  linesalescredittype,
  linequotapercent,
  linenonquota,
  contract_id,
  contract_line_id,
  contract_number,
  contract_modifier,
  line_number  ,
  CONTRACT_STATUS_GROUP,
  CONTRACT_END_DATE,
  CONTRACT_TERMINATION_DATE
 FROM oks_k_sales_credit_ecc_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(lineSALESGROUP)	as	lineSALESGROUP
  for language_code in ('US' "US"))
) x
where
2=2
Download
 
Related Blitz Reports
ECC Service Contracts, Service Contract Details ECC Service Contracts, Service Contract Customer Details Avalara VAT listing Avalara VAT LinesData RK: AR Transactions and Lines ECC Service Contracts, Service Contract Counter Details OKS Service Contracts Billing History ECC Lease Contracts, Contracts ECC Service Contracts, Service Contract Contact Details
Blitz Report™

Blitz Report™ provides multiple benefits: