VIEW: APPS.IEX_LM_PER_QUICK_W_ACC_V

Source

View Text - Preformatted

SELECT PARTY.PARTY_ID PARTY_ID, hca.account_number account_number, hca.cust_account_id cust_account_id, PARTY.PERSON_FIRST_NAME PERSON_FIRST_NAME, PARTY.PERSON_MIDDLE_NAME PERSON_MIDDLE_NAME, PARTY.PERSON_LAST_NAME PERSON_LAST_NAME, PARTY.ADDRESS1||PARTY.ADDRESS2||PARTY.ADDRESS3||PARTY.ADDRESS4 ADDRESS, PARTY.CITY CITY, PARTY.STATE STATE, PARTY.POSTAL_CODE POSTAL_CODE, PARTY.PROVINCE PROVINCE, PARTY.COUNTRY COUNTRY, FTT.TERRITORY_SHORT_NAME COUNTRY_NAME, PARTY.EMAIL_ADDRESS EMAIL_ADDRESS, PARTY.STATUS STATUS, ALK.MEANING STATUS_MEAN FROM HZ_PARTIES PARTY , AR_LOOKUPS ALK , FND_TERRITORIES_TL FTT , HZ_CUST_ACCOUNTS hca WHERE PARTY_TYPE = 'PERSON' AND ALK.LOOKUP_TYPE = 'CODE_STATUS' AND ALK.LOOKUP_CODE = PARTY.STATUS AND FTT.LANGUAGE(+) = userenv('LANG') AND FTT.SOURCE_LANG(+) = userenv('LANG') AND PARTY.COUNTRY = FTT.TERRITORY_CODE(+) and hca.PARTY_ID(+) = PARTY.PARTY_ID

View Text - HTML Formatted

SELECT PARTY.PARTY_ID PARTY_ID
, HCA.ACCOUNT_NUMBER ACCOUNT_NUMBER
, HCA.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, PARTY.PERSON_FIRST_NAME PERSON_FIRST_NAME
, PARTY.PERSON_MIDDLE_NAME PERSON_MIDDLE_NAME
, PARTY.PERSON_LAST_NAME PERSON_LAST_NAME
, PARTY.ADDRESS1||PARTY.ADDRESS2||PARTY.ADDRESS3||PARTY.ADDRESS4 ADDRESS
, PARTY.CITY CITY
, PARTY.STATE STATE
, PARTY.POSTAL_CODE POSTAL_CODE
, PARTY.PROVINCE PROVINCE
, PARTY.COUNTRY COUNTRY
, FTT.TERRITORY_SHORT_NAME COUNTRY_NAME
, PARTY.EMAIL_ADDRESS EMAIL_ADDRESS
, PARTY.STATUS STATUS
, ALK.MEANING STATUS_MEAN
FROM HZ_PARTIES PARTY
, AR_LOOKUPS ALK
, FND_TERRITORIES_TL FTT
, HZ_CUST_ACCOUNTS HCA
WHERE PARTY_TYPE = 'PERSON'
AND ALK.LOOKUP_TYPE = 'CODE_STATUS'
AND ALK.LOOKUP_CODE = PARTY.STATUS
AND FTT.LANGUAGE(+) = USERENV('LANG')
AND FTT.SOURCE_LANG(+) = USERENV('LANG')
AND PARTY.COUNTRY = FTT.TERRITORY_CODE(+)
AND HCA.PARTY_ID(+) = PARTY.PARTY_ID