VIEW: APPS.FV_AR_FIN_CHRG_CUSTOMERS_V

Source

View Text - Preformatted

SELECT DISTINCT fcf.customer_id, fcf.org_id, hr.name operating_unit, hzp.party_name customer_name, hzca.account_number customer_number FROM fv_cust_finance_chrgs fcf, hz_parties hzp, hz_cust_accounts hzca, hr_operating_units hr WHERE hzp.party_id = hzca.party_id AND fcf.customer_id = hzca.cust_account_id AND hr.organization_id = fcf.org_id AND EXISTS (SELECT 1 FROM FV_AR_FIN_CHRG_INVOICES fafci WHERE fafci.customer_id = fcf.customer_id)

View Text - HTML Formatted

SELECT DISTINCT FCF.CUSTOMER_ID
, FCF.ORG_ID
, HR.NAME OPERATING_UNIT
, HZP.PARTY_NAME CUSTOMER_NAME
, HZCA.ACCOUNT_NUMBER CUSTOMER_NUMBER
FROM FV_CUST_FINANCE_CHRGS FCF
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HZCA
, HR_OPERATING_UNITS HR
WHERE HZP.PARTY_ID = HZCA.PARTY_ID
AND FCF.CUSTOMER_ID = HZCA.CUST_ACCOUNT_ID
AND HR.ORGANIZATION_ID = FCF.ORG_ID
AND EXISTS (SELECT 1
FROM FV_AR_FIN_CHRG_INVOICES FAFCI
WHERE FAFCI.CUSTOMER_ID = FCF.CUSTOMER_ID)