最初由 amwlq 发布
[B]这个是视图吧,是基于表:fnd_lookup_values [/B]
说的是。是基于fnd_lookup_values的一个视图。用Toad看一下,很明显的。如下:
CREATE OR REPLACE VIEW gl_lookups (lookup_type,
lookup_code,
meaning,
description,
enabled_flag,
start_date_active,
end_date_active
)
AS
SELECT lookup_type lookup_type, lookup_code lookup_code, meaning meaning,
description description, enabled_flag enabled_flag,
start_date_active start_date_active,
end_date_active end_date_active
FROM fnd_lookup_values lv
WHERE LANGUAGE = USERENV ('LANG')
AND view_application_id = 101
AND security_group_id = 0; |