function FND_REQUEST.SUBMIT_REQUEST
(application IN varchar2 default NULL, --
program IN varchar2 default NULL,
description IN varchar2 default NULL,
start_time IN varchar2 default NULL,
sub_request IN boolean default FALSE
argument1,
argument2, ..., argument99,
argument100) return number;


这里面的application
Short name of the application associated with the
concurrent request to be submitted.

比如purchasing 是po

inventory 是inv

其实有很简单的方法，就是LINUX/UNIX目录的名字
但是如果我不知道，该如何通过表来查？

method1 :

system administrator -> application-> register

method2:

select fapp.application_short_name,fapptl.application_name, fapp.*
from fnd_application fapp,
FND_APPLICATION_TL fapptl
where
-- fapp.application_short_name='XXSAT'
fapptl.application_name='Purchasing'
and fapp.application_id=fapptl.application_id
and fapptl.LANGUAGE='US'

Reference:

--查看当前系统应用的模块

SELECT fnd_application.application_short_name,
fnd_application.application_id,
fnd_product_installations.status
FROM fnd_application,fnd_product_installations
WHERE fnd_application.application_id =
fnd_product_installations.application_id;

-- 检查某个模块的安装状态 (S代表共享安装 I 代表完全安装 n 代表没有安装
select fpi.application_id, fou.install_group_num,fk.application_short_name
from fnd_product_installations fpi,fnd_oracle_userid fou ,fnd_application fk
where fpi.oracle_id=fou.oracle_id and fpi.application_id=fk.application_id
and fpi.application_id <> 1
order by 1;

FND_USER：用户表
USER_ID：用户ID
EMPLOYEE_ID：雇员ID(取自HR处的雇员设置)

FND_APPLICATION：应用表
APPLICATION_ID：应用ID
APPLICATION_SHORT_NAME：应用ShortName
BASEPATH：应用TOP变量值
FND_APPLICATION_TL：应用语言表
APPLICATION_ID：应用ID
LANGUAGE：语言
APPLICATION_NAME：应用名
DESCRIPTION：应用描述

FND_PROFILE_OPTIONS：参数表
PROFILE_OPTION_ID：参数ID
PROFILE_OPTION_NAME：参数名
APPLICATION_ID：应用ID
FND_PROFILE_OPTIONS_TL：参数语言表
PROFILE_OPTION_NAME：参数名
LANGUAGE：语言
USER_PROFILE_OPTION_NAME：用户参数名
DESCRIPTION：参数描述
FND_PROFILE_OPTIONS_VL：参数表视图
LANGUAGE = USERENV('LANG')

FND_PROFILE_OPTION_VALUES：参数值表
PROFILE_OPTION_ID：参数ID
LEVEL_ID：层级（10001:Site 10002:Application 10003:Responsibility 10004:User）
LEVEL_VALUE：层级成员
PROFILE_OPTION_VALUE：参数值
APPLICATION_ID：应用ID