VIEW: APPS.AR_CUSTOMER_SEARCH_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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