VIEW: APPS.OKL_K_HDRS_FULL_UV

Source

View Text - Preformatted

SELECT chr.id chr_id, chr.contract_number chr_contract_number, chr.description chr_description, vers.major_version||'.'||vers.minor_version vers_version, chr.STS_CODE chr_sts_code, ststl.MEANING chr_sts_meaning, to_char(chr.start_date) chr_start_date, to_char(chr.end_date) chr_end_date, to_char(khr.term_duration) khr_term_duration, chr.CUST_PO_NUMBER chr_CUST_PO_NUMBER, chr.INV_ORGANIZATION_ID chr_INV_ORGANIZATION_ID, chr.AUTHORING_ORG_ID chr_AUTHORING_ORG_ID, khr.GENERATE_ACCRUAL_YN khr_GENERATE_ACCRUAL_YN, khr.SYNDICATABLE_YN khr_SYNDICATABLE_YN, khr.PREFUNDING_ELIGIBLE_YN khr_PREFUNDING_ELIGIBLE_YN, khr.REVOLVING_CREDIT_YN khr_REVOLVING_CREDIT_YN, khr.CONVERTED_ACCOUNT_YN khr_CONVERTED_ACCOUNT_YN, khr.CREDIT_ACT_YN khr_CREDIT_ACT_YN, chr.TEMPLATE_YN chr_TEMPLATE_YN, to_char(chr.DATE_SIGNED) chr_DATE_SIGNED, to_char(khr.DATE_DEAL_TRANSFERRED) khr_DATE_DEAL_TRANSFERRED, to_char(khr.ACCEPTED_DATE) khr_ACCEPTED_DATE, to_char(khr.EXPECTED_DELIVERY_DATE) khr_EXPECTED_DELIVERY_DATE, khr.AMD_CODE khr_AMD_CODE, khr.DEAL_TYPE khr_DEAL_TYPE, chr.ORIG_SYSTEM_REFERENCE1 chr_ORIG_SYSTEM_REFERENCE1, chr.ORIG_SYSTEM_SOURCE_CODE chr_ORIG_SYSTEM_SOURCE_CODE, chr.ORIG_SYSTEM_ID1 chr_ORIG_SYSTEM_ID1, to_char(null) mla_contract_number, to_number(null) mla_gvr_chr_id_referred, to_number(null) mla_gvr_id, cust.id cust_id, cust.object1_id1 cust_object1_id1, cust.object1_id2 cust_object1_id2, cust.jtot_object1_code cust_jtot_object1_code , 'cust_name' cust_name, lessor.id lessor_id, lessor.object1_id1 lessor_object1_id1, lessor.object1_id2 lessor_object1_id2, lessor.jtot_object1_code lessor_jtot_object1_code, 'lessor_name' lessor_name, chr.currency_code chr_currency_code, currency.name currency_name, KHR.CURRENCY_CONVERSION_TYPE KHR_CURRENCY_CONVERSION_TYPE, TO_CHAR(KHR.CURRENCY_CONVERSION_RATE ) KHR_CURRENCY_CONVERSION_RATE, TO_CHAR(KHR.CURRENCY_CONVERSION_DATE) KHR_CURRENCY_CONVERSION_DATE, KHR.ASSIGNABLE_YN KHR_ASSIGNABLE_YN, khr.PDT_ID khr_pdt_id, product.name product_name, product.description product_description, khr.khr_id khr_khr_id, program.contract_number program_contract_number, to_char(null) cl_contract_number, to_number(null) cl_gvr_chr_id_referred, to_number(null) cl_gvr_id, books.short_name books_short_name, books.ledger_id books_set_of_books_id, oper_units.name oper_units_name, /* cust_site.description cust_site_description,*/ ( SELECT ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL, L.ADDRESS1, L.ADDRESS2, L.ADDRESS3, L.ADDRESS4, L.CITY, L.COUNTY, L.STATE, L.PROVINCE, L.POSTAL_CODE, NULL, L.COUNTRY, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'N', 'N', 300, 1, 1) DESCRIPTION FROM HZ_PARTY_SITES HPS, HZ_LOCATIONS L, HZ_PARTY_SITE_USES HPSU WHERE HPS.PARTY_ID = cust.object1_id1 AND HPS.STATUS = 'A' AND HPSU.PARTY_SITE_ID = HPS.PARTY_SITE_ID AND HPSU.SITE_USE_TYPE = 'LEGAL' AND HPSU.PRIMARY_PER_TYPE = 'Y' AND HPSU.STATUS = 'A' AND L.LOCATION_ID = HPS.LOCATION_ID ) cust_site_description, contact.id contact_id, contact.object1_id1 contact_object1_id1, contact.object1_id2 contact_object1_id2, contact.jtot_object1_code contact_jtot_object1_code, 'contact_name' contact_name, rg_larles.id rg_larles_id, r_larles.id r_larles_id, r_larles.rule_information1 r_larles_rule_information1, 'col_larles_form_left_prompt' col_larles_from_left_prompt, rg_LAREBL.id rg_LAREBL_id, r_LAREBL.id r_LAREBL_id, r_LAREBL.rule_information1 r_LAREBL_rule_information1, 'col_LAREBL_form_left_prompt' col_LAREBL_form_left_prompt, 'customer_account' customer_account, chr.cust_acct_id chr_cust_acct_id, rg_LATOWN.id rg_LATOWN_id, r_LATOWN.id r_LATOWN_id, r_LATOWN.rule_information1 r_LATOWN_rule_information1, 'col_LATOWN_form_left_prompt' col_LATOWN_form_left_prompt, rg_LANNTF.id rg_LANNTF_id, r_LANNTF.id r_LANNTF_id, r_LANNTF.rule_information1 r_LANNTF_rule_information1, 'col_LANNTF_form_left_prompt' col_LANNTF_form_left_prompt, rg_LACPLN.id rg_LACPLN_id, r_LACPLN.id r_LACPLN_id, r_LACPLN.rule_information1 r_LACPLN_rule_information1, 'col_LACPLN_form_left_prompt' col_LACPLN_form_left_prompt, rg_LAPACT.id rg_LAPACT_id, r_LAPACT.id r_LAPACT_id, r_LAPACT.rule_information1 r_LAPACT_rule_information1, 'col_LAPACT_form_left_prompt' col_LAPACT_form_left_prompt, ppv.interest_calculation_basis interest_calculation_basis, ppv.interest_calculation_meaning interest_calculation_meaning, ppv.revenue_recognition_method revenue_recognition_method, ppv.revenue_recognition_meaning revenue_recognition_meaning ,chr.org_id ORG_ID ,khr.legal_entity_id legal_entity_id FROM OKC_K_HEADERS_V CHR,OKL_K_HEADERS KHR,OKC_K_PARTY_ROLES_V CUST,OKC_K_PARTY_ROLES_V LESSOR,OKC_CONTACTS_V CONTACT,FND_CURRENCIES_VL CURRENCY,OKC_STATUSES_B STS,OKC_STATUSES_TL STSTL,OKC_K_VERS_NUMBERS_V VERS,OKL_PRODUCTS_V PRODUCT,OKC_K_HEADERS_V PROGRAM,GL_LEDGERS_PUBLIC_V BOOKS,HR_OPERATING_UNITS OPER_UNITS,OKL_SYS_ACCT_OPTS_ALL SAOB,OKC_RULE_GROUPS_B RG_LARLES,OKC_RULES_B R_LARLES,OKC_RULE_GROUPS_B RG_LAREBL,OKC_RULES_B R_LAREBL,OKC_RULE_GROUPS_B RG_LATOWN,OKC_RULES_B R_LATOWN,OKC_RULE_GROUPS_B RG_LANNTF,OKC_RULES_B R_LANNTF,OKC_RULE_GROUPS_B RG_LACPLN,OKC_RULES_B R_LACPLN,OKC_RULE_GROUPS_B RG_LAPACT,OKC_RULES_B R_LAPACT,OKL_PRODUCT_PARAMETERS_V PPV WHERE chr.id=khr.id and currency.currency_code = chr.currency_code and STS.CODE = chr.STS_CODE and STSTL.CODE = STS.CODE and STSTL.LANGUAGE = USERENV('LANG') and vers.chr_id = chr.id and product.id (+) = khr.pdt_id and program.id (+) = khr.khr_id and /*cust_site.party_id(+) = cust.object1_id1 and cust_site.site_use_code(+) = 'LEGAL' and*/ chr.id=cust.chr_id (+) and chr.id=cust.dnz_chr_id (+) and cust.rle_code(+) ='LESSEE' and chr.id=lessor.chr_id (+) and chr.id=lessor.dnz_chr_id (+) and lessor.rle_code(+) ='LESSOR' and lessor.id = contact.cpl_id(+) and contact.CRO_CODE (+) = 'SALESPERSON' and oper_units.organization_id = chr.authoring_org_id and books.ledger_id = saob.set_of_books_id and saob.org_id = chr.authoring_org_id and rg_larles.chr_id(+) = chr.id and rg_larles.dnz_chr_id(+) = chr.id and rg_larles.id = r_larles.rgp_id(+) and rg_larles.rgd_code(+) = 'LARLES' and r_larles.rule_information_category(+) = 'LARLES' and rg_LAREBL.chr_id(+) = chr.id and rg_LAREBL.dnz_chr_id(+) = chr.id and rg_LAREBL.id = r_LAREBL.rgp_id(+) and rg_LAREBL.rgd_code(+) = 'LAREBL' and r_LAREBL.rule_information_category(+) = 'LAREBL' and rg_LATOWN.chr_id(+) = chr.id and rg_LATOWN.dnz_chr_id(+) = chr.id and rg_LATOWN.id = r_LATOWN.rgp_id(+) and rg_LATOWN.rgd_code(+) = 'LATOWN' and r_LATOWN.rule_information_category(+) = 'LATOWN' and rg_LANNTF.chr_id(+) = chr.id and rg_LANNTF.dnz_chr_id(+) = chr.id and rg_LANNTF.id = r_LANNTF.rgp_id(+) and rg_LANNTF.rgd_code(+) = 'LANNTF' and r_LANNTF.rule_information_category(+) = 'LANNTF' and rg_LACPLN.chr_id(+) = chr.id and rg_LACPLN.dnz_chr_id(+) = chr.id and rg_LACPLN.id = r_LACPLN.rgp_id(+) and rg_LACPLN.rgd_code(+) = 'LACPLN' and r_LACPLN.rule_information_category(+) = 'LACPLN' and rg_LAPACT.chr_id(+) = chr.id and rg_LAPACT.dnz_chr_id(+) = chr.id and rg_LAPACT.id = r_LAPACT.rgp_id(+) and rg_LAPACT.rgd_code(+) = 'LAPACT' and r_LAPACT.rule_information_category(+) = 'LAPACT' and khr.pdt_id = ppv.id(+)

