VIEW: APPS.ASO_PVT_CUSTOMER_PER_FIND_V

Source

View Text - Preformatted

SELECT hca.cust_account_id Cust_account_id, hper.party_name Customer_Name, hper.person_first_name Person_first_name, hper.person_last_name Person_last_name, hca.account_number Account_number, hper.party_number Registry_Id, hca.status Status, hper.tax_reference Tax_reg_number, hper.jgzz_fiscal_code Taxpayer_id, hca.orig_system_reference Reference, hper.customer_key Customer_key, hper.party_type Customer_type, hper.party_id Party_id, phon.phone_country_code || phon.phone_area_code || phon.phone_number || phon.phone_extension person_phone, phon.phone_country_code || ' ' || phon.phone_area_code || ' ' || phon.phone_number || ' ' || phon.phone_extension Person_phone_disp, phon.primary_flag Primary_phone_flag FROM hz_parties hper, hz_cust_accounts hca, hz_contact_points phon WHERE hper.party_type = 'PERSON' AND hper.party_id = hca.party_id(+) and hca.status(+) = 'A' and hper.party_id = phon.owner_table_id(+) and phon.owner_table_name(+) = 'HZ_PARTIES' and phon.contact_point_type(+) = 'PHONE' and phon.status(+) = 'A' AND hper.status = 'A'

View Text - HTML Formatted

SELECT HCA.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, HPER.PARTY_NAME CUSTOMER_NAME
, HPER.PERSON_FIRST_NAME PERSON_FIRST_NAME
, HPER.PERSON_LAST_NAME PERSON_LAST_NAME
, HCA.ACCOUNT_NUMBER ACCOUNT_NUMBER
, HPER.PARTY_NUMBER REGISTRY_ID
, HCA.STATUS STATUS
, HPER.TAX_REFERENCE TAX_REG_NUMBER
, HPER.JGZZ_FISCAL_CODE TAXPAYER_ID
, HCA.ORIG_SYSTEM_REFERENCE REFERENCE
, HPER.CUSTOMER_KEY CUSTOMER_KEY
, HPER.PARTY_TYPE CUSTOMER_TYPE
, HPER.PARTY_ID PARTY_ID
, PHON.PHONE_COUNTRY_CODE || PHON.PHONE_AREA_CODE || PHON.PHONE_NUMBER || PHON.PHONE_EXTENSION PERSON_PHONE
, PHON.PHONE_COUNTRY_CODE || ' ' || PHON.PHONE_AREA_CODE || ' ' || PHON.PHONE_NUMBER || ' ' || PHON.PHONE_EXTENSION PERSON_PHONE_DISP
, PHON.PRIMARY_FLAG PRIMARY_PHONE_FLAG
FROM HZ_PARTIES HPER
, HZ_CUST_ACCOUNTS HCA
, HZ_CONTACT_POINTS PHON
WHERE HPER.PARTY_TYPE = 'PERSON'
AND HPER.PARTY_ID = HCA.PARTY_ID(+)
AND HCA.STATUS(+) = 'A'
AND HPER.PARTY_ID = PHON.OWNER_TABLE_ID(+)
AND PHON.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND PHON.CONTACT_POINT_TYPE(+) = 'PHONE'
AND PHON.STATUS(+) = 'A'
AND HPER.STATUS = 'A'