随笔分类 -  EBS - 常用查询SQL

摘要：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 阅读全文

摘要：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 阅读全文