摘要： SELECT pro.profile_option_name, pro.user_profile_option_name, lev.level_type TYPE, --lev.level_code, lev.level_name, prv.profile_option_value FROM apps.fnd_profile_options_vl pro, applsys.fnd_profile_option_values prv, (SELECT 10001 level_id, 'Site' level_type, 0 level_value, 'Site' level_code, 'Sit 阅读全文

摘要： --报表所属职责SELECT FCPT.USER_CONCURRENT_PROGRAM_NAME, FRG.REQUEST_GROUP_NAME, FR.RESPONSIBILITY_KEYFROM FND_CONCURRENT_PROGRAMS_TL FCPT, FND_REQUEST_GROUP_UNITS FRGU, FND_REQUEST_GROUPS FRG, FND_RESPONSIBILITY FRWHERE FCPT.CONCURRENT_PROGRAM_ID = FRGU.REQUEST_UNIT_ID AND FRGU.REQUEST_GROUP_ID = FRG.REQU 阅读全文

摘要： 系统界面异常无法导出的时候,考虑下系统表空间是否不能扩展了.查询表空间脚本如下: select upper(f.tablespace_name) "表空间名", d.tot_grootte_mb "表空间大小(M)", d.tot_grootte_mb - f.total_bytes "已使用空间(M)", to_char(round((d.tot_grootte_mb - f.total_byt... 阅读全文

摘要： ERP系统里的BOM展开函数:l_grp_id NUMBER ;l_session_id NUMBER ;l_org_id NUMBER ;l_levels_to_explode NUMBER:=10 ;l_module NUMBERDEFAULT 2 ; -- BOM = 2l_cst_type_id NUMBERDEFAULT -1 ; -- All cost = -1 else 0l_item_id NUMBER ;l_bom_or_eng NUMBER ;l_using_req_quantity NUMBER ;l_using_ass_dem_date DATE ;l_rev_da 阅读全文

摘要： 1.创建cux用户SQL> conn / as sysdba;Connected.SQL> create tablespace APPS_NTK_CUX datafile '/ebs/proddata/apps_st/data/cuxd01.dbf'size 50m autoextend on next 1m;Tablespace created.SQL> create user... 阅读全文