4013: ,MAX(HCAN.CUST_ACCOUNT_ID) OVER (PARTITION BY CLI.ROWID) HCAN_ID -- COVERED ACCOUNT ID Based on Number
4014:
4015:
4016: FROM OKS_COVERED_LEVELS_INTERFACE CLI
4017: ,HZ_CUST_ACCOUNTS HCAI
4018: ,HZ_CUST_ACCOUNTS HCAN
4019:
4020: WHERE CLI.COVERED_ACCOUNT_ID = HCAI.CUST_ACCOUNT_ID (+)
4021: AND CLI.COVERED_ACCOUNT_NUMBER = HCAN.ACCOUNT_NUMBER (+)) NAMEID_Q
4014:
4015:
4016: FROM OKS_COVERED_LEVELS_INTERFACE CLI
4017: ,HZ_CUST_ACCOUNTS HCAI
4018: ,HZ_CUST_ACCOUNTS HCAN
4019:
4020: WHERE CLI.COVERED_ACCOUNT_ID = HCAI.CUST_ACCOUNT_ID (+)
4021: AND CLI.COVERED_ACCOUNT_NUMBER = HCAN.ACCOUNT_NUMBER (+)) NAMEID_Q
4022: