DBA Data[Home] [Help]

APPS.OKS_RENEW_CONTRACT_PVT dependencies on HZ_CUST_ACCOUNTS

Line 4597: FROM HZ_CUST_ACCOUNTS CA,HZ_PARTIES P

4593: UNION ALL
4594: SELECT 'OKX_CUSTACCT' TYPE, CA.CUST_ACCOUNT_ID ID1, '#' ID2,
4595: decode(CA.ACCOUNT_NAME, null, P.PARTY_NAME, CA.Account_NAME) NAME,
4596: CA.ACCOUNT_NUMBER DESCRIPTION, NULL INV_ORG_ID
4597: FROM HZ_CUST_ACCOUNTS CA,HZ_PARTIES P
4598: WHERE CA.PARTY_ID = P.PARTY_ID
4599: UNION ALL
4600: SELECT 'OKX_COUNTER' TYPE, CCT.COUNTER_ID ID1, '#' ID2, CCT.NAME NAME,
4601: CCT.DESCRIPTION DESCRIPTION, NULL INV_ORG_ID