VIEW: APPS.OKS_PM_PROGRAM_V

Source

View Text - Preformatted

SELECT rules.rowid row_id, rules.id program_rule_id , rules.object_version_number object_version_number, rules.rule_information1 confirmation_required, rules.rule_information2 schedule_exists, rules.object1_id1 program_id1, rules.object1_id2 program_id2, rgp.cle_id cle_id, rgp.dnz_chr_id dnz_chr_id, rules.created_by created_by , rules.creation_date creation_date , rules.last_updated_by last_updated_by , rules.last_update_date last_update_date , rules.last_update_login last_update_login FROM okc_rule_groups_b rgp , okc_rules_b rules WHERE rgp.rgd_code = 'SVC_K' and rules.rgp_id = rgp.id and rules.rule_information_category = 'PMP'

View Text - HTML Formatted

SELECT RULES.ROWID ROW_ID
, RULES.ID PROGRAM_RULE_ID
, RULES.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RULES.RULE_INFORMATION1 CONFIRMATION_REQUIRED
, RULES.RULE_INFORMATION2 SCHEDULE_EXISTS
, RULES.OBJECT1_ID1 PROGRAM_ID1
, RULES.OBJECT1_ID2 PROGRAM_ID2
, RGP.CLE_ID CLE_ID
, RGP.DNZ_CHR_ID DNZ_CHR_ID
, RULES.CREATED_BY CREATED_BY
, RULES.CREATION_DATE CREATION_DATE
, RULES.LAST_UPDATED_BY LAST_UPDATED_BY
, RULES.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RULES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_RULE_GROUPS_B RGP
, OKC_RULES_B RULES
WHERE RGP.RGD_CODE = 'SVC_K'
AND RULES.RGP_ID = RGP.ID
AND RULES.RULE_INFORMATION_CATEGORY = 'PMP'