eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_KHR_PVT dependencies on HZ_CUST_ACCT_SITES

Line 1472: AND EXISTS (SELECT 'X' FROM HZ_CUST_ACCT_SITES CAS

1468: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
1469: AND P.PARTY_ID = R.SUBJECT_ID
1470: AND R.DIRECTIONAL_FLAG = 'F'
1471: AND CAR.CUST_ACCOUNT_ROLE_ID = p_contact_id
1472: AND EXISTS (SELECT 'X' FROM HZ_CUST_ACCT_SITES CAS
1473: WHERE CAS.CUST_ACCOUNT_ID = CAR.CUST_ACCOUNT_ID
1474: AND CAS.ORG_ID = P_ORG_ID);
1475:
1476:

Line 2492: AND EXISTS (SELECT 'X' FROM HZ_CUST_ACCT_SITES CAS

2488: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2489: AND P.PARTY_ID = R.SUBJECT_ID
2490: AND R.DIRECTIONAL_FLAG = 'F'
2491: AND CAR.CUST_ACCOUNT_ROLE_ID = p_contact_id
2492: AND EXISTS (SELECT 'X' FROM HZ_CUST_ACCT_SITES CAS
2493: WHERE CAS.CUST_ACCOUNT_ID = CAR.CUST_ACCOUNT_ID
2494: AND CAS.ORG_ID = P_ORG_ID);
2495:
2496: