931: ,RA_TERMS_TL PTTLN
932: ,OKC_K_GROUPS_B CGI
933: ,OKC_K_GROUPS_TL CGTLN
934: ,OKC_K_GROUPS_B CGBN
935: ,OKX_PARTY_CONTACTS_V CCAI
936: ,OKX_PARTY_CONTACTS_V CCAN
937: ,HR_ORGANIZATION_INFORMATION HOIPL
938: ,GL_LEDGERS GL
939: WHERE HDI.CUSTOMER_PARTY_ID = HPCUSTI.PARTY_ID (+)
932: ,OKC_K_GROUPS_B CGI
933: ,OKC_K_GROUPS_TL CGTLN
934: ,OKC_K_GROUPS_B CGBN
935: ,OKX_PARTY_CONTACTS_V CCAI
936: ,OKX_PARTY_CONTACTS_V CCAN
937: ,HR_ORGANIZATION_INFORMATION HOIPL
938: ,GL_LEDGERS GL
939: WHERE HDI.CUSTOMER_PARTY_ID = HPCUSTI.PARTY_ID (+)
940: AND HDI.CUSTOMER_PARTY_NAME = HPCUSTN.PARTY_NAME (+)