(SELECT
(
'Active accounts' ) AS "Active Accounts",
(
SELECT COUNT(*) FROM avuser.PV_ACCOUNT pa
LEFT JOIN avuser.PV_USER_ACCOUNT_MAPPING pum
ON pa.ID=pum.ACCOUNT_ID
LEFT JOIN avuser.PV_USERS pu
ON pum.USER_ID = pu.ID
LEFT JOIN avuser.PV_BUSINESS_SOURCE pbs 
ON pa.APPLICATION_ID = pbs.ID
WHERE pa.IS_DISABLED =0
AND pa.DELETION_DATE IS NULL
AND pu.IS_TERMINATED ='False'
AND (pbs.RESOURCE_TYPE = 'A' 
OR pbs.RESOURCE_TYPE = 'D' )
) AS "Active_linked_active ",
(
SELECT COUNT(*) FROM avuser.PV_ACCOUNT pa
LEFT JOIN avuser.PV_USER_ACCOUNT_MAPPING pum
ON pa.ID=pum.ACCOUNT_ID
LEFT JOIN avuser.PV_USERS pu
ON pum.USER_ID = pu.ID
LEFT JOIN avuser.PV_BUSINESS_SOURCE pbs 
ON pa.APPLICATION_ID = pbs.ID
WHERE pa.IS_DISABLED =0
AND pa.DELETION_DATE IS NULL
AND pu.IS_TERMINATED ='True'
AND (pbs.RESOURCE_TYPE = 'A' 
OR pbs.RESOURCE_TYPE = 'D' )
) AS "Active_linked_term ",
(
SELECT COUNT(*) FROM avuser.PV_ACCOUNT pa
LEFT JOIN avuser.PV_BUSINESS_SOURCE pbs 
ON pa.APPLICATION_ID = pbs.ID
WHERE pa.ORPHANED_DATE IS NOT NULL
AND pa.IS_DISABLED =0
AND pa.DELETION_DATE IS NULL
AND (pbs.RESOURCE_TYPE = 'A' 
OR pbs.RESOURCE_TYPE = 'D' )
) AS "Orphan Account"
 FROM dual)