select decode(ad_patch.is_patch_applied(:ebs_release, :appltop_id, :patch_num &lang),'EXPLICIT','APPLIED','NOT_APPLIED','NOT APPLIED') applied_check from dual |
select decode(ad_patch.is_patch_applied(:ebs_release, :appltop_id, :patch_num &lang),'EXPLICIT','APPLIED','NOT_APPLIED','NOT APPLIED') applied_check from dual
Parameter Name | SQL text | Validation | |
---|---|---|---|
EBS release version | Char | ||
Appl top id | Number | ||
Patch number | Number | ||
Patch language |
,:language | Char |
Blitz Report™ provides multiple benefits: