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_RELATIONSHIPS

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

2815: ,RA_RULES IRN
2816: ,MTL_SYSTEM_ITEMS_B MSI
2817: ,MTL_SYSTEM_ITEMS_B_KFV MSN
2818: ,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
2819: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC
2820: WHERE CAR.ROLE_TYPE = 'CONTACT'
2821: AND R.PARTY_ID = CAR.PARTY_ID
2822: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2823: AND P.PARTY_ID = R.SUBJECT_ID

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

2824: AND OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
2825: AND R.DIRECTIONAL_FLAG = 'F') BCI
2826:
2827: ,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
2828: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC
2829: WHERE CAR.ROLE_TYPE = 'CONTACT'
2830: AND R.PARTY_ID = CAR.PARTY_ID
2831: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2832: AND P.PARTY_ID = R.SUBJECT_ID

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

2832: AND P.PARTY_ID = R.SUBJECT_ID
2833: AND OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
2834: AND R.DIRECTIONAL_FLAG = 'F') SCI
2835: /*,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
2836: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC
2837: WHERE CAR.ROLE_TYPE = 'CONTACT'
2838: AND R.PARTY_ID = CAR.PARTY_ID
2839: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2840: AND P.PARTY_ID = R.SUBJECT_ID

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

2840: AND P.PARTY_ID = R.SUBJECT_ID
2841: AND OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
2842: AND R.DIRECTIONAL_FLAG = 'F') BCN
2843: ,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
2844: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC
2845: WHERE CAR.ROLE_TYPE = 'CONTACT'
2846: AND R.PARTY_ID = CAR.PARTY_ID
2847: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2848: AND P.PARTY_ID = R.SUBJECT_ID