[Home] [Help]
View: OKL_CUSTOMER_ACCT_UV
Product: | OKL - Leasing and Finance Management |
Description: | User interface view for customer account lov on creditline contract page |
Implementation/DBA Data: |
APPS.OKL_CUSTOMER_ACCT_UV
|
View Text
SELECT CUSTOMER.ID1 CUSTOMER_ID1
, CUSTOMER.ID2 CUSTOMER_ID2
, CUSTOMER.DESCRIPTION CUSTOMER_NUMBER
, CUSTOMER.NAME CUSTOMER_NAME
, RS.JTOT_OBJECT_CODE CUSTOMER_JTOT_OBJECT_CODE
, ACCT.ID1 CUST_ACCT_ID
, ACCT.DESCRIPTION CUST_ACCT_NUMBER
, ACCT.NAME CUST_ACCT_NAME
, NVL(SITE.DESCRIPTION
, ' ') LEGAL_ADDRESS
, ACCT.PARTY_ID
FROM OKX_PARTIES_V CUSTOMER
, OKX_CUSTOMER_ACCOUNTS_V ACCT
, OKX_CUST_SITE_USES_V SITE
, OKC_ROLE_SOURCES RS
WHERE CUSTOMER.ID1 = ACCT.PARTY_ID
AND RS.RLE_CODE = 'LESSEE'
AND RS.BUY_OR_SELL = 'S'
AND TRUNC(RS.START_DATE) <= TRUNC(SYSDATE)
AND TRUNC(NVL(RS.END_DATE
, SYSDATE)) >= TRUNC(SYSDATE)
AND SITE.SITE_USE_CODE(+) = 'LEGAL'
AND SITE.CUST_ACCOUNT_ID(+) = ACCT.ID1
Columns
Name |
CUSTOMER_ID1 |
CUSTOMER_ID2 |
CUSTOMER_NUMBER |
CUSTOMER_NAME |
CUSTOMER_JTOT_OBJECT_CODE |
CUST_ACCT_ID |
CUST_ACCT_NUMBER |
CUST_ACCT_NAME |
LEGAL_ADDRESS |
PARTY_ID |