摘要：DECLARE l_response CLOB := '{ "success": true, "message": "query success", "data": [ 123, "asd", null, { "currency": "CNY" }, { "currency": "USD", "sa 阅读全文

摘要：SELECT v.LOGFILE_NAME from fnd_concurrent_requests vWHERE REQUEST_ID = 50952097; 阅读全文

摘要：SELECT * FROM V$SQLWHERE SQL_TEXT LIKE '%CUX_SVO_TEST%'; 阅读全文

摘要：SELECT table_owner, table_name, column_name, index_name FROM dba_ind_columns WHERE table_owner = 'CUX' AND table_name = 'CUX_XM_TRX_HEADERS_ALL'; 阅读全文

摘要：DECLARE -- Non-scalar parameters require additional processing p_files cux_send_attachment_common.tab_of_attachments; l_count NUMBER := 0;BEGIN FOR re 阅读全文

摘要：select 'Request id: ' || request_id, 'Trace id: ' || oracle_Process_id, 'Trace Flag: ' || req.enable_trace, 'Trace Dir: Go to directory ' || dest.valu 阅读全文

摘要：BEGIN Fnd_Global.Apps_Initialize(User_Id => 0, Resp_Id => 50722, Resp_Appl_Id => 222); Mo_Global.Init('SQLAP'); Mo_Global.Set_Policy_Context(p_Access_ 阅读全文

摘要：SELECT REQUEST_ID, request_type, PROGRAM, actual_start_date 开始日期, ACTUAL_COMPLETION_DATE 完成日期, ROUND((TO_NUMBER(ACTUAL_COMPLETION_DATE - actual_start_ 阅读全文

摘要：DECLARE l_mail_text VARCHAR2(32765); l_mail_receiver VARCHAR2(20000) := 'chenxianping@longcheer.com'; x_return_status VARCHAR2(20); x_msg_data VARCHAR 阅读全文

摘要：DECLARE l_iface_rec wip.wip_job_schedule_interface%ROWTYPE; x_return_status VARCHAR2(30); x_msg_data VARCHAR2(2000);BEGIN BEGIN fnd_global.apps_initia 阅读全文

摘要：ALTER SESSION SET NLS_LANGUAGE='SIMPLIFIED CHINESE'; 阅读全文

摘要：Declare v_ChartOfAccoutsId Number := 50268; --GL帐户键弹性域结构ID v_AccountName Varchar2(2000) := '14000.51010601.0.122.266501906.0.2030105.ZZZZZZ.0.0'; --GL 阅读全文

摘要：PROCEDURE EVENT_HANDLER(EVENT VARCHAR2) IS l_where_sql VARCHAR2(1200) := ' EXISTS (SELECT 1 FROM cux_xm_dbd_lines_iface xdl WHERE xdl.header_id = xdh. 阅读全文

摘要：SELECT ORGANIZATION_ID,postprocessing_lead_time FROM mtl_system_items_bWHERE INVENTORY_ITEM_ID = 352351; DECLARE l_Item_Rec Inv_Item_Grp.Item_Rec_Type 阅读全文

摘要：--1.根据装配件自动创建任务Declare l_iface_rec wip.wip_job_schedule_interface%rOWTYPE; --任务单--组件 l_GroupId Number := 123456; l_OrganizationId Number :=122; l_User 阅读全文

摘要：--2.手工创建任务单（组件、工序和资源）Declare --任务单 l_iface_rec wip.wip_job_schedule_interface%rOWTYPE; --任务单-组件 l_CompRec wip.wip_job_dtls_interface%rOWTYPE; --任务单-工序 阅读全文

摘要：dbms_output.put_line('Error:' || dbms_utility.format_error_backtrace || sqlerrm); COMMIT; EXCEPTION WHEN OTHERS THEN ROLLBACK; x_message := SQLERRM || 阅读全文

摘要：SELECT usr.user_name ,usr.user_id ,usr.employee_id ,get_pwd.decrypt((SELECT (SELECT get_pwd.decrypt(fnd_web_sec.get_guest_username_pwd, usertable.encr 阅读全文

摘要：select * from cux_item_project_mapping_temp;先看026是否在运行中1.truncate table cux_item_project_mapping_temp; 2.select * from cux_item_project_mapping_temp f 阅读全文

摘要：SELECT * FROM mtl_system_items_bWHERE SEGMENT1 = '6610AA002957' AND ORGANIZATION_ID = 96; SELECT * FROM MTL_PARAMETERSWHERE ORGANIZATION_CODE = '125'; 阅读全文