VIEW: APPS.OKS_PML_V

Source

View Text - Preformatted

SELECT rul.rowid row_id, rul.object_version_number object_version_number, rul.id pml_rule_id, rul.rule_information1 seq_no, rul.rule_information2 periods, to_date(rul.rule_information3,'YYYY/MM/DD') start_date, to_date(rul.rule_information4,'YYYY/MM/DD') end_date, rul.rule_information5 uom_period, rul.rule_information6 uom_code, rul.rule_information7 offset_period, rul.rule_information8 offset_uom_code, rul.rule_information9 auto_schedule, rul.object1_id1 pmp_rule_id, rul.object1_id2 pmp_rule_id2, rul.jtot_object1_code object1_code, rul.object2_id1 pma_rule_id , rul.object2_id2 pma_rule_id2, rul.jtot_object2_code object2_code, rgp.cle_id cle_id, rgp.dnz_chr_id dnz_chr_id, rul.created_by created_by , rul.creation_date creation_date , rul.last_updated_by last_updated_by , rul.last_update_date last_update_date , rul.last_update_login last_update_login FROM okc_rule_groups_b rgp , okc_rules_b rul WHERE rgp.rgd_code = 'SVC_K' and rul.rgp_id = rgp.id and rul.rule_information_category = 'PML'

View Text - HTML Formatted

SELECT RUL.ROWID ROW_ID
, RUL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RUL.ID PML_RULE_ID
, RUL.RULE_INFORMATION1 SEQ_NO
, RUL.RULE_INFORMATION2 PERIODS
, TO_DATE(RUL.RULE_INFORMATION3
, 'YYYY/MM/DD') START_DATE
, TO_DATE(RUL.RULE_INFORMATION4
, 'YYYY/MM/DD') END_DATE
, RUL.RULE_INFORMATION5 UOM_PERIOD
, RUL.RULE_INFORMATION6 UOM_CODE
, RUL.RULE_INFORMATION7 OFFSET_PERIOD
, RUL.RULE_INFORMATION8 OFFSET_UOM_CODE
, RUL.RULE_INFORMATION9 AUTO_SCHEDULE
, RUL.OBJECT1_ID1 PMP_RULE_ID
, RUL.OBJECT1_ID2 PMP_RULE_ID2
, RUL.JTOT_OBJECT1_CODE OBJECT1_CODE
, RUL.OBJECT2_ID1 PMA_RULE_ID
, RUL.OBJECT2_ID2 PMA_RULE_ID2
, RUL.JTOT_OBJECT2_CODE OBJECT2_CODE
, RGP.CLE_ID CLE_ID
, RGP.DNZ_CHR_ID DNZ_CHR_ID
, RUL.CREATED_BY CREATED_BY
, RUL.CREATION_DATE CREATION_DATE
, RUL.LAST_UPDATED_BY LAST_UPDATED_BY
, RUL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RUL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_RULE_GROUPS_B RGP
, OKC_RULES_B RUL
WHERE RGP.RGD_CODE = 'SVC_K'
AND RUL.RGP_ID = RGP.ID
AND RUL.RULE_INFORMATION_CATEGORY = 'PML'