摘要：
declarebegin <<outer>> for i in reverse 1 .. 3 loop <<inner>> for i in 4 .. 6 loop dbms_output.put_line('outer' || outer.i); dbms_output.put_line('inn 阅读全文
posted @ 2024-03-19 14:13
Iven_lin
阅读(55)
评论(0)
推荐(0)
摘要：
select t1.table_name, t1.column_name, t1.nullable, t1.data_type || '(' || t1.data_length || ')', t2.comments from all_tab_cols t1, all_col_comments t2 阅读全文
posted @ 2024-03-19 14:04
Iven_lin
阅读(44)
评论(0)
推荐(0)
摘要：
-- EBS 修改EBS账号密码 DECLARE l_success boolean; BEGIN l_success := FND_USER_PKG.ChangePassword('OPERATIONS', 'welcome123'); IF l_success THEN DBMS_OUTPUT. 阅读全文
posted @ 2024-03-19 13:46
Iven_lin
阅读(140)
评论(0)
推荐(0)
摘要：
CREATE OR REPLACE FUNCTION cux_trans_source(p_trans_id NUMBER) RETURN VARCHAR2 IS ln_type_id NUMBER; ln_source_line_id NUMBER; ln_trx_source_line_id N 阅读全文
posted @ 2024-03-19 11:53
Iven_lin
阅读(42)
评论(0)
推荐(0)
摘要：
inv_quantity_tree_pub.query_quantities(p_api_version_number => 1.0, x_return_status => l_return_status, x_msg_count => l_msg_count, x_msg_data => l_ms 阅读全文
posted @ 2024-03-19 09:35
Iven_lin
阅读(215)
评论(0)
推荐(0)
摘要：
SELECT * FROM xle_entity_profiles; 阅读全文
posted @ 2024-03-19 09:33
Iven_lin
阅读(44)
评论(0)
推荐(0)
摘要：
WSH_NEW_DELIVERY_ACTIONS.Confirm_Delivery(p_del_rows => l_delivery_id_tab, p_action_flag => l_action_flag, p_intransit_flag => l_intransit_flag, p_clo 阅读全文
posted @ 2024-03-19 09:32
Iven_lin
阅读(70)
评论(0)
推荐(0)
摘要：
--lv_msg_count : 为api返回参数,为消息的个数。 --根据消息的具体情况，循环次数要做相应调整。加大次数，消息内容就多，反之则少.if lv_msg_count > 0 then lv_mesg := chr(10) || substr(fnd_msg_pub.get(fnd_ms 阅读全文
posted @ 2024-03-19 09:29
Iven_lin
阅读(49)
评论(0)
推荐(0)
摘要：
create or replace procedure get_inv_quantity(p_organization_id in number, p_inventory_item_id in number, p_lot_number in varchar2, p_subinventory_code 阅读全文
posted @ 2024-03-19 09:24
Iven_lin
阅读(142)
评论(0)
推荐(0)
摘要：
--erp系统里的bom展开函数: declare l_grp_id number; l_session_id number; l_org_id number; l_levels_to_explode number := 10; l_module number default 2; -- bom = 阅读全文
posted @ 2024-03-19 09:21
Iven_lin
阅读(63)
评论(0)
推荐(0)
浙公网安备 33010602011771号