OKL Tax Schedule

➜ Back to Library
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source:
Short Name: OKLTAXSCHED
DB package:

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 CUST.PARTY_NAME,
        CUST.ADDRESS1 PARTY_ADDRESS1,
        CUST.ADDRESS2 PARTY_ADDRESS2,
        CUST.ADDRESS3 PARTY_ADDRESS3,
        CUST.ADDRESS4 PARTY_ADDRESS4,
        CUST.CITY PARTY_CITY,
        CUST.POSTAL_CODE PARTY_POSTAL_CODE,
        CUST.STATE PARTY_STATE,
        CUST.PROVINCE PARTY_PROVINCE,
        CUST.COUNTY PARTY_COUNTY,
        CUST.EMAIL_ADDRESS PARTY_EMAIL_ADDRESS,
        CNT.PARTY_NAME CONTACT_NAME,
        CNT.PERSON_ACADEMIC_TITLE CONTACT_TITLE,
        CNT.PRIMARY_PHONE_COUNTRY_CODE||' '||CNT.PRIMARY_PHONE_AREA_CODE||' '||
        CNT.PRIMARY_PHONE_NUMBER||' '||CNT.PRIMARY_PHONE_EXTENSION CONTACT_PRIMARY_PHONE
 FROM HZ_PARTIES CUST,
      HZ_CUST_ACCOUNTS CSTACC,
      HZ_PARTY_RELATIONSHIP_V REL,
      HZ_PARTIES CNT
WHERE CSTACC.CUST_ACCOUNT_ID = :CUST_ACCOUNT_ID
AND CSTACC.PARTY_ID = CUST.PARTY_ID
AND CUST.PARTY_ID = REL.OBJECT_ID(+)
AND REL.RELATIONSHIP_TYPE_CODE = 'CONTACT_OF'
AND CNT.PARTY_ID(+) = REL.SUBJECT_ID
AND ROWNUM = 1
Download
 
Related Blitz Reports
OKL Transfer and Assumption OKL Car Papers OKL Title Return from Third Party Title Custodian OKL Professional Tax OKL Asset Variable Rate Schedule OKL Bill Of Sale OKL Audit Report Data AR Customer Upload OKL Credit Reference Letter WSH Mailing Label
Blitz Report™

Blitz Report™ provides multiple benefits: