DBA Data[Home] [Help]

APPS.OKS_RENEW_CONTRACT_PVT dependencies on HZ_CUST_ACCOUNTS

Line 4562: FROM HZ_CUST_ACCOUNTS CA,HZ_PARTIES P

4558: UNION ALL
4559: SELECT 'OKX_CUSTACCT' TYPE, CA.CUST_ACCOUNT_ID ID1, '#' ID2,
4560: decode(CA.ACCOUNT_NAME, null, P.PARTY_NAME, CA.Account_NAME) NAME,
4561: CA.ACCOUNT_NUMBER DESCRIPTION, NULL INV_ORG_ID
4562: FROM HZ_CUST_ACCOUNTS CA,HZ_PARTIES P
4563: WHERE CA.PARTY_ID = P.PARTY_ID
4564: UNION ALL
4565: SELECT 'OKX_COUNTER' TYPE, CCT.COUNTER_ID ID1, '#' ID2, CCT.NAME NAME,
4566: CCT.DESCRIPTION DESCRIPTION, NULL INV_ORG_ID