View Text - HTML Formatted

SELECT CHR.ID CHR_ID
, CHR.CONTRACT_NUMBER CHR_CONTRACT_NUMBER
, CHR.DESCRIPTION CHR_DESCRIPTION
, VERS.MAJOR_VERSION||'.'||VERS.MINOR_VERSION VERS_VERSION
, CHR.STS_CODE CHR_STS_CODE
, STSTL.MEANING CHR_STS_MEANING
, TO_CHAR(CHR.START_DATE) CHR_START_DATE
, TO_CHAR(CHR.END_DATE) CHR_END_DATE
, TO_CHAR(KHR.TERM_DURATION) KHR_TERM_DURATION
, CHR.CUST_PO_NUMBER CHR_CUST_PO_NUMBER
, CHR.INV_ORGANIZATION_ID CHR_INV_ORGANIZATION_ID
, CHR.AUTHORING_ORG_ID CHR_AUTHORING_ORG_ID
, KHR.GENERATE_ACCRUAL_YN KHR_GENERATE_ACCRUAL_YN
, KHR.SYNDICATABLE_YN KHR_SYNDICATABLE_YN
, KHR.PREFUNDING_ELIGIBLE_YN KHR_PREFUNDING_ELIGIBLE_YN
, KHR.REVOLVING_CREDIT_YN KHR_REVOLVING_CREDIT_YN
, KHR.CONVERTED_ACCOUNT_YN KHR_CONVERTED_ACCOUNT_YN
, KHR.CREDIT_ACT_YN KHR_CREDIT_ACT_YN
, CHR.TEMPLATE_YN CHR_TEMPLATE_YN
, TO_CHAR(CHR.DATE_SIGNED) CHR_DATE_SIGNED
, TO_CHAR(KHR.DATE_DEAL_TRANSFERRED) KHR_DATE_DEAL_TRANSFERRED
, TO_CHAR(KHR.ACCEPTED_DATE) KHR_ACCEPTED_DATE
, TO_CHAR(KHR.EXPECTED_DELIVERY_DATE) KHR_EXPECTED_DELIVERY_DATE
, KHR.AMD_CODE KHR_AMD_CODE
, KHR.DEAL_TYPE KHR_DEAL_TYPE
, CHR.ORIG_SYSTEM_REFERENCE1 CHR_ORIG_SYSTEM_REFERENCE1
, CHR.ORIG_SYSTEM_SOURCE_CODE CHR_ORIG_SYSTEM_SOURCE_CODE
, CHR.ORIG_SYSTEM_ID1 CHR_ORIG_SYSTEM_ID1
, TO_CHAR(NULL) MLA_CONTRACT_NUMBER
, TO_NUMBER(NULL) MLA_GVR_CHR_ID_REFERRED
, TO_NUMBER(NULL) MLA_GVR_ID
, CUST.ID CUST_ID
, CUST.OBJECT1_ID1 CUST_OBJECT1_ID1
, CUST.OBJECT1_ID2 CUST_OBJECT1_ID2
, CUST.JTOT_OBJECT1_CODE CUST_JTOT_OBJECT1_CODE
, 'CUST_NAME' CUST_NAME
, LESSOR.ID LESSOR_ID
, LESSOR.OBJECT1_ID1 LESSOR_OBJECT1_ID1
, LESSOR.OBJECT1_ID2 LESSOR_OBJECT1_ID2
, LESSOR.JTOT_OBJECT1_CODE LESSOR_JTOT_OBJECT1_CODE
, 'LESSOR_NAME' LESSOR_NAME
, CHR.CURRENCY_CODE CHR_CURRENCY_CODE
, CURRENCY.NAME CURRENCY_NAME
, KHR.CURRENCY_CONVERSION_TYPE KHR_CURRENCY_CONVERSION_TYPE
, TO_CHAR(KHR.CURRENCY_CONVERSION_RATE ) KHR_CURRENCY_CONVERSION_RATE
, TO_CHAR(KHR.CURRENCY_CONVERSION_DATE) KHR_CURRENCY_CONVERSION_DATE
, KHR.ASSIGNABLE_YN KHR_ASSIGNABLE_YN
, KHR.PDT_ID KHR_PDT_ID
, PRODUCT.NAME PRODUCT_NAME
, PRODUCT.DESCRIPTION PRODUCT_DESCRIPTION
, KHR.KHR_ID KHR_KHR_ID
, PROGRAM.CONTRACT_NUMBER PROGRAM_CONTRACT_NUMBER
, TO_CHAR(NULL) CL_CONTRACT_NUMBER
, TO_NUMBER(NULL) CL_GVR_CHR_ID_REFERRED
, TO_NUMBER(NULL) CL_GVR_ID
, BOOKS.SHORT_NAME BOOKS_SHORT_NAME
, BOOKS.LEDGER_ID BOOKS_SET_OF_BOOKS_ID
, OPER_UNITS.NAME OPER_UNITS_NAME
, /* CUST_SITE.DESCRIPTION CUST_SITE_DESCRIPTION
, */ ( SELECT ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL
, L.ADDRESS1
, L.ADDRESS2
, L.ADDRESS3
, L.ADDRESS4
, L.CITY
, L.COUNTY
, L.STATE
, L.PROVINCE
, L.POSTAL_CODE
, NULL
, L.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 300
, 1
, 1) DESCRIPTION
FROM HZ_PARTY_SITES HPS
, HZ_LOCATIONS L
, HZ_PARTY_SITE_USES HPSU
WHERE HPS.PARTY_ID = CUST.OBJECT1_ID1
AND HPS.STATUS = 'A'
AND HPSU.PARTY_SITE_ID = HPS.PARTY_SITE_ID
AND HPSU.SITE_USE_TYPE = 'LEGAL'
AND HPSU.PRIMARY_PER_TYPE = 'Y'
AND HPSU.STATUS = 'A'
AND L.LOCATION_ID = HPS.LOCATION_ID ) CUST_SITE_DESCRIPTION
, CONTACT.ID CONTACT_ID
, CONTACT.OBJECT1_ID1 CONTACT_OBJECT1_ID1
, CONTACT.OBJECT1_ID2 CONTACT_OBJECT1_ID2
, CONTACT.JTOT_OBJECT1_CODE CONTACT_JTOT_OBJECT1_CODE
, 'CONTACT_NAME' CONTACT_NAME
, RG_LARLES.ID RG_LARLES_ID
, R_LARLES.ID R_LARLES_ID
, R_LARLES.RULE_INFORMATION1 R_LARLES_RULE_INFORMATION1
, 'COL_LARLES_FORM_LEFT_PROMPT' COL_LARLES_FROM_LEFT_PROMPT
, RG_LAREBL.ID RG_LAREBL_ID
, R_LAREBL.ID R_LAREBL_ID
, R_LAREBL.RULE_INFORMATION1 R_LAREBL_RULE_INFORMATION1
, 'COL_LAREBL_FORM_LEFT_PROMPT' COL_LAREBL_FORM_LEFT_PROMPT
, 'CUSTOMER_ACCOUNT' CUSTOMER_ACCOUNT
, CHR.CUST_ACCT_ID CHR_CUST_ACCT_ID
, RG_LATOWN.ID RG_LATOWN_ID
, R_LATOWN.ID R_LATOWN_ID
, R_LATOWN.RULE_INFORMATION1 R_LATOWN_RULE_INFORMATION1
, 'COL_LATOWN_FORM_LEFT_PROMPT' COL_LATOWN_FORM_LEFT_PROMPT
, RG_LANNTF.ID RG_LANNTF_ID
, R_LANNTF.ID R_LANNTF_ID
, R_LANNTF.RULE_INFORMATION1 R_LANNTF_RULE_INFORMATION1
, 'COL_LANNTF_FORM_LEFT_PROMPT' COL_LANNTF_FORM_LEFT_PROMPT
, RG_LACPLN.ID RG_LACPLN_ID
, R_LACPLN.ID R_LACPLN_ID
, R_LACPLN.RULE_INFORMATION1 R_LACPLN_RULE_INFORMATION1
, 'COL_LACPLN_FORM_LEFT_PROMPT' COL_LACPLN_FORM_LEFT_PROMPT
, RG_LAPACT.ID RG_LAPACT_ID
, R_LAPACT.ID R_LAPACT_ID
, R_LAPACT.RULE_INFORMATION1 R_LAPACT_RULE_INFORMATION1
, 'COL_LAPACT_FORM_LEFT_PROMPT' COL_LAPACT_FORM_LEFT_PROMPT
, PPV.INTEREST_CALCULATION_BASIS INTEREST_CALCULATION_BASIS
, PPV.INTEREST_CALCULATION_MEANING INTEREST_CALCULATION_MEANING
, PPV.REVENUE_RECOGNITION_METHOD REVENUE_RECOGNITION_METHOD
, PPV.REVENUE_RECOGNITION_MEANING REVENUE_RECOGNITION_MEANING
, CHR.ORG_ID ORG_ID
, KHR.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
FROM OKC_K_HEADERS_V CHR
, OKL_K_HEADERS KHR
, OKC_K_PARTY_ROLES_V CUST
, OKC_K_PARTY_ROLES_V LESSOR
, OKC_CONTACTS_V CONTACT
, FND_CURRENCIES_VL CURRENCY
, OKC_STATUSES_B STS
, OKC_STATUSES_TL STSTL
, OKC_K_VERS_NUMBERS_V VERS
, OKL_PRODUCTS_V PRODUCT
, OKC_K_HEADERS_V PROGRAM
, GL_LEDGERS_PUBLIC_V BOOKS
, HR_OPERATING_UNITS OPER_UNITS
, OKL_SYS_ACCT_OPTS_ALL SAOB
, OKC_RULE_GROUPS_B RG_LARLES
, OKC_RULES_B R_LARLES
, OKC_RULE_GROUPS_B RG_LAREBL
, OKC_RULES_B R_LAREBL
, OKC_RULE_GROUPS_B RG_LATOWN
, OKC_RULES_B R_LATOWN
, OKC_RULE_GROUPS_B RG_LANNTF
, OKC_RULES_B R_LANNTF
, OKC_RULE_GROUPS_B RG_LACPLN
, OKC_RULES_B R_LACPLN
, OKC_RULE_GROUPS_B RG_LAPACT
, OKC_RULES_B R_LAPACT
, OKL_PRODUCT_PARAMETERS_V PPV
WHERE CHR.ID=KHR.ID
AND CURRENCY.CURRENCY_CODE = CHR.CURRENCY_CODE
AND STS.CODE = CHR.STS_CODE
AND STSTL.CODE = STS.CODE
AND STSTL.LANGUAGE = USERENV('LANG')
AND VERS.CHR_ID = CHR.ID
AND PRODUCT.ID (+) = KHR.PDT_ID
AND PROGRAM.ID (+) = KHR.KHR_ID
AND /*CUST_SITE.PARTY_ID(+) = CUST.OBJECT1_ID1
AND CUST_SITE.SITE_USE_CODE(+) = 'LEGAL' AND*/ CHR.ID=CUST.CHR_ID (+)
AND CHR.ID=CUST.DNZ_CHR_ID (+)
AND CUST.RLE_CODE(+) ='LESSEE'
AND CHR.ID=LESSOR.CHR_ID (+)
AND CHR.ID=LESSOR.DNZ_CHR_ID (+)
AND LESSOR.RLE_CODE(+) ='LESSOR'
AND LESSOR.ID = CONTACT.CPL_ID(+)
AND CONTACT.CRO_CODE (+) = 'SALESPERSON'
AND OPER_UNITS.ORGANIZATION_ID = CHR.AUTHORING_ORG_ID
AND BOOKS.LEDGER_ID = SAOB.SET_OF_BOOKS_ID
AND SAOB.ORG_ID = CHR.AUTHORING_ORG_ID
AND RG_LARLES.CHR_ID(+) = CHR.ID
AND RG_LARLES.DNZ_CHR_ID(+) = CHR.ID
AND RG_LARLES.ID = R_LARLES.RGP_ID(+)
AND RG_LARLES.RGD_CODE(+) = 'LARLES'
AND R_LARLES.RULE_INFORMATION_CATEGORY(+) = 'LARLES'
AND RG_LAREBL.CHR_ID(+) = CHR.ID
AND RG_LAREBL.DNZ_CHR_ID(+) = CHR.ID
AND RG_LAREBL.ID = R_LAREBL.RGP_ID(+)
AND RG_LAREBL.RGD_CODE(+) = 'LAREBL'
AND R_LAREBL.RULE_INFORMATION_CATEGORY(+) = 'LAREBL'
AND RG_LATOWN.CHR_ID(+) = CHR.ID
AND RG_LATOWN.DNZ_CHR_ID(+) = CHR.ID
AND RG_LATOWN.ID = R_LATOWN.RGP_ID(+)
AND RG_LATOWN.RGD_CODE(+) = 'LATOWN'
AND R_LATOWN.RULE_INFORMATION_CATEGORY(+) = 'LATOWN'
AND RG_LANNTF.CHR_ID(+) = CHR.ID
AND RG_LANNTF.DNZ_CHR_ID(+) = CHR.ID
AND RG_LANNTF.ID = R_LANNTF.RGP_ID(+)
AND RG_LANNTF.RGD_CODE(+) = 'LANNTF'
AND R_LANNTF.RULE_INFORMATION_CATEGORY(+) = 'LANNTF'
AND RG_LACPLN.CHR_ID(+) = CHR.ID
AND RG_LACPLN.DNZ_CHR_ID(+) = CHR.ID
AND RG_LACPLN.ID = R_LACPLN.RGP_ID(+)
AND RG_LACPLN.RGD_CODE(+) = 'LACPLN'
AND R_LACPLN.RULE_INFORMATION_CATEGORY(+) = 'LACPLN'
AND RG_LAPACT.CHR_ID(+) = CHR.ID
AND RG_LAPACT.DNZ_CHR_ID(+) = CHR.ID
AND RG_LAPACT.ID = R_LAPACT.RGP_ID(+)
AND RG_LAPACT.RGD_CODE(+) = 'LAPACT'
AND R_LAPACT.RULE_INFORMATION_CATEGORY(+) = 'LAPACT'
AND KHR.PDT_ID = PPV.ID(+)