DBA Data[Home] [Help]

APPS.BOM_EXPLODER_PUB dependencies on BOM_ITEM_ATTACH_CATEGORY_ASSOC

Line 461: ( SELECT BIA.attach_category_id FROM BOM_ITEM_ATTACH_CATEGORY_ASSOC BIA

457: AND ATDOCS.PK1_VALUE = TO_CHAR(BET.ORGANIZATION_ID)
458: AND ATDOCS.PK2_VALUE = TO_CHAR(BET.COMPONENT_ITEM_ID)
459: AND ATDOCS.PK3_VALUE = BET.REVISION_ID ) )
460: AND ATDOCS.CATEGORY_ID IN
461: ( SELECT BIA.attach_category_id FROM BOM_ITEM_ATTACH_CATEGORY_ASSOC BIA
462: WHERE BIA.STRUCTURE_TYPE_ID IN
463: ( SELECT bst1.structure_type_id
464: FROM BOM_STRUCTURE_TYPES_B bst1
465: CONNECT BY PRIOR bst1.parent_structure_type_id = bst1.structure_type_id