[Home] [Help]
View: OKL_BPD_ALL_CONTRACT_CUST_UV
Product: | OKL - Lease and Finance Management |
Description: | View for contracts LOV in the transaction summary screen. |
Implementation/DBA Data: |
APPS.OKL_BPD_ALL_CONTRACT_CUST_UV
|
View Text
SELECT ACCT.ID1 CUSTOMER_ACCOUNT_ID
, PARTY.NAME CUSTOMER_NAME
, PARTY.PARTY_NUMBER CUSTOMER_NUMBER
, KHR.ID CONTRACT_ID
, KHR.CONTRACT_NUMBER CONTRACT_NUMBER
, SITE.CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID
, SITE.LOCATION_ID LOCATION_ID
, RLE.OBJECT1_ID1 PARTY_ID
, SITE.NAME BILL_TO_SITE_NAME
, KHR.CURRENCY_CODE
FROM OKC_K_HEADERS_B KHR
, OKX_CUSTOMER_ACCOUNTS_V ACCT
, OKX_PARTIES_V PARTY
, OKX_CUST_SITE_USES_V SITE
, OKC_K_PARTY_ROLES_B RLE
WHERE KHR.BILL_TO_SITE_USE_ID = TO_CHAR(SITE.ID1)
AND KHR.CUST_ACCT_ID = TO_CHAR(ACCT.ID1)
AND KHR.ID = RLE.DNZ_CHR_ID
AND RLE.RLE_CODE = 'LESSEE'
AND RLE.OBJECT1_ID1 = PARTY.ID1
Columns
Name |
CUSTOMER_ACCOUNT_ID |
CUSTOMER_NAME |
CUSTOMER_NUMBER |
CONTRACT_ID |
CONTRACT_NUMBER |
CUST_ACCT_SITE_ID |
LOCATION_ID |
PARTY_ID |
BILL_TO_SITE_NAME |
CURRENCY_CODE |