DBA Data[Home] [Help]

APPS.OKS_KHR_PVT dependencies on HZ_RELATIONSHIPS

Line 1465: HZ_RELATIONSHIPS R

1461: SELECT
1462: P.PARTY_ID
1463: FROM HZ_CUST_ACCOUNT_ROLES CAR,
1464: HZ_PARTIES P,
1465: HZ_RELATIONSHIPS R
1466: WHERE CAR.ROLE_TYPE = 'CONTACT'
1467: AND R.PARTY_ID = CAR.PARTY_ID
1468: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
1469: AND P.PARTY_ID = R.SUBJECT_ID

Line 2485: HZ_RELATIONSHIPS R

2481: SELECT
2482: P.PARTY_ID
2483: FROM HZ_CUST_ACCOUNT_ROLES CAR,
2484: HZ_PARTIES P,
2485: HZ_RELATIONSHIPS R
2486: WHERE CAR.ROLE_TYPE = 'CONTACT'
2487: AND R.PARTY_ID = CAR.PARTY_ID
2488: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2489: AND P.PARTY_ID = R.SUBJECT_ID