DBA Data[Home] [Help]

APPS.BOMPEXPL dependencies on STANDARD

Line 36: | std_comp_flag 1 - explode only standard components

32: | 3 - Order entry
33: | 4 - ATO
34: | 5 - WSM
35: | cst_type_id cost type id for costed explosion
36: | std_comp_flag 1 - explode only standard components
37: | 2 - all components
38: | expl_qty explosion quantity
39: | item_id item id of asembly to explode
40: | list_id unique id for lists in bom_lists for range

Line 354: -- whether to include option classes and models under a standard item

350: )
351: ) -- subquery
352: )
353: ) -- end of alt logic
354: -- whether to include option classes and models under a standard item
355: -- special logic added at CST request
356: AND ( (c_incl_oc = 1)
357: or
358: (c_incl_oc = 2 AND

Line 364: -- do not explode if immediate parent is standard and current

360: OR
361: ( BET.BOM_ITEM_TYPE <> 4)
362: )
363: )
364: -- do not explode if immediate parent is standard and current
365: -- component is option class or model - special logic for config items
366: AND NOT ( BET.PARENT_BOM_ITEM_TYPE = 4
367: AND
368: BET.BOM_ITEM_TYPE IN (1,2)