DBA Data[Home] [Help]

APPS.WIP_DIAG_DATA_COLL dependencies on FND_PROFILE_OPTION_VALUES

Line 5038: profile_val fnd_profile_option_values.profile_option_value%type ;

5034:
5035:
5036: procedure checkWipProfiles is
5037:
5038: profile_val fnd_profile_option_values.profile_option_value%type ;
5039:
5040: begin
5041:
5042: row_limit := 1000;

Line 5070: ' from fnd_profile_option_values fpov , '||

5066: /*
5067: sqltxt := 'select substr(fpo.user_profile_option_name, 1, 60) Profile ,decode(substr(fpov.profile_option_value, 1, 52), ''1'', ''Yes'', ''2'', ''No'', substr(fpov.profile_option_value,1, 52)) Value, '||
5068:
5069: ' decode(fpov.level_id, 10001, ''Site'', 10002, ''Appl'', 10003, ''Resp'', 10004, ''User'', ''None'') lvl '||
5070: ' from fnd_profile_option_values fpov , '||
5071: ' fnd_profile_options_vl fpo ' ||
5072: ' where fpo.application_id = fpov.application_id ' ||
5073: ' and fpo.profile_option_id = fpov.profile_option_id ' ||
5074: ' and (fpov.application_id = 706 '||