DBA Data[Home] [Help]

APPS.BOM_OE_EXPLODER_PKG dependencies on STANDARD

Line 563: -- comp is an optional standard item

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

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

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