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.

[Home] [Help]

View: AR_CUSTOMER_SEARCH_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_CUSTOMER_SEARCH_V

View Text

SELECT CUST.CUST_ACCOUNT_ID CUSTOMER_ID
, 'ADDR' DETAILS_LEVEL
, CUST.ACCOUNT_NUMBER CUSTOMER_NUMBER
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, ADDR.ADDRESS_ID ADDRESS_ID
, ADDR.CONCATENATED_ADDRESS
, TO_CHAR(NULL) CONTACT_NAME
, TO_CHAR(NULL) CONTACT_PHONE
, -1 BILL_TO_SITE_USE_ID
, TO_CHAR(NULL) SITE_USES
FROM HZ_CUST_ACCOUNTS CUST
, HZ_PARTIES PARTY
, AR_ADDRESSES_V ADDR
WHERE ADDR.CUSTOMER_ID = CUST.CUST_ACCOUNT_ID
AND CUST.PARTY_ID = PARTY.PARTY_ID UNION ALL SELECT CUST.CUST_ACCOUNT_ID CUSTOMER_ID
, 'CUST' DETAILS_LEVEL
, CUST.ACCOUNT_NUMBER CUSTOMER_NUMBER
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, -1 ADDRESS_ID
, 'ALL_LOCATIONS' CONCATENATED_ADDRESS
, TO_CHAR(NULL) CONTACT_NAME
, TO_CHAR(NULL) CONTACT_PHONE
, -1 BILL_TO_SITE_USE_ID
, TO_CHAR(NULL) SITE_USES
FROM HZ_CUST_ACCOUNTS CUST
, HZ_PARTIES PARTY
WHERE CUST.PARTY_ID = PARTY.PARTY_ID

Columns

Name
CUSTOMER_ID
DETAILS_LEVEL
CUSTOMER_NUMBER
CUSTOMER_NAME
ADDRESS_ID
CONCATENATED_ADDRESS
CONTACT_NAME
CONTACT_PHONE
BILL_TO_SITE_USE_ID
SITE_USES