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