DBA Data[Home] [Help]

APPS.BOM_EXPLODER_PUB dependencies on BOM_ITEM_ATTACH_CATEGORY_ASSOC

Line 473: ( SELECT BIA.attach_category_id FROM BOM_ITEM_ATTACH_CATEGORY_ASSOC BIA

469: AND ATDOCS.PK1_VALUE = TO_CHAR(BET.ORGANIZATION_ID)
470: AND ATDOCS.PK2_VALUE = TO_CHAR(BET.COMPONENT_ITEM_ID)
471: AND ATDOCS.PK3_VALUE = BET.REVISION_ID ) )
472: AND ATDOCS.CATEGORY_ID IN
473: ( SELECT BIA.attach_category_id FROM BOM_ITEM_ATTACH_CATEGORY_ASSOC BIA
474: WHERE BIA.STRUCTURE_TYPE_ID IN
475: ( SELECT bst1.structure_type_id
476: FROM BOM_STRUCTURE_TYPES_B bst1
477: CONNECT BY PRIOR bst1.parent_structure_type_id = bst1.structure_type_id