APPS.OKS_IMPORT_TEST_INSERT dependencies on HZ_PARTIES

Line 269: ,HZ_PARTIES HZP

265: OKC_K_HEADERS_ALL_B H
266: ,OKS_K_HEADERS_B HS
267: ,OKC_K_HEADERS_TL HL
268: ,OKC_K_PARTY_ROLES_B PTY
269: ,HZ_PARTIES HZP
270: ,OKC_K_PARTY_ROLES_B PTY3
271: ,HZ_PARTIES HZP3
272: ,HZ_CUST_SITE_USES_ALL BSU
273: ,HZ_CUST_SITE_USES_ALL SSU

Line 271: ,HZ_PARTIES HZP3

267: ,OKC_K_HEADERS_TL HL
268: ,OKC_K_PARTY_ROLES_B PTY
269: ,HZ_PARTIES HZP
270: ,OKC_K_PARTY_ROLES_B PTY3
271: ,HZ_PARTIES HZP3
272: ,HZ_CUST_SITE_USES_ALL BSU
273: ,HZ_CUST_SITE_USES_ALL SSU
274: ,OKC_K_PARTY_ROLES_B VNDRPTY
275: ,OKC_CONTACTS SLSREP

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

Line 662: ,HZ_PARTIES HZPRT

658: ,OKC_K_ITEMS OKCITM
659: ,CSI_ITEM_INSTANCES CSIITMINST
660: ,HZ_CUST_ACCOUNTS CUSTACC
661: ,MTL_SYSTEM_ITEMS_B_kfv MTLSYSITM
662: ,HZ_PARTIES HZPRT
663: ,HZ_PARTY_SITES HZPRTSIT
664: ,CSI_SYSTEMS_B CSISYS
665: ,OKC_K_LINES_TL OKCLINTL
666: ,OKS_K_LINES_B OKSLINB