eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_BPD_CUST_LIST_UV

Source

View Text - Preformatted


SELECT distinct CA.ACCOUNT_NUMBER CUSTOMER_NUMBER, SUBSTRB (PY.PARTY_NAME, 1, 50) CUSTOMER_NAME, CSU.CUST_ACCT_SITE_ID BILL_TO_SITE_USE_ID, KHR.CUST_ACCT_ID CUSTOMER_ACCT_ID FROM OKX_CUST_SITE_USES_V CSU,OKC_K_HEADERS_B KHR,HZ_CUST_ACCOUNTS CA,HZ_PARTIES PY WHERE KHR.CUST_ACCT_ID = CA.CUST_ACCOUNT_ID AND PY.PARTY_ID = CA.PARTY_ID AND CSU.ID1 = KHR.BILL_TO_SITE_USE_ID

View Text - HTML Formatted

SELECT DISTINCT CA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, SUBSTRB (PY.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, CSU.CUST_ACCT_SITE_ID BILL_TO_SITE_USE_ID
, KHR.CUST_ACCT_ID CUSTOMER_ACCT_ID
FROM OKX_CUST_SITE_USES_V CSU
, OKC_K_HEADERS_B KHR
, HZ_CUST_ACCOUNTS CA
, HZ_PARTIES PY
WHERE KHR.CUST_ACCT_ID = CA.CUST_ACCOUNT_ID
AND PY.PARTY_ID = CA.PARTY_ID
AND CSU.ID1 = KHR.BILL_TO_SITE_USE_ID