VIEW: APPS.OKL_KHR_TNC_RVI_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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