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_IMPORT_VALIDATE dependencies on HZ_ORG_CONTACTS

Line 2771: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC

2767: ,RA_RULES IRN
2768: ,MTL_SYSTEM_ITEMS_B MSI
2769: ,MTL_SYSTEM_ITEMS_B_KFV MSN
2770: ,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
2771: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC
2772: WHERE CAR.ROLE_TYPE = 'CONTACT'
2773: AND R.PARTY_ID = CAR.PARTY_ID
2774: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2775: AND P.PARTY_ID = R.SUBJECT_ID

Line 2780: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC

2776: AND OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
2777: AND R.DIRECTIONAL_FLAG = 'F') BCI
2778:
2779: ,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
2780: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC
2781: WHERE CAR.ROLE_TYPE = 'CONTACT'
2782: AND R.PARTY_ID = CAR.PARTY_ID
2783: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2784: AND P.PARTY_ID = R.SUBJECT_ID

Line 2788: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC

2784: AND P.PARTY_ID = R.SUBJECT_ID
2785: AND OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
2786: AND R.DIRECTIONAL_FLAG = 'F') SCI
2787: /*,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
2788: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC
2789: WHERE CAR.ROLE_TYPE = 'CONTACT'
2790: AND R.PARTY_ID = CAR.PARTY_ID
2791: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2792: AND P.PARTY_ID = R.SUBJECT_ID

Line 2796: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC

2792: AND P.PARTY_ID = R.SUBJECT_ID
2793: AND OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
2794: AND R.DIRECTIONAL_FLAG = 'F') BCN
2795: ,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
2796: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC
2797: WHERE CAR.ROLE_TYPE = 'CONTACT'
2798: AND R.PARTY_ID = CAR.PARTY_ID
2799: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2800: AND P.PARTY_ID = R.SUBJECT_ID