DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on HZ_CUST_ACCOUNTS

Line 4017: ,HZ_CUST_ACCOUNTS HCAI

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

Line 4018: ,HZ_CUST_ACCOUNTS HCAN

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: