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 1496: AND EXISTS (SELECT 'X' FROM HZ_CUST_ACCT_SITES CAS

1492: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
1493: AND P.PARTY_ID = R.SUBJECT_ID
1494: AND R.DIRECTIONAL_FLAG = 'F'
1495: AND CAR.CUST_ACCOUNT_ROLE_ID = p_contact_id
1496: AND EXISTS (SELECT 'X' FROM HZ_CUST_ACCT_SITES CAS
1497: WHERE CAS.CUST_ACCOUNT_ID = CAR.CUST_ACCOUNT_ID
1498: AND CAS.ORG_ID = P_ORG_ID);
1499:
1500:

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

2518: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2519: AND P.PARTY_ID = R.SUBJECT_ID
2520: AND R.DIRECTIONAL_FLAG = 'F'
2521: AND CAR.CUST_ACCOUNT_ROLE_ID = p_contact_id
2522: AND EXISTS (SELECT 'X' FROM HZ_CUST_ACCT_SITES CAS
2523: WHERE CAS.CUST_ACCOUNT_ID = CAR.CUST_ACCOUNT_ID
2524: AND CAS.ORG_ID = P_ORG_ID);
2525:
2526: