VIEW: APPS.AR_CUSTOMER_ALT_NAMES_V

Source

View Text - Preformatted

SELECT AL.ROWID , AL.ALT_NAME_ID , AL.ALT_NAME , CUST_ACCT.CUST_ACCOUNT_ID , CUST_ACCT.ACCOUNT_NUMBER , SUBSTRB(PARTY.PARTY_NAME,1,50) , DECODE(PARTY.PARTY_TYPE, 'ORGANIZATION', PARTY.ORGANIZATION_NAME_PHONETIC, NULL) /*CUSTOMER_NAME_PHONETIC*/ , RS.SITE_USE_ID , RS.LOCATION , RT.TERM_ID , RT.NAME , AL.CREATED_BY , AL.CREATION_DATE , AL.LAST_UPDATE_DATE , AL.LAST_UPDATE_LOGIN , AL.LAST_UPDATED_BY , CUST_ACCT.ACCOUNT_NAME , RS.ORG_ID FROM AR_CUSTOMER_ALT_NAMES AL, HZ_CUST_ACCOUNTS CUST_ACCT, HZ_PARTIES PARTY, HZ_CUST_SITE_USES_ALL RS, RA_TERMS RT WHERE AL.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID AND AL.SITE_USE_ID = RS.SITE_USE_ID(+) AND AL.TERM_ID = RT.TERM_ID(+)

View Text - HTML Formatted

SELECT AL.ROWID
, AL.ALT_NAME_ID
, AL.ALT_NAME
, CUST_ACCT.CUST_ACCOUNT_ID
, CUST_ACCT.ACCOUNT_NUMBER
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.ORGANIZATION_NAME_PHONETIC
, NULL) /*CUSTOMER_NAME_PHONETIC*/
, RS.SITE_USE_ID
, RS.LOCATION
, RT.TERM_ID
, RT.NAME
, AL.CREATED_BY
, AL.CREATION_DATE
, AL.LAST_UPDATE_DATE
, AL.LAST_UPDATE_LOGIN
, AL.LAST_UPDATED_BY
, CUST_ACCT.ACCOUNT_NAME
, RS.ORG_ID
FROM AR_CUSTOMER_ALT_NAMES AL
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, HZ_CUST_SITE_USES_ALL RS
, RA_TERMS RT
WHERE AL.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND AL.SITE_USE_ID = RS.SITE_USE_ID(+)
AND AL.TERM_ID = RT.TERM_ID(+)