Follow us: Subscribe via RSS Feed Connect on YouTube Connect on YouTube

Pages

Tuesday, 21 June 2016

Query to get Oracle form Details



SELECT
  CASE
    WHEN row_number() over(PARTITION BY app.application_name ORDER BY frm.form_name nulls LAST) = 1
    THEN app.application_name
    ELSE NULL
  END "Application Name" ,
  app.basepath
  || '/forms/US/'
  || frm.form_name
  || '.fmb' href ,
  frm.form_name "Form Code" ,
  frm.user_form_name "Form Name" ,
  frm.description xonly_description ,
  frm.form_id xonly_form_id ,
  usr1.user_name "Created By" ,
  frm.creation_date "Creation Date" ,
  usr2.user_name "Last Updated By" ,
  frm.last_update_date "Last Update Date" ,
  'cp $'
  || app.basepath
  || '/forms/US/'
  || frm.form_name
  || '.fmb ./'
  || app.basepath
  || '/forms/US 2>/dev/null' build_command
FROM fnd_form_vl frm ,
  fnd_application_vl app ,
  fnd_user usr1 ,
  fnd_user usr2
WHERE --(frm.created_by        NOT IN (0,1,2,120,121,122,123,124,125,126,127,128,129)
  ---OR frm.form_name LIKE 'XX%')
  frm.application_id    = app.application_id
AND frm.created_by      = usr1.user_id
AND frm.last_updated_by = usr2.user_id
ORDER BY app.application_name ,
  frm.form_name
Share this article :

0 comments:

Post a Comment