VIEW: APPS.OKL_CUSTOMER_ACCT_UV

Source

View Text - Preformatted

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 ,acct.status cust_acct_status 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

View Text - HTML Formatted

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
, ACCT.STATUS CUST_ACCT_STATUS
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