DBA Data[Home] [Help]

APPS.OKS_IMPORT_TEST_INSERT dependencies on HZ_ORG_CONTACTS

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

468: ,OKC_K_PARTY_ROLES_B PTY
469: ,OKC_CONTACTS BILLTOCONT
470: ,OKC_CONTACTS SHIPTOCONT
471: ,(SELECT CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
472: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC
473: WHERE CAR.ROLE_TYPE = 'CONTACT'
474: AND R.PARTY_ID = CAR.PARTY_ID
475: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
476: AND P.PARTY_ID = R.SUBJECT_ID

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

476: AND P.PARTY_ID = R.SUBJECT_ID
477: AND OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
478: AND R.DIRECTIONAL_FLAG = 'F') BILLTOCONTNAME
479: ,(SELECT CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
480: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC
481: WHERE CAR.ROLE_TYPE = 'CONTACT'
482: AND R.PARTY_ID = CAR.PARTY_ID
483: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
484: AND P.PARTY_ID = R.SUBJECT_ID