DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on HZ_CUST_ACCOUNTS

Line 3965: ,HZ_CUST_ACCOUNTS HCAI

3961: ,MAX(HCAN.CUST_ACCOUNT_ID) OVER (PARTITION BY CLI.ROWID) HCAN_ID -- COVERED ACCOUNT ID Based on Number
3962:
3963:
3964: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3965: ,HZ_CUST_ACCOUNTS HCAI
3966: ,HZ_CUST_ACCOUNTS HCAN
3967:
3968: WHERE CLI.COVERED_ACCOUNT_ID = HCAI.CUST_ACCOUNT_ID (+)
3969: AND CLI.COVERED_ACCOUNT_NUMBER = HCAN.ACCOUNT_NUMBER (+)) NAMEID_Q

Line 3966: ,HZ_CUST_ACCOUNTS HCAN

3962:
3963:
3964: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3965: ,HZ_CUST_ACCOUNTS HCAI
3966: ,HZ_CUST_ACCOUNTS HCAN
3967:
3968: WHERE CLI.COVERED_ACCOUNT_ID = HCAI.CUST_ACCOUNT_ID (+)
3969: AND CLI.COVERED_ACCOUNT_NUMBER = HCAN.ACCOUNT_NUMBER (+)) NAMEID_Q
3970: