摘要： select msi.segment1, msi.description, msi.item_typefrom inv.mtl_system_items_b msiwhere msi.organization_id =X and msi.item_type in ('SA','FG') --成品、子... 阅读全文

摘要： select msi.segment1 装配件编码 , msi.description 装配件描述 , msi.item_type 类型 , msi.planner_code 计划员 , msi1.segment1 部件编码 ,msi1.description 部件描述 , msi1.primary... 阅读全文

摘要： select DISTINCT msi.segment1成品编码 ,msi.description 成品描述 ,msi.item_type 物料类型,msi.inventory_item_status_code 状态 ,msi.build_in_wip_flag 允许制造from INV.MTL_S... 阅读全文

摘要： selectFU.description 创建者,msi.CREATION_DATE建立时间,msi.segment1 物料编码,msi.DESCRIPTION 物料描述,msi.INVENTORY_ITEM_STATUS_CODE 物料状态,DECODE(MSI.MRP_PLANNING_CO... 阅读全文

摘要： --本周系统BOM汇总记录SELECT ITM.SEGMENT1 物料编码, ITM.DESCRIPTION 物料描述, bom2.CREATION_DATE 创建日期, BOM2.ALTERNATE_BOM_DESIGNATOR 替代项, FU.description操作者FROM INV.MTL... 阅读全文

摘要： Select MSI1.Segment1 上层编码, MSI1.Description 上层描述, MSI2.Segment1 下层编码, MSI2.Description 下层描述, MSI2.PRIMARY_UOM_CODE 计量单位, BIC.COMPONENT_QUANTITY 装配定额, ... 阅读全文

摘要： --检查供应类型错误SELECT MSI.SEGMENT1 物料编码, MSI.DESCRIPTION 物料描述, DECODE(MSI.WIP_SUPPLY_TYPE,'6','虚拟项','1','推式' ,'2','装配拉式','3','工序拉式') 供应类型, MSI.WIP_SUPPLY_... 阅读全文

摘要： SELECT cust.customer_number, cust.customer_name, cash.receipt_number, gcc.segment1 || '.' || gcc.segment2 || '.' || gcc.segment3 || '.' || gcc.segmen... 阅读全文

摘要： SELECT SUM(nvl(dist.amount_dr,0))-SUM(nvl(dist.amount_cr,0)) FROM ar_cash_receipt_history_all hist, ar_distributions_all distWHERE hist.cash_receipt_h... 阅读全文

摘要： SELECT destination_type_code, distribution_line_number, line_type, amount,vat_code, tax_code_id, tax_code_override_flag, tax_recovery_rate,tax_recover... 阅读全文

摘要： SELECT row_id, creation_date, created_by, last_update_date, last_updated_by,last_update_login, note_to_receiver, pll_note_to_receiver,rma_reference, t... 阅读全文

摘要： SELECT je_header_id, je_line_num, trx_class_name, trx_type_name, trx_number_displayed, trx_date,comments, doc_sequence_name, doc_sequence_value, acct_... 阅读全文

摘要： SELECT je_header_id,je_line_num,trx_class_name, trx_type_name, trx_number_displayed, trx_date,comments, doc_sequence_name, doc_sequence_value,acct_lin... 阅读全文

摘要： SELECT je_header_id, je_line_num, trx_class_name, trx_type_name, trx_number_displayed, trx_date,comments, doc_sequence_name, doc_sequence_value, acct_... 阅读全文

摘要： SELECT STATUS, PERIOD_NAME, PERIOD_NUMBER, PERIOD_YEAR, START_DATE, END_DATE, CLOSE_DATE, REC_TYPE, ORGANIZATION_IDFROM ORG_ACCT_PERIODS_V WHERE ((rec... 阅读全文

摘要： select inventory_location_id, organization_id,description, subinventory_code, segment1 inventory_location_code from MTL_ITEM_LOCATIONSorder by subinve... 阅读全文

摘要： select B.application_name, TL.responsibility_name from fnd_responsibility_tl tl, fnd_responsibility a, fnd_application_tl B, fnd_application Cwhere a.... 阅读全文

摘要： select b.user_name, b.description, b.creation_date, d.responsibility_name from fnd_user b, fnd_user_resp_groups c, fnd_responsibility_tl d where b.... 阅读全文

摘要： select fu.user_name 用户名, fu.description 用户说明, frv.RESPONSIBILITY_NAME 职责名称, REQUEST_GROUP_NAME 报表组, (select ppf.FULL_NAME from apps.per_people_f ppf w... 阅读全文

摘要： select fu.user_name 用户名, fu.description 描述, (select ppf.FULL_NAME from per_people_f ppf where ppf.PERSON_ID = fu.employee_id and trunc(sysdate) bet... 阅读全文

摘要： select frt.responsibility_name, fr.menu_id, fm.menu_name, fr.request_group_id, frg.request_group_namefrom fnd_responsibility fr, fnd_responsibility_... 阅读全文

摘要： /* 未加工的材料交易（必须解决）UNcosted Transactions (must resolve) 无成本的交易（必须解决）Pending WIP costing transactions (must resolve) 等待在制品成本交易（必须解决）UNcosted WSM transact... 阅读全文

摘要： select * from fnd_user t where t.user_name='user_name' 阅读全文

摘要： select status,trigger_namefrom all_triggerswhere trigger_name like 'PJM%';ALTER TRIGGER PJM_ORG_PARAMETERS_BRIU ENABLE; 阅读全文

摘要： 1.查询该报表的 concurrent_program_id SQL如下： SELECT t.application_id, t.concurrent_program_id, t.* FROM FND_CONCURRENT_PROGRAMS_TL T WHERE T.USER_CONCURRENT_... 阅读全文

该文被密码保护。 阅读全文

摘要： /*表空间查询*/SELECT d.status "状态", d.tablespace_name "名称", d.contents "类型", TO_CHAR(NVL(a.bytes / 1024 / 1024, 0),'99G999G990D900') "大小 (M)", TO_CHAR(NVL(... 阅读全文

摘要： SELECT d.status "状态",d.tablespace_name "名称", d.contents "类型", TO_CHAR(NVL(a.bytes / 1024 / 1024, 0),'99G999G990D900') "大小 (M)", TO_CHAR(NVL(a.bytes - ... 阅读全文

摘要： 查询DBA在系统中的打补丁信息1. select * from ad_patch_drivers /*查看已经打了哪些Patch*/2. select * from ad_patch_runs/*查看打patch的时间，目录等信息*/3. select * from ad_patch_driver_... 阅读全文

摘要： SELECT pro.profile_option_name, pro.user_profile_option_name, lev.level_type TYPE, --lev.level_code, lev.level_name, prv.profile_option_valueFROM apps... 阅读全文

摘要： select a.patch_name, b.DRIVER_FILE_NAME, c.language, b.creation_datefrom apps.ad_applied_patches a, apps.ad_patch_drivers b, apps.ad_patch_driver_lang... 阅读全文

摘要： /*死锁查询-1*/SELECT o.object_name, l.session_id,l.process,l.locked_mode FROM v$locked_object l , dba_objects o WHEREo.object_id=l.object_id--------------... 阅读全文

摘要： select aa.menu_name, aa.user_menu_name, aa.type, aa.description, aa.ENTRY_SEQUENCE, aa.prompt, aa.sub_user_menu_name, aa.user_function_name, aa.des... 阅读全文

摘要： SELECT DISTINCT fa.application_short_name 模块, b.responsibility_name 职责名称, fa.application_name 应用产品, b.responsibility_key 责任关键字, b.description 说明, D... 阅读全文

摘要： SELECT * FROM FND_FORM_CUSTOM_RULES;SELECT * FROM FND_FORM_CUSTOM_ACTIONS;SELECT * FROM FND_FORM_CUSTOM_PARAMS;SELECT * FROM FND_FORM_CUSTOM_SCOPES;se... 阅读全文

摘要： /*线用户查询-1*/SELECT FSAV.USER_NAME,FU.DESCRIPTION,FSAV.RESPONSIBILITY_NAME,FSAV.USER_FORM_NAME,FSAV.LOGIN_NAME,FSAV.TIME,FSAV.PID,FSAV.TERMINAL_ID,FSAV.... 阅读全文

摘要： select distinct l.profile_option_name,v.profile_option_value,fu.user_nameform applsys.fnd_profile_option_values v, apps.fnd_profile_options_vl l,apps... 阅读全文

摘要： select t.RESPONSIBILITY_NAMEfrom apps.FND_RESPONSIBILITY_VL t where t.RESPONSIBILITY_NAME like '%MRP%' or t.RESPONSIBILITY_NAME like '%WIP%' or t.RESP... 阅读全文

摘要： select fu.user_name 用户名, fu.description 描述, (select ppf.FULL_NAME from per_people_f ppf where ppf.PERSON_ID = fu.employee_id and trunc(sysdate) betwee... 阅读全文

摘要： SELECT fs.USER_NAME, fu.description, fs.RESPONSIBILITY_NAME, fs.USER_FORM_NAME, fs.TIME, fs.RESP_APPL_ID, fs.RESPONSIBILITY_ID, fs.FORM_ID, fs.FORM_AP... 阅读全文