select
a.MENU_CODE
, a.MENU_NAME as "CARD_TITLE"
, dbms_lob.getlength(IMG) as "CARD_TEXT"
,'<a href="f?p=' ||APPP_ID||':'||PAGGE_ID||':'||:APP_SESSION|| '">"Go to Apps"</a>' as "CARD_SUBTEXT"
from strerp_user_menu_info a, strerp_user_menu_detail b
where a.MENU_CODE=b.MENU_CODE
and b.EMP_ID=:APP_USER
and b.END_DT is null
and b.STATUS='E'
order by MENU_CODE
Subscribe to:
Post Comments (Atom)
-
# Report Column (only column): 1. Column Formatting > HTML Expression <span style="display:block; width: 200px"> #...
-
Installing Oracle Forms and Reports 12c on Windows 10 64 Bit. Hardware used for this installation is · Intel i3-2370M CPU · ... -
when open forms builder then errors FRM-91129: fatal error: no value specified for required environment variable FORMS_BUILDER_CLASSPATH a...
-
---------------------------- | Keyboard Shortcut | ---------------------------- · Create: Breadcrumb Region Ctrl+/, C, B · ...
No comments:
Post a Comment