--How to use script to get all oracle EBS Form name and corresponding fmb file name . SELECT fff.function_name , ff.form_name , ffft.user_function_name , fff.function_id , ff.form_id , fff.application_id FROM fnd_form ff , fnd_form_functions fff , fnd_form_functions_tl ffft WHERE 1 = 1 AND ff.form_id = fff.form_id AND fff.function_id = ffft.function_id AND ffft.language = 'US' AND fff.application_id = 401 --Inventory Module ORDER BY ffft.user_function_name; --How to use script to get all Oracle EBS Concurrent Program/Report name and corresponding execution f . SELECT fcp.concurrent_program_name , fcpt.user_concurrent_program_name , fcp.execution_method_code , flv.meaning FROM fnd_concurrent_programs fcp , fnd_concurrent_programs_tl fcpt , fnd_lookup_values flv WHERE 1 = 1 AND fcp.concurrent_program_id = fcpt.concurrent_program_id AND flv.lookup_type = 'CP_EXECUTION_METHOD_CODE' AND fcp.execution_method_code = flv.lookup_code AND fcpt.language = 'US' AND flv.language = 'US' AND fcp.application_id = 401 --Inventory Module ORDER BY fcpt.user_concurrent_program_name;
EBS SQL --> Form & Report
相關文章
- Oracle EBS Form & Report 問題大全OracleORM
- 取得EBS 當前form介面查詢LOV的源sqlORMSQL
- EBS form編譯問題ORM編譯
- EBS FORM PLL 開發入門ORM
- EBS form 及 jsp 編譯ORMJS編譯
- oracle EBS R12 FORM 編譯OracleORM編譯
- EBS 11i彈不出Form介面ORM
- 編譯form ebs12 and wfload編譯ORM
- Oracle EBS -- 編譯Form時出錯Oracle編譯ORM
- EBS中form埠及servlet , socket模式問題及form相關配置檔案ORMServlet模式
- EBS SQL編寫心得SQL
- EBS 常用SQL整理一SQL
- EBS 11i form打不開解決辦法ORM
- SQL Monitor Report 使用詳解SQL
- Oracle SQL調優系列之SQL Monitor ReportOracleSQL
- 案例 - EBS SQL效能診斷SQL
- Oracle EBS環境下查詢資料來源(Form篇)OracleORM
- EBS Form不能登入: Illegal argument for colorScheme applet parameterORMSchemeAPP
- plsql developer工具生成sql monitor reportSQLDeveloper
- 生成sql monitor active report指令碼SQL指令碼
- Script to generate AWR report from remote sql clientREMSQLclient
- WEB PL/SQL Report 的開發方法WebSQL
- EBS DBA日常維護使用的sqlSQL
- EBS:Oracle 資料庫執行慢SQLOracle資料庫SQL
- sql*menu5 sql*form3 使用10g客戶端SQLORM客戶端
- SQL Server Report Service網頁頁面顯示英文問題SQLServer網頁
- RedHat Linux5 下克隆EBS R12 開啟Form 報錯 FRM-92101RedhatLinuxORM
- 從EBS中獲得值集對應的SQL的方法SQL
- 使用sql monitor獲取更加詳細的執行計劃 - dbms_sqltune.report_sql_monitorSQL
- 【EBS】Oracle EBS 之 OM 模組整理(1)Oracle
- jquery 中$("form :input") $("form input") 區別jQueryORM
- oracle ebsOracle
- Form元件ORM元件
- bootstrap – formbootORM
- FORM ExportORMExport
- statspack report分析
- Standby Database for reportDatabase
- Oracle Statspack ReportOracle