OKL Generate Quote Payment Schedule Copy link

      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')