APPS.BIS_VG_REPOSITORY_MEDIATOR dependencies on USER_VIEWS

Line 47: := 'SELECT TEXT FROM USER_VIEWS WHERE VIEW_NAME = ';

43: )
44: IS
45:
46: l_statement VARCHAR2(100)
47: := 'SELECT TEXT FROM USER_VIEWS WHERE VIEW_NAME = ';
48: l_dummy NUMBER;
49: --
50: BEGIN
51:

Line 499: FROM user_views

495: CURSOR c_field_views(p_like_str IN VARCHAR2) IS
496: select
497: view_name
498: , text_length
499: FROM user_views
500: WHERE
501: (
502: view_name LIKE '__BV\_%' escape '\'
503: OR view_name LIKE '__FV\_%' escape '\'

Line 768: FROM user_views

764: CURSOR C_all_views IS
765: select
766: view_name
767: , text_length
768: FROM user_views
769: WHERE view_name = Upper(p_view_name);
770: l_view_rec bis_vg_types.view_table_rec_type;
771: BEGIN
772: BIS_DEBUG_PUB.Add('> retrieve_Business_Views_view_name');

Line 832: FROM user_views

828: CURSOR c_all_views(p_app_abbrev IN VARCHAR2) IS
829: select
830: view_name
831: , text_length
832: FROM user_views
833: WHERE view_name LIKE Upper(p_app_abbrev)||'BV\_%' escape '\'
834: OR view_name LIKE Upper(p_app_abbrev)||'FV\_%' escape '\';
835: -- Handle PER(HR) product views as a special case
836: CURSOR c_hr_views is

Line 840: FROM user_views

836: CURSOR c_hr_views is
837: select
838: view_name
839: , text_length
840: FROM user_views
841: WHERE view_name LIKE 'HR'||'BV\_%' escape '\'
842: OR view_name LIKE 'HR'||'FV\_%' escape '\'
843: OR view_name LIKE 'IRC'||'BV\_%' escape '\'
844: OR view_name LIKE 'IRC'||'FV\_%' escape '\';

Line 979: FROM user_views

975: CURSOR C_all_views IS
976: select
977: view_name
978: , text_length
979: FROM user_views
980: WHERE view_name LIKE '__BV\_%' escape '\'
981: OR view_name LIKE '__FV\_%' escape '\'
982: OR view_name LIKE '___BV\_%' escape '\'
983: OR view_name LIKE '___FV\_%' escape '\';