Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_KHR_TNC_RVI_UV |
SELECT RGP.DNZ_CHR_ID
, TO_NUMBER(NULL) LINE_ID
, RGP.ID RGP_ID
, RGP.RGD_CODE
, RGP.ID RGP_LARVIN_LARVAU_ID
, RGP.ID RGP_LARVIN_LARVAM_ID
, RUL_LARVAU.ID RUL_LARVAU_ID
, RUL_LARVAU.RULE_INFORMATION_CATEGORY LARVAU_RULE_INFO_CAT
, RUL_LARVAM.ID RUL_LARVAM_ID
, RUL_LARVAM.RULE_INFORMATION_CATEGORY LARVAM_RULE_INFO_CAT
, RUL_LARVAU.RULE_INFORMATION1 LARVAU_RULE_INFORMATION1
, RUL_LARVAM.RULE_INFORMATION4 LARVAM_RULE_INFORMATRION4
, TO_NUMBER(NULL) ITEM_ID1
, TO_CHAR(NULL) ITEM_NAME
FROM OKC_RULES_B RUL_LARVAU
, OKC_RULES_B RUL_LARVAM
, OKC_RULE_GROUPS_B RGP
WHERE RGP.DNZ_CHR_ID = RGP.CHR_ID
AND RGP.RGD_CODE = 'LARVIN'
AND RUL_LARVAU.RGP_ID = RGP.ID
AND RUL_LARVAU.DNZ_CHR_ID = RGP.DNZ_CHR_ID
AND RUL_LARVAU.RULE_INFORMATION_CATEGORY = 'LARVAU'
AND RUL_LARVAM.RGP_ID = RGP.ID
AND RUL_LARVAM.RULE_INFORMATION_CATEGORY = 'LARVAM'
AND RUL_LARVAM.DNZ_CHR_ID = RGP.DNZ_CHR_ID