oracle 內建包，用於將表中資料以層次關係展開將執行出的資料新增到零時表中

bompexpl.exploder_userexit(verify_flag => :verify_flag,
org_id => :rg_id,--organization_id --使用者輸入的組織號
order_by => :rder_by, --1 - Op seq, item seq
--2 - Item seq, op seq
grp_id => :grp_id, --unique value to identify current explosion use
--value from sequence bom_explosion_temp_s

session_id => :session_id, --unique value to identify current session
-- use value from bom_explosion_temp_session_s

levels_to_explode => :levels_to_explode, - -展開層數
bom_or_eng => :bom_or_eng, --1 - BOM； 2 - ENG
impl_flag => :impl_flag, -- 1 - implemented only 2 - both impl and unimpl

plan_factor_flag => lan_factor_flag, 預設2
explode_option => :explode_option, -- 1 - All| 2 - Current| 3 - Current and future
module => :module, -- 1 - Costing| 2 - Bom| 3 - Order entry| 4 - ATO| 5 - WSM

cst_type_id => :cst_type_id,--cost type id for costed explosion
std_comp_flag => :std_comp_flag, --std_comp_flag 1 - explode only standard components
-- 2 - all components

expl_qty => :expl_qty, -- explosion quantity
item_id => :item_id, --item id of assembly to explode--使用者輸入的庫存號
alt_desg => :alt_desg, ---alternate bom designator
comp_code => :comp_code, --concatenated component code lpad 16
rev_date => :rev_date, -- explosion date YYYY/MM/DD HH24:MI:SS ；一定要這個格式to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')
err_msg => :err_msg, --error message out buffer返回錯誤資訊
error_code => :error_code--error code out.returns sql error code if sql error 返回錯誤程式碼

)[@more@]

BOM展開學習

相關文章