DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REVISED_ITEM dependencies on BOM_STRUCTURES_B

Line 1803: FROM bom_structures_b

1799: , x_structure_type_id OUT NOCOPY NUMBER
1800: ) IS
1801: CURSOR get_bill_structure_type IS
1802: SELECT structure_type_id
1803: FROM bom_structures_b
1804: WHERE assembly_item_id = p_inventory_item_id
1805: AND organization_id = p_organization_id
1806: AND ((alternate_bom_designator IS NULL AND p_alternate_bom_code IS NULL)
1807: OR (p_alternate_bom_code IS NOT NULL AND alternate_bom_designator = p_alternate_bom_code));

Line 5921: FROM ENG_REVISED_ITEMS sitm , bom_structures_b bsb

5917: AND (itm.CURRENT_ITEM_REVISION_ID = sitm.new_item_revision_id
5918: OR itm.FROM_END_ITEM_REV_ID = sitm.new_item_revision_id)
5919: UNION ALL
5920: SELECT 1
5921: FROM ENG_REVISED_ITEMS sitm , bom_structures_b bsb
5922: WHERE sitm.revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id
5923: AND bsb.assembly_item_id = sitm.revised_item_id
5924: AND bsb.organization_id = sitm.organization_id
5925: AND EXISTS ( SELECT 1