摘要:
SELECT OP.PROFILE_OPTION_ID, TL.PROFILE_OPTION_NAME, TL.USER_PROFILE_OPTION_NAME, LV.LEVEL_ID, LV.文件安全性, VA.LEVEL_VALUE, CASE WHEN VA.LEVEL_ID = 10001 阅读全文
摘要:
DECLARE l_ccid NUMBER; l_msg VARCHAR2(1000); l_chart_of_account_id NUMBER; l_set_of_book_id NUMBER; BEGIN l_set_of_book_id := fnd_profile.value('GL_SET_OF_BKS_ID'); SELECT gsob.chart_... 阅读全文
摘要:
此责任无可用函数(The Function Is Not Available Under The Responsibility) When attempting to navigate to a function which has been newly added to a menu the fo 阅读全文
摘要:
SELECT ba.bank_account_id, --银行账户key ftv.territory_short_name, --国家 ftv.territory_code, --国家简称 cb.bank_name, ---银行名称 cbb.bank_branch_name, ---分行名称 hp.party_name, --... 阅读全文
摘要:
merge语法是根据源表对目标表进行匹配查询,匹配成功时更新,不成功时插入。 其基本语法规则是 merge into 目标表 a using 源表 b on(a.条件字段1=b.条件字段1 and a.条件字段2=b.条件字段2 ……) when matched then update set a. 阅读全文
摘要:
1] FND_FLEX_EXT.GET_COMBINATION_ID: This API Finds combination_id for given set of key flexfield segment values. Segment values must be input in segme 阅读全文
摘要:
参考 http://blog.csdn.net/pan_tian/article/details/7652968#t0 Using API FND_PROFILE.save to update profile from backend 参考 http://blog.csdn.net/pan_tian 阅读全文
该文被密码保护。 阅读全文
摘要:
declare g_commit_count number; cursor cu1 is select gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id, 1, --1 ... 阅读全文
摘要:
SELECT l_count, REGEXP_SUBSTR('add, daddf, dsdf, asdfa, dsfasd, dsfad','[^,]+',1,l_count) AS NAME FROM dual ,(SELECT LEVEL l_count FROM DUAL CONNECT B 阅读全文