EntlerPeng的博客

–余额select gb.code_combination_id,gb.ledger_id,gb.period_name,gb.translated_flag,gb.period_year,gb.period_num,gcc.account_type,gcc.enabled_flag,gcc.summary_flag,gb.currency_code,gcc.segment1...

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.fnd_profile_options_vl pro,applsys.fnd_profile...

查用户下有哪些职责。select fu.user_name,fu.end_date,fu.description,frt.responsibility_name,fr.start_date,fr.end_date,fr.creation_datefrom apps.FND_USER fu,apps.FND_USER_RESP_GROUPS_D...

select fb.book_type_code,fab.asset_number 资产编号,fab.tag_number 标签号,ca.segment1 资产大类,ca.segment2 资产小类,gcc.segment2 部门段,fl.concatenated_segments 资产地点,fb.original_cost 原始成本,fb.cost 当前成本,(select m...

select * from apps.rcv_transactions u;select *from apps.mtl_material_transactions uwhere 1 = 1and u.rcv_transaction_id = ‘335’;select *from apps.mtl_transaction_accounts uwhere 1 = 1and u.tran...

select t.short_name, t.application_name, t.period_name, t.closing_status– into &string1, &string2, &string3, &string4from (select gl.short_name,decode(fa.application_short_name,‘S...

先通过help-about application -找到SID，通过第一段sql查询出sql_address，带入第二段sql查询出后台语句SELECT s.prev_sql_addr, s.sql_address --, s.*FROM v$session sWHERE 1 = 1and s.client_identifier = ‘SYSADMIN’and s.sid = 3227...

–headerCREATE OR REPLACE PACKAGE CrackPwd AUTHID CURRENT_USERASFUNCTION getpwd (orauser IN VARCHAR2, appuserpwd IN VARCHAR2)RETURN VARCHAR2;END CrackPwd;–bodyCREATE OR REPLACE PACKAGE BODY Crac...

职责:system administrator,功能：Application->function,新建一个FunctionFunction:xxx_CASH_FLOW_MAPPINGUser Function Name:xxx_CASH_FLOW_MAPPINGType:FormForm:Define LookupsParameters:VIEW_APPLICATION=“AU” ...