VIEW: APPS.OKL_AM_CONTRACT_PARTIES_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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