Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_AM_CONTRACT_PARTIES_UV |
SELECT K.ROW_ID
, K.ID
, K.OBJECT_VERSION_NUMBER
, K.SFWT_FLAG
, K.CHR_ID_RESPONSE
, K.CHR_ID_AWARD
, K.CHR_ID_RENEWED
, K.INV_ORGANIZATION_ID
, K.STS_CODE
, STS.MEANING STS_MEANING
, STS.STE_CODE STE_CODE
, K.QCL_ID
, K.SCS_CODE
, SCS.MEANING SCS_MEANING
, O.RLE_CODE RLE_CODE
, K.CONTRACT_NUMBER
, K.CURRENCY_CODE
, K.CONTRACT_NUMBER_MODIFIER
, K.ARCHIVED_YN
, K.DELETED_YN
, K.CUST_PO_NUMBER_REQ_YN
, K.PRE_PAY_REQ_YN
, K.CUST_PO_NUMBER
, K.SHORT_DESCRIPTION
, K.COMMENTS
, K.DESCRIPTION
, K.DPAS_RATING
, K.COGNOMEN
, K.TEMPLATE_YN
, K.TEMPLATE_USED
, K.DATE_APPROVED
, K.DATETIME_CANCELLED
, K.AUTO_RENEW_DAYS
, K.DATE_ISSUED
, K.DATETIME_RESPONDED
, K.NON_RESPONSE_REASON
, K.NON_RESPONSE_EXPLAIN
, K.RFP_TYPE
, K.CHR_TYPE
, K.KEEP_ON_MAIL_LIST
, K.SET_ASIDE_REASON
, K.SET_ASIDE_PERCENT
, K.RESPONSE_COPIES_REQ
, K.DATE_CLOSE_PROJECTED
, K.DATETIME_PROPOSED
, K.DATE_SIGNED
, K.DATE_TERMINATED
, K.DATE_RENEWED
, K.TRN_CODE
, K.START_DATE
, K.END_DATE
, K.AUTHORING_ORG_ID
, K.BUY_OR_SELL
, K.ISSUE_OR_RECEIVE
, K.ESTIMATED_AMOUNT
, K.CHR_ID_RENEWED_TO
, K.ESTIMATED_AMOUNT_RENEWED
, K.CURRENCY_CODE_RENEWED
, K.USER_ACCESS_LEVEL
, K.UPG_ORIG_SYSTEM_REF
, K.UPG_ORIG_SYSTEM_REF_ID
, K.APPLICATION_ID
, K.RESOLVED_UNTIL
, K.ATTRIBUTE_CATEGORY
, K.ATTRIBUTE1
, K.ATTRIBUTE2
, K.ATTRIBUTE3
, K.ATTRIBUTE4
, K.ATTRIBUTE5
, K.ATTRIBUTE6
, K.ATTRIBUTE7
, K.ATTRIBUTE8
, K.ATTRIBUTE9
, K.ATTRIBUTE10
, K.ATTRIBUTE11
, K.ATTRIBUTE12
, K.ATTRIBUTE13
, K.ATTRIBUTE14
, K.ATTRIBUTE15
, K.CREATED_BY
, K.CREATION_DATE
, K.LAST_UPDATED_BY
, K.LAST_UPDATE_DATE
, K.LAST_UPDATE_LOGIN
, K.ORIG_SYSTEM_SOURCE_CODE
, K.ORIG_SYSTEM_ID1
, K.ORIG_SYSTEM_REFERENCE1
, K.KHR_ROW_ID
, K.KHR_OBJECT_VERSION_NUMBER
, K.ISG_ID
, K.KHR_ID
, K.PDT_ID
, K.AMD_CODE
, K.DATE_FIRST_ACTIVITY
, K.GENERATE_ACCRUAL_YN
, K.GENERATE_ACCRUAL_OVERRIDE_YN
, K.DATE_REFINANCED
, K.CREDIT_ACT_YN
, K.TERM_DURATION
, K.CONVERTED_ACCOUNT_YN
, K.DATE_CONVERSION_EFFECTIVE
, K.SYNDICATABLE_YN
, K.SALESTYPE_YN
, K.DATE_DEAL_TRANSFERRED
, K.DATETIME_PROPOSAL_EFFECTIVE
, K.DATETIME_PROPOSAL_INEFFECTIVE
, K.DATE_PROPOSAL_ACCEPTED
, K.KHR_ATTRIBUTE_CATEGORY
, K.KHR_ATTRIBUTE1
, K.KHR_ATTRIBUTE2
, K.KHR_ATTRIBUTE3
, K.KHR_ATTRIBUTE4
, K.KHR_ATTRIBUTE5
, K.KHR_ATTRIBUTE6
, K.KHR_ATTRIBUTE7
, K.KHR_ATTRIBUTE8
, K.KHR_ATTRIBUTE9
, K.KHR_ATTRIBUTE10
, K.KHR_ATTRIBUTE11
, K.KHR_ATTRIBUTE12
, K.KHR_ATTRIBUTE13
, K.KHR_ATTRIBUTE14
, K.KHR_ATTRIBUTE15
, K.KHR_CREATED_BY
, K.KHR_CREATON_DATE
, K.KHR_LAST_UPDATED_BY
, K.KHR_LAST_UPDATE_DATE
, K.KHR_LAST_UPDATE_LOGIN
, K.PRE_TAX_YIELD
, K.AFTER_TAX_YIELD
, K.IMPLICIT_INTEREST_RATE
, K.IMPLICIT_NON_IDC_INTEREST_RATE
, K.TARGET_PRE_TAX_YIELD
, K.TARGET_AFTER_TAX_YIELD
, K.TARGET_IMPLICIT_INTEREST_RATE
, K.TARGET_IMPLICIT_NONIDC_INTRATE
, K.DATE_LAST_INTERIM_INTEREST_CAL
, K.DEAL_TYPE
, K.PRE_TAX_IRR
, K.AFTER_TAX_IRR
, K.EXPECTED_DELIVERY_DATE
, K.ACCEPTED_DATE
, P.PARTY_NAME
FROM HZ_PARTIES P
, OKC_K_PARTY_ROLES_V O
, OKL_K_HEADERS_FULL_V K
, OKC_STATUSES_V STS
, OKC_SUBCLASSES_V SCS
WHERE P.PARTY_ID = O.OBJECT1_ID1
AND O.CHR_ID = K.ID
AND O.JTOT_OBJECT1_CODE = 'OKX_PARTY'
AND O.RLE_CODE = 'LESSEE'
AND K.STS_CODE = STS.CODE
AND K.SCS_CODE = SCS.CODE
AND K.SCS_CODE IN ('LEASE'
, 'LOAN')
AND K.STS_CODE IN ('BOOKED'
, 'EVERGREEN'
, 'BANKRUPTCY_HOLD'
, 'LITIGATION_HOLD'
, 'TERMINATION_HOLD')