ORACLE ERP 11i更新成本子要素

INSERT INTO CST_ITEM_CST_DTLS_INTERFACEITPUB个人空间!j$C#{Yyzv%U*o-A
(INVENTORY_ITEM_ID,ORGANIZATION_ID,COST_TYPE,RESOURCE_CODE,USAGE_RATE_OR_AMOUNT,ITPUB个人空间2o}4S,kW
r/bF$v?
COST_ELEMENT_ID,PROCESS_FLAG)

select msi.inventory_item_id,103,'设定',ITPUB个人空间wZ!]Q4|*h dW
'包装材料',cic.usage_rate_or_amount,cic.cost_element_id,1--,msi.segment1

O;J;M(mWj0from ITPUB个人空间@p}:N(L(I:cQC2z
mtl_system_items_b msi,
1|!U?f6x+@0cst_item_cost_details cic,ITPUB个人空间ks,a0\&},S
bom_resources    br
6[Z](c,ZR:u^dB}0where msi.organization_id=103
3B Vt3Jz
mP6F*}M0   and cic.organization_id=103
TM4f:} ` Ls"S~7Hpl0   and br.organization_id=103ITPUB个人空间q.u{Z8t&@8M[
   and br.resource_id=cic.resource_idITPUB个人空间fX0XfX)c
   and msi.inventory_item_id=cic.inventory_item_idITPUB个人空间T?,Mc#O j2c#]b$y/r
   and msi.inventory_item_status_code='Active'ITPUB个人空间1]K2f_*iC$J9a
   and cic.cost_type_id=1000
L`?G~$d0   and cic.cost_element_id=1ITPUB个人空间~1k8q$\;^1Kf$o
   and msi.segment1 like 'YB.%'