VIEW: APPS.WSH_CUSTOMERS_ACTIVE_V

Source

View Text - Preformatted

SELECT substrb ( party.party_name, 1, 50 ) customer_name , cust_acct.account_number customer_number , cust_acct.cust_account_id customer_id, nvl( decode ( party.party_type, 'ORGANIZATION', party.gsa_indicator_flag, 'N' ) ,'N') gsa_indicator FROM hz_parties party, hz_cust_accounts cust_acct WHERE cust_acct.party_id = party.party_id AND cust_acct.status = 'A'

View Text - HTML Formatted

SELECT SUBSTRB ( PARTY.PARTY_NAME
, 1
, 50 ) CUSTOMER_NAME
, CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER
, CUST_ACCT.CUST_ACCOUNT_ID CUSTOMER_ID
, NVL( DECODE ( PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.GSA_INDICATOR_FLAG
, 'N' )
, 'N') GSA_INDICATOR
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND CUST_ACCT.STATUS = 'A'