Registering a View

Registering View

BEGIN

  fnd_dictionary_pkg.UploadView ('schemaname','ViewName','Description','Description',1);

  COMMIT;

END;

Registering column

BEGIN

  fnd_dictionary_pkg.UploadViewColumn ('schemaname','ViewName','COLUMN1'          , 1,1);

  fnd_dictionary_pkg.UploadViewColumn ('schemaname','ViewName','COLUMN2'          , 2,1);

END;

Removing view

begin

fnd_dictionary_pkg.RemoveView(  'schemaname', 'ViewName');

COMMIT;

END;