2018年8月16日

用户职责查询

摘要： select fu.user_name, ppf.FULL_NAME, fr.RESPONSIBILITY_NAME, fur.START_DATE, fur.END_DATE from fnd_user fu, per_people_f ppf,... 阅读全文

posted @ 2018-08-16 14:47 lizicheng 阅读(145) 评论(0) 推荐(0)

用户职责请求组查询

摘要： select fu.user_name, ppf.FULL_NAME, fr.RESPONSIBILITY_NAME, fur.START_DATE, fur.END_DATE, fcp.CONCURRENT_PROGRAM_NAME, fcp.USER_CONCURRENT_PROGRAM_NAM... 阅读全文

posted @ 2018-08-16 14:47 lizicheng 阅读(154) 评论(0) 推荐(0)

AP相关表

摘要： --select * from fnd_user t where t.user_name like '%&user_name%';--17022 --应付模块表 select * from ap_invoices_all t where t.created_by=17022; select * from ap_invoice_lines_all t where t.created_by=1702... 阅读全文

posted @ 2018-08-16 13:37 lizicheng 阅读(303) 评论(0) 推荐(0)

将批次成本创建最终会计科目恢复到拟定

摘要： /* +=======================================================================+ * Undo/Reset OPM Costed Flags * +==================================================================... 阅读全文

posted @ 2018-08-16 10:07 lizicheng 阅读(1171) 评论(0) 推荐(0)

导航