OKL Generate Quote Payment Schedule

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Generates Quote Payment Schedule
Application: Lease and Finance Management
Source: Generate Quote Payment Schedule
Short Name: OKLGENPAYSCHE
DB package:
Run OKL Generate Quote Payment Schedule and other Oracle EBS reports with Blitz Report™ on our demo environment
      SELECT LEASEOPP.REFERENCE_NUMBER "LEASEOPP_NUMBER",
             LQ.REFERENCE_NUMBER "QUOTE_NUMBER",
             HZP.PARTY_NAME PROSPECT_NAME,
             CHR.CONTRACT_NUMBER VENDOR_PROGRAM,
             LEASEOPP.CURRENCY_CODE,
             TO_CHAR(LEASEOPP.EXPECTED_START_DATE, 'DD-MON-YYYY') "EXPECTED_START_DATE",
             LQ.TERM,
             FND_VAL.MEANING "PRICING_METHOD",
             LKP_QT_STAT.MEANING "QUOTE_STATUS"
        FROM OKL_LEASE_OPPORTUNITIES_B LEASEOPP,
             HZ_PARTIES HZP,
             OKC_K_HEADERS_B CHR,
             OKL_LEASE_QUOTES_B LQ,
             FND_LOOKUP_VALUES FND_VAL,
             FND_LOOKUP_VALUES LKP_QT_STAT
       WHERE LQ.ID               = :P_LQ_ID
         AND LQ.PARENT_OBJECT_ID = LEASEOPP.ID
         AND LEASEOPP.PROSPECT_ID = HZP.PARTY_ID
         AND LEASEOPP.PROGRAM_AGREEMENT_ID = CHR.ID (+)
         AND FND_VAL.LOOKUP_CODE = LQ.PRICING_METHOD
         AND FND_VAL.LOOKUP_TYPE = 'OKL_QUOTE_PRICING_METHOD'
         AND FND_VAL.LANGUAGE = USERENV('LANG')
         AND LKP_QT_STAT.LOOKUP_CODE = LQ.STATUS
         AND LKP_QT_STAT.LOOKUP_TYPE = 'OKL_LEASE_QUOTE_STATUS'
         AND LKP_QT_STAT.LANGUAGE = USERENV('LANG')
     UNION
      SELECT '' "LEASEOPP_NUMBER", -- for Counter Offer
             LQ.REFERENCE_NUMBER "QUOTE_NUMBER",
             HZP.PARTY_NAME PROSPECT_NAME,
             CHR.CONTRACT_NUMBER VENDOR_PROGRAM,
             LEASEAPP.CURRENCY_CODE,
             TO_CHAR(LEASEAPP.VALID_FROM, 'DD-MON-YYYY') "EXPECTED_START_DATE",
             LQ.TERM,
             FND_VAL.MEANING "PRICING_METHOD",
             LKP_QT_STAT.MEANING "QUOTE_STATUS"
        FROM OKL_LEASE_APPLICATIONS_B LEASEAPP,
             HZ_PARTIES HZP,
             OKC_K_HEADERS_B CHR,
             OKL_LEASE_QUOTES_B LQ,
             FND_LOOKUP_VALUES FND_VAL,
             FND_LOOKUP_VALUES LKP_QT_STAT
       WHERE LQ.ID               = :P_LQ_ID
         AND LQ.PARENT_OBJECT_ID = LEASEAPP.ID
         AND LEASEAPP.PROSPECT_ID = HZP.PARTY_ID
         AND LEASEAPP.PROGRAM_AGREEMENT_ID = CHR.ID (+)
         AND FND_VAL.LOOKUP_CODE = LQ.PRICING_METHOD
         AND FND_VAL.LOOKUP_TYPE = 'OKL_QUOTE_PRICING_METHOD'
         AND FND_VAL.LANGUAGE = USERENV('LANG')
         AND LKP_QT_STAT.LOOKUP_CODE = LQ.STATUS
         AND LKP_QT_STAT.LOOKUP_TYPE = 'OKL_LEASE_QUOTE_STATUS'
         AND LKP_QT_STAT.LANGUAGE = USERENV('LANG')
Parameter Name SQL text Validation
Operating Unit 
 
 LOV
p_qte_type 
 
 LOV Oracle
Lease Quote Number 
 
 LOV Oracle
Lease Application Number 
 
 LOV Oracle
Download
Related Blitz Reports
OKL Loans Amortization Schedule OKL Lease Vendor Party Mismatch OKL Termination Quotes ECC Lease Contracts, Contracts OKL Lease Property Tax OKL Receipt Inquiry Avalara VAT listing Avalara VAT LinesData ECC Lease Contracts, Revision History
Blitz Report™

Blitz Report™ provides multiple benefits: