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

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

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

摘要： New_Ccid := Fnd_Flex_Ext.Get_Ccid(Application_Short_Name => 'SQLGL' ,Key_Flex_Code => 'GL#' ,Structure_Number => Coa_Id ,Validation_Date => NULL ,Conc 阅读全文

摘要： Sub 批量替换WORD内容()Dim wd As New Word.Applicationpa = ThisWorkbook.Path & "\111.docx"With wd.Documents.Open pa.Visible = False For i = 2 To Cells(65535, 阅读全文

摘要： update gl_je_batches t set t.approval_status_code='R'--要求审批 where T.JE_BATCH_ID=1155764; update gl_je_batches t set t.approval_status_code='I'--处理中 where T.JE_BATCH_ID=1155764; update gl_je_batches... 阅读全文

摘要： fnd_profile_option_valuesfnd_profile_options_vl 阅读全文

摘要： 阅读全文

摘要： select fa.APPLICATION_ID 应用ID, fa.APPLICATION_SHORT_NAME 应用代码, fa.APPLICATION_NAME 应用名称, fr.RESPONSIBILITY_ID 职责ID, fr.RESPONSIBILITY_KEY 职责关键字, ... 阅读全文

摘要： Select Ffcr.Function_Name, Ffcr.Description, Ffcr.Trigger_Event, Ffcr.Trigger_Object, Ffcr.Condition, Ffcr.Enabled, Ffca.Sequence, Decode(Ffca.... 阅读全文

摘要： ALTER TABLE CUX_JBJT5_COA_MAPPING add remarks VARCHAR2(260);--增加字段 ALTER TABLE CUX_JBJT5_COA_MAPPING RENAME COLUMN remark TO remarks; --重命名字段 ALTER TA 阅读全文

摘要： select * from PO_REQUISITIONS_INTERFACE_ALL;--请购接口表 select * from PO_REQUISITION_HEADERS_ALL;--请购单头信息 select * from PO_REQUISITION_LINES_ALL;--请购单行信息 select * from PO_REQ_DISTRIBUTIONS_ALL;--请购单分配信息 ... 阅读全文

摘要： select * from fnd_id_flex_structures_vl t where t.APPLICATION_ID=140;--CATEGORY_FLEXFIELD select t.FLEX_VALUE_SET_ID,t.FORM_LEFT_PROMPT from fnd_id_flex_segments_vl t where t.ID_FLEX_CODE='CAT#'; sel... 阅读全文

摘要： --按日记账头ID追溯子分类帐日记帐行（汇总） select t.ae_line_num, sum(t.accounted_dr) dr, sum(t.accounted_cr) cr from xla_ae_lines t where exists (select 1 from gl_import_references gir where gir.... 阅读全文

摘要： 日记帐：允许多种汇率 阅读全文