OKL Notify Repossession

➜ Back to Library
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source:
Short Name: OKLNTFYREPOS
DB package:
Run OKL Notify Repossession 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 Title Return from Third Party Title Custodian 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: