•fnd_profile.value('USER_ID') •fnd_profile.value('USERNAME') •fnd_profile.value('CONCURRENT_REQUEST_ID') •fnd_profile.value('GL_SET_OF_BKS_ID') •fnd_profile.value('ORG_ID') •fnd_profile.value('SO_ORGANIZATION_ID') •fnd_profile.value('APPL_SHRT_NAME') •fnd_prof...
The print style. of your concurrent program’soutput that you enter in the Print Style. field whenyou register a concurrent program. You can usethe routine afpoput() from your concurrentprograms to change the value of this profile option 5.扩展 取得当前user_id FND_PROFILE.VALUE('USER_ID')...
由于用户层的值可以覆盖责任层的值,当operations用户以order Management user,..责任登录系统是,Form中取到的值是:Vision ADB; 三、程序中获取User profile值: 在程序中可以使用fnd_profile.value('ORG_ID')来获取ORG_ID这个user profile的值;有关用户配置文件的详细概念和API,请参考120devg.pdf第249页。
3、fnd_global.APPS_INITIALIZE(1318,50583,401)select fnd_profile.VALUE(ORG_ID) FROM DUALselect * from hr_operating_units hou where anization_id=204用户、责任及HR-系统责任定义VIEW(FROM FND_RESPONSIBILITY_TL, FND_RESPONSIBILITY)SELECT APPLICATION_ID, RESPONSIBILITY_ID, RESPONSIBILITY_KEY, END_DATE,...
fpov.profile_option_value system_profile_option_value, fpo.profile_option_name system_profile_option_name, fpo.profile_option_id, fpov.level_value, fpov.level_value2 from fnd_application_vl fav0, fnd_profile_options_vl fpo, fnd_profile_option_values fpov, fnd_responsibility_vl frv, fnd_...
select fnd_profile.VALUE('ORG_ID') FROM DUAL select * from hr_operating_units hou where hou.organization_id=204 --fnd select * from fnd_application select * from fnd_application_tl where application_id=101 select * from fnd_application_vl where application_id = 101 ...
v.profile_option_value VALUE from fnd_profile_options p, fnd_profile_option_values v, fnd_profile_options_tl n, fnd_user usr, fnd_application app, fnd_responsibility rsp, fnd_nodes svr, hr_operating_units org where p.profile_option_id = v.profile_option_id (+) ...
WHERE NODE_ID = FPOV.LEVEL_VALUE2), (SELECT NODE_NAME FROM FND_NODES WHERE NODE_ID = FPOV.LEVEL_VALUE2) || '-' || RSP.RESPONSIBILITY_KEY)), 'UnDef') "CONTEXT", FPOV.PROFILE_OPTION_VALUE, FPOT.DESCRIPTION FROM FND_PROFILE_OPTIONS_TL FPOT, ...
select fnd_profile.VALUE( 'ORG_ID' ) FROM DUAL select * from hr_operating_units hou where hou.organization_id= 204 2. 用户、责任及 HR-- 系统责任定义 VIEW(FROM FND_RESPONSIBILITY_TL, FND_RESPONSIBILITY) SELECT APPLICATION_ID, RESPONSIBILITY_ID, ...
ANDoa.responsibility_id=fnd_profile.VALUE(RESP_ID) 创建ViewObjects:CheckTypeLOVVO 该VO用于LOV。在hand.oracle.apps.cux.mfg.lov.server下创建。 Name: CheckTypeLOVVO 一直Next,直接输入SQL: SELECTlov.lookup_codecheck_type_code,lov.meaningcheck_type_meaning ...