摘要：
--核销 SELECT hou.NAME org_name, rct.trx_number, rct.trx_date, hca.account_number customer, hpt.party_name customer_name, 'ARD' source_table, ard.line_i 阅读全文
posted @ 2024-03-20 09:02
Iven_lin
阅读(108)
评论(0)
推荐(0)
摘要：
DECLARE l_rowid ROWID; cursor cur is select pvs.SEGMENT1 vendor_code, pvs.VENDOR_NAME from po_vendors pvs where not exists (select 1 from fnd_lookup_v 阅读全文
posted @ 2024-03-20 09:00
Iven_lin
阅读(119)
评论(0)
推荐(1)
摘要：
select fpg.applications_system_name, fpg.release_name, fpg.aru_release_name from fnd_product_groups fpg; 阅读全文
posted @ 2024-03-20 08:58
Iven_lin
阅读(53)
评论(0)
推荐(0)
摘要：
select u.user_name, app.application_short_name, fat.application_name, fr.responsibility_key, frt.responsibility_name, fff.function_name, fft.user_func 阅读全文
posted @ 2024-03-20 08:54
Iven_lin
阅读(84)
评论(0)
推荐(0)
摘要：
模块： WIP 相关表：inv.mtl_material_transactions 物料事务处理表 （transaction_source_id 与 we.wip_entity_id 连接） inv.mtl_transaction_lot_numbers 物料事务处理批次号表（transaction 阅读全文
posted @ 2024-03-20 08:47
Iven_lin
阅读(445)
评论(0)
推荐(0)
摘要：
EBS 统计特定开头的请求 select t.user_concurrent_program_name, b.concurrent_program_name from fnd_concurrent_programs_tl t, fnd_concurrent_programs b where b.ap 阅读全文
posted @ 2024-03-20 08:45
Iven_lin
阅读(55)
评论(0)
推荐(0)
摘要：
select username usuario_oracle, count(username) numero_sesiones from gv$session group by username order by numero_sesiones desc; 阅读全文
posted @ 2024-03-20 08:35
Iven_lin
阅读(46)
评论(0)
推荐(0)
摘要：
create or replace function IS_INTEGER(VAR_VALUE IN VARCHAR) return NUMBER is Result NUMBER;begin Result := TO_NUMBER(VAR_VALUE); return Result;EXCEPTI 阅读全文
posted @ 2024-03-19 14:40
Iven_lin
阅读(55)
评论(0)
推荐(0)
摘要：
--性能最差的SQL SELECT * FROM ( SELECT PARSING_USER_ID EXECUTIONS,SORTS,COMMAND_TYPE,DISK_READS,sql_text FROM v$sqlarea ORDER BY disk_reads DESC) WHERE ROW 阅读全文
posted @ 2024-03-19 14:35
Iven_lin
阅读(25)
评论(0)
推荐(0)
摘要：
declare jobname number; begin dbms_job.submit(jobname ,存储过程名称;',trunc(sysdate)+12/24+05/24/60+01/24/60/60,'sysdate+5/24/60'); commit; end; 注释：trunc(sy 阅读全文
posted @ 2024-03-19 14:32
Iven_lin
阅读(236)
评论(0)
推荐(0)
浙公网安备 33010602011771号