query to check grant on view/table in oracle

SELECT   owner
       , grantee
       , table_name
       , select_priv
       , insert_priv
       , delete_priv
       , update_priv
       , references_priv
       , alter_priv
       , index_priv
    FROM table_privileges
   WHERE table_name = 'SSS_TEMP'
ORDER BY owner
       , table_name;

Script to set Profile Option Value for Site from backend

DECLARE
   v_profile1                     BOOLEAN;
BEGIN
   v_profile1 :=
      fnd_profile.SAVE ('OKS_ITEM_DISPLAY_PREFERENCE'
  , 'DISPLAY_NAME'
                      , 'SITE'
                       );
   COMMIT;
EXCEPTION
   WHEN OTHERS
   THEN
      fnd_file.put_line (fnd_file.LOG, 'Exception : '
                          || SQLERRM);
END;
/

Query to Find Profile Option Values

SELECT fpo.profile_option_name SHORT_NAME,
         fpot.user_profile_option_name NAME,
         DECODE (fpov.level_id,
                 10001, 'Site',
                 10002, 'Application',
                 10003, 'Responsibility',
                 10004, 'User',
                 10005, 'Server',
                 'UnDef')
            LEVEL_SET,
         DECODE (TO_CHAR (fpov.level_id),
                 '10001', '',
                 '10002', fap.application_short_name,
                 '10003', frsp.responsibility_key,
                 '10005', fnod.node_name,
                 '10006', hou.name,
                 '10004', fu.user_name,
                 'UnDef')
            "CONTEXT",
         fpov.profile_option_value VALUE
    FROM fnd_profile_options fpo,
         fnd_profile_option_values fpov,
         fnd_profile_options_tl fpot,
         fnd_user fu,
         fnd_application fap,
         fnd_responsibility frsp,
         fnd_nodes fnod,
         hr_operating_units hou
   WHERE     fpo.profile_option_id = fpov.profile_option_id(+)
         AND fpo.profile_option_name = fpot.profile_option_name
         AND fu.user_id(+) = fpov.level_value
         AND frsp.application_id(+) = fpov.level_value_application_id
         AND frsp.responsibility_id(+) = fpov.level_value
         AND fap.application_id(+) = fpov.level_value
         AND fnod.node_id(+) = fpov.level_value
         AND hou.organization_id(+) = fpov.level_value
         AND fpot.user_profile_option_name = :profile_option_name
ORDER BY short_name;

FNDLOAD Script for Lookup

--Download
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XXXX_BENEFIT_DATE.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXXX" LOOKUP_TYPE="XXXX_BENEFIT_DATE"

--Upload

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XXXX_BENEFIT_DATE.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE