View: OKL_SLA_TRX_INFO_V

Product:	OKL - Lease and Finance Management
Description:	Transaction object for user transaction identifiers.
Implementation/DBA Data:	APPS.OKL_SLA_TRX_INFO_V

View Text

SELECT TCN.ID ID
, DECODE( CHR.SCS_CODE
, 'LEASE'
, CHR.CONTRACT_NUMBER
, NULL) CONTRACT_NUMBER
, PDT.NAME PRODUCT_NAME
, CUST_PARTY.PARTY_NAME CUSTOMER_NAME
, CUST_ACCOUNTS.ACCOUNT_NUMBER CUSTOMER_ACCOUNT
, TCN.CURRENCY_CODE CURRENCY_CODE
, TCN.TRX_NUMBER TRANSACTION_NUMBER
, TCN.DATE_TRANSACTION_OCCURRED TRANSACTION_DATE
, TCN.CANCELED_DATE CANCELLATION_DATE
, SECLKUP.MEANING INVESTOR_AGREEMENT_TYPE
, TERM.QUOTE_NUMBER TERMINATION_QUOTE_NUMBER
, TQLKUP.MEANING TERMINATION_QUOTE_TYPE
, DECODE( CHR.SCS_CODE
, 'INVESTOR'
, CHR.CONTRACT_NUMBER
, NULL)
FROM OKL_TRX_CONTRACTS_ALL TCN
, OKC_K_HEADERS_ALL_B CHR
, OKL_K_HEADERS KHR
, OKL_PRODUCTS PDT
, OKC_K_PARTY_ROLES_B CUST_PARTY_ROLES
, HZ_PARTIES CUST_PARTY
, HZ_CUST_ACCOUNTS CUST_ACCOUNTS
, OKL_TRX_QUOTES_ALL_B TERM
, FND_LOOKUPS SECLKUP
, FND_LOOKUPS TQLKUP
WHERE TCN.KHR_ID = CHR.ID
AND CHR.ID = KHR.ID
AND KHR.PDT_ID = PDT.ID
AND CUST_PARTY.PARTY_TYPE IN ( 'PERSON'
, 'ORGANIZATION')
AND '#' = CUST_PARTY_ROLES.OBJECT1_ID2
AND CUST_PARTY_ROLES.JTOT_OBJECT1_CODE = 'OKX_PARTY'
AND CUST_PARTY.PARTY_ID = CUST_PARTY_ROLES.OBJECT1_ID1
AND CUST_PARTY_ROLES.RLE_CODE = 'LESSEE'
AND CUST_PARTY_ROLES.CHR_ID = CHR.ID
AND CUST_PARTY_ROLES.DNZ_CHR_ID = CHR.ID
AND CUST_ACCOUNTS.CUST_ACCOUNT_ID = CHR.CUST_ACCT_ID
AND SECLKUP.LOOKUP_TYPE (+) = 'OKL_SECURITIZATION_TYPE'
AND SECLKUP.LOOKUP_CODE (+) = DECODE( KHR.SECURITIZATION_TYPE
, 'SECURITIZATION'
, 'SECURITIZATION'
, 'SALE'
, 'SECURITIZATION'
, 'SYNDICATION'
, 'SYNDICATION'
, 'LOAN'
, 'SYNDICATION'
, NULL)
AND TERM.ID (+) = TCN.QTE_ID
AND TQLKUP.LOOKUP_TYPE (+) = 'OKL_QUOTE_TYPE'
AND TQLKUP.LOOKUP_CODE (+) = TERM.QTP_CODE

Columns