DBA Data[Home] [Help]

APPS.BOM_ROLLUP_PUB dependencies on BOM_STRUCTURES_B

Line 1303: FROM bom_structures_b bom

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

Line 1321: bom_structures_b

1317: IS
1318: SELECT
1319: alternate_bom_designator
1320: FROM
1321: bom_structures_b
1322: WHERE
1323: assembly_item_id = p_assembly_item_id
1324: AND organization_id = p_org_id
1325: AND structure_type_id = p_struct_type_id

Line 1406: BOM_STRUCTURES_B

1402: THEN
1403: SELECT
1404: ALTERNATE_BOM_DESIGNATOR INTO l_alternate_bom_code
1405: FROM
1406: BOM_STRUCTURES_B
1407: WHERE
1408: ASSEMBLY_ITEM_ID = l_rollup_item_id
1409: AND ORGANIZATION_ID = p_organization_id
1410: AND STRUCTURE_TYPE_ID = p_structure_type_id