892: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
893: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
894: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
895: AND QPTL.LANGUAGE = USERENV('LANG')) RNPLN
896: ,RA_RULES ARI
897: ,RA_RULES ARN
898: ,RA_RULES IRI
899: ,RA_RULES IRN
900: ,RA_TERMS_B PTI
893: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
894: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
895: AND QPTL.LANGUAGE = USERENV('LANG')) RNPLN
896: ,RA_RULES ARI
897: ,RA_RULES ARN
898: ,RA_RULES IRI
899: ,RA_RULES IRN
900: ,RA_TERMS_B PTI
901: ,RA_TERMS_TL PTTLN
894: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
895: AND QPTL.LANGUAGE = USERENV('LANG')) RNPLN
896: ,RA_RULES ARI
897: ,RA_RULES ARN
898: ,RA_RULES IRI
899: ,RA_RULES IRN
900: ,RA_TERMS_B PTI
901: ,RA_TERMS_TL PTTLN
902: ,OKC_K_GROUPS_B CGI
895: AND QPTL.LANGUAGE = USERENV('LANG')) RNPLN
896: ,RA_RULES ARI
897: ,RA_RULES ARN
898: ,RA_RULES IRI
899: ,RA_RULES IRN
900: ,RA_TERMS_B PTI
901: ,RA_TERMS_TL PTTLN
902: ,OKC_K_GROUPS_B CGI
903: ,OKC_K_GROUPS_TL CGTLN
2760: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
2761: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
2762: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
2763: AND QPTL.LANGUAGE = USERENV('LANG')) QPTLN
2764: ,RA_RULES ARI
2765: ,RA_RULES ARN
2766: ,RA_RULES IRI
2767: ,RA_RULES IRN
2768: ,MTL_SYSTEM_ITEMS_B MSI
2761: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
2762: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
2763: AND QPTL.LANGUAGE = USERENV('LANG')) QPTLN
2764: ,RA_RULES ARI
2765: ,RA_RULES ARN
2766: ,RA_RULES IRI
2767: ,RA_RULES IRN
2768: ,MTL_SYSTEM_ITEMS_B MSI
2769: ,MTL_SYSTEM_ITEMS_B_KFV MSN
2762: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID
2763: AND QPTL.LANGUAGE = USERENV('LANG')) QPTLN
2764: ,RA_RULES ARI
2765: ,RA_RULES ARN
2766: ,RA_RULES IRI
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
2763: AND QPTL.LANGUAGE = USERENV('LANG')) QPTLN
2764: ,RA_RULES ARI
2765: ,RA_RULES ARN
2766: ,RA_RULES IRI
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