OKL Title Return from Third Party Title Custodian

➜ Back to Library
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source:
Short Name: OKLTHIRDCUST
DB package:
Run OKL Title Return from Third Party Title Custodian and other Oracle EBS reports with Blitz Report™ on our demo environment
        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 CSD Depot Repair Traveler OKL Car Papers OKL Professional Tax OKL Asset Variable Rate Schedule OKL Bill Of Sale OKL Audit Report Data OKL Credit Reference Letter WSH Mailing Label
Blitz Report™

Blitz Report™ provides multiple benefits: