APPS.BOM_ROLLUP_PUB dependencies on BOM_STRUCTURES_B

Line 1305: FROM bom_structures_b bom

1301: impl.sequence_id = p_sequence_id
1302: and impl.top_item_flag='Y'
1303: and ( current_level = 0
1304: OR EXISTS(SELECT 1
1305: FROM bom_structures_b bom
1306: WHERE bom.assembly_item_id = impl.parent_item_id
1307: AND bom.organization_id = impl.organization_id
1308: AND nvl(bom.alternate_bom_designator,'xxxxxxxxxxx') =
1309: nvl(impl.parent_alternate_designator,'xxxxxxxxxxx')

Line 1327: FROM BOM_STRUCTURES_B BOM

1323: AND IMPL.TOP_ITEM_FLAG = 'Y'
1324: AND ( CURRENT_LEVEL = 0
1325: OR EXISTS(
1326: SELECT 1
1327: FROM BOM_STRUCTURES_B BOM
1328: WHERE BOM.ASSEMBLY_ITEM_ID = IMPL.PARENT_ITEM_ID
1329: AND BOM.ORGANIZATION_ID = IMPL.ORGANIZATION_ID
1330: AND NVL(BOM.ALTERNATE_BOM_DESIGNATOR,'xxxxxxxxxxx') =
1331: NVL(IMPL.ALTERNATE_DESIGNATOR,'xxxxxxxxxxx')

Line 1373: bom_structures_b

1369: IS
1370: SELECT
1371: alternate_bom_designator
1372: FROM
1373: bom_structures_b
1374: WHERE
1375: assembly_item_id = p_assembly_item_id
1376: AND organization_id = p_org_id
1377: AND structure_type_id = p_struct_type_id

Line 1458: BOM_STRUCTURES_B

1454: THEN
1455: SELECT
1456: ALTERNATE_BOM_DESIGNATOR INTO l_alternate_bom_code
1457: FROM
1458: BOM_STRUCTURES_B
1459: WHERE
1460: ASSEMBLY_ITEM_ID = l_rollup_item_id
1461: AND ORGANIZATION_ID = p_organization_id
1462: AND STRUCTURE_TYPE_ID = p_structure_type_id