DBA Data[Home] [Help]

APPS.BOM_OE_EXPLODER_PKG dependencies on STANDARD

Line 559: -- comp is an optional standard item

555: AND ( (arg_expl_type = 'OPTIONAL'
556: AND BE.BOM_ITEM_TYPE in (1,2) -- parent is a model or opt class
557: AND (BIC.BOM_ITEM_TYPE IN (1,2) OR -- comp is a model or opt class
558: (BIC.BOM_ITEM_TYPE = 4 AND BIC.OPTIONAL = 1)))
559: -- comp is an optional standard item
560: OR (arg_expl_type = 'INCLUDED'
561: AND BE.PICK_COMPONENTS_FLAG = 'Y' -- parent is PTO
562: AND BIC.BOM_ITEM_TYPE = 4 -- comp is a mandatory standard item
563: AND BIC.OPTIONAL = 2)

Line 562: AND BIC.BOM_ITEM_TYPE = 4 -- comp is a mandatory standard item

558: (BIC.BOM_ITEM_TYPE = 4 AND BIC.OPTIONAL = 1)))
559: -- comp is an optional standard item
560: OR (arg_expl_type = 'INCLUDED'
561: AND BE.PICK_COMPONENTS_FLAG = 'Y' -- parent is PTO
562: AND BIC.BOM_ITEM_TYPE = 4 -- comp is a mandatory standard item
563: AND BIC.OPTIONAL = 2)
564: OR (arg_expl_type not in ('OPTIONAL', 'INCLUDED')) -- both
565: )
566: AND ( (BE.BASE_ITEM_ID IS NOT NULL AND