Fusion Development: A Database-Centric Approach

Create a View

uViews placed on top of dynamic functions:

ØCompletely hide the logic from the UI

ØINSTEAD-OF triggers make logic bi-directional.

ØMinor problem – There is still no way of passing parameters into the view other than by using some type of global.

Create or replace view v_generic_lov as

select id_nr, display_tx

from table( cast(f_getLov_nt

(GV_pkg.f_getCurTable,

GV_pkg.f_getPK(GV_pkg.f_getCurTable),

GV_pkg.f_getDSP(GV_pkg.f_getCurTable),

GV_pkg.f_getSORT(GV_pkg.f_getCurTable))

as lov_nt)

)