[Home] [Help]
25: | module 1 - Costing
26: | 2 - Bom
27: | 3 - Order entry
28: | cst_type_id cost type id for costed explosion
29: | std_comp_flag 1 - explode only standard components
30: | 2 - all components
31: | expl_qty explosion quantity
32: | item_id item id of asembly to explode
33: | list_id unique id for lists in bom_lists for range
915: (c_bom_or_eng = 2)
916: )
917: --uncommented by arudresh for bug: 4422266
918:
919: -- whether to include option classes AND models under a standard item
920: -- special logic added at CST request
921: -- This check is valid only IF the BOM AND Component both are inventory items
922:
923: AND ( (BET.obj_name IS NULL AND BIC.obj_name IS NULL
931: --change made for P4Telco CMR, bug# 8761845
932: AND ( (c_std_bom_explode_flag = 'N' AND BET.BOM_ITEM_TYPE <> 4)
933: OR (c_std_bom_explode_flag = 'Y')
934: )
935: -- do not explode IF immediate parent is standard AND current
936: -- component is option class or model - special logic for config items
937: AND ( (BET.obj_name IS NULL
938: AND NOT ( BET.PARENT_BOM_ITEM_TYPE = 4 AND BET.BOM_ITEM_TYPE IN (1,2)))
939: OR (BET.obj_name IS NOT NULL))
4051: SET rexplode_flag = 0
4052: WHERE group_id = grp_id AND comp_bill_seq_id IS NOT NULL AND rexplode_flag = 1;
4053:
4054: -- change made for P4Telco CMR, bug# 8761845
4055: -- if Explode Standard BOM is unchecked (defaultly checked),
4056: -- or if the level for explosion is not the same with max bom level
4057: -- bom explosion should be done again next time to make sure the structure is correct.
4058: --comment for bug10107073
4059: /*