VIEW: APPS.ASO_PVT_CUSTOMER_ORG_FIND_V

Source

View Text - Preformatted

SELECT hca.cust_account_id Cust_account_id, hcust.party_name Customer_Name, hcust.party_number Registry_Id, hcust.person_first_name Person_first_name, hcust.person_last_name Person_last_name, hca.account_number Account_number, hca.status Status, hcust.tax_reference Tax_reg_number, hcust.jgzz_fiscal_code Taxpayer_id, hca.orig_system_reference Reference, hcust.customer_key Customer_key, hcust.party_type Customer_Type, hcust.party_id Party_id, NULL Cont_Full_Name, NULL Cont_Phone FROM hz_cust_accounts hca, hz_parties hcust WHERE hca.party_id(+) = hcust.party_id AND hca.status(+) = 'A' AND hcust.party_type = 'ORGANIZATION' AND trunc(nvl(hca.account_activation_date,sysdate)) <= trunc(sysdate) AND trunc(nvl(hca.account_termination_date,sysdate)) >= trunc(sysdate) AND hcust.status = 'A'

View Text - HTML Formatted

SELECT HCA.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, HCUST.PARTY_NAME CUSTOMER_NAME
, HCUST.PARTY_NUMBER REGISTRY_ID
, HCUST.PERSON_FIRST_NAME PERSON_FIRST_NAME
, HCUST.PERSON_LAST_NAME PERSON_LAST_NAME
, HCA.ACCOUNT_NUMBER ACCOUNT_NUMBER
, HCA.STATUS STATUS
, HCUST.TAX_REFERENCE TAX_REG_NUMBER
, HCUST.JGZZ_FISCAL_CODE TAXPAYER_ID
, HCA.ORIG_SYSTEM_REFERENCE REFERENCE
, HCUST.CUSTOMER_KEY CUSTOMER_KEY
, HCUST.PARTY_TYPE CUSTOMER_TYPE
, HCUST.PARTY_ID PARTY_ID
, NULL CONT_FULL_NAME
, NULL CONT_PHONE
FROM HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HCUST
WHERE HCA.PARTY_ID(+) = HCUST.PARTY_ID
AND HCA.STATUS(+) = 'A'
AND HCUST.PARTY_TYPE = 'ORGANIZATION'
AND TRUNC(NVL(HCA.ACCOUNT_ACTIVATION_DATE
, SYSDATE)) <= TRUNC(SYSDATE)
AND TRUNC(NVL(HCA.ACCOUNT_TERMINATION_DATE
, SYSDATE)) >= TRUNC(SYSDATE)
AND HCUST.STATUS = 'A'