DBA Data[Home] [Help]

APPS.OKS_KHR_PVT dependencies on HZ_RELATIONSHIPS

Line 1489: HZ_RELATIONSHIPS R

1485: SELECT
1486: P.PARTY_ID
1487: FROM HZ_CUST_ACCOUNT_ROLES CAR,
1488: HZ_PARTIES P,
1489: HZ_RELATIONSHIPS R
1490: WHERE CAR.ROLE_TYPE = 'CONTACT'
1491: AND R.PARTY_ID = CAR.PARTY_ID
1492: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
1493: AND P.PARTY_ID = R.SUBJECT_ID

Line 2515: HZ_RELATIONSHIPS R

2511: SELECT
2512: P.PARTY_ID
2513: FROM HZ_CUST_ACCOUNT_ROLES CAR,
2514: HZ_PARTIES P,
2515: HZ_RELATIONSHIPS R
2516: WHERE CAR.ROLE_TYPE = 'CONTACT'
2517: AND R.PARTY_ID = CAR.PARTY_ID
2518: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2519: AND P.PARTY_ID = R.SUBJECT_ID