DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REVISED_ITEM dependencies on BOM_STRUCTURES_B

Line 1875: FROM bom_structures_b

1871: , x_structure_type_id OUT NOCOPY NUMBER
1872: ) IS
1873: CURSOR get_bill_structure_type IS
1874: SELECT structure_type_id
1875: FROM bom_structures_b
1876: WHERE assembly_item_id = p_inventory_item_id
1877: AND organization_id = p_organization_id
1878: AND ((alternate_bom_designator IS NULL AND p_alternate_bom_code IS NULL)
1879: OR (p_alternate_bom_code IS NOT NULL AND alternate_bom_designator = p_alternate_bom_code));

Line 6007: FROM ENG_REVISED_ITEMS sitm , bom_structures_b bsb

6003: OR itm.FROM_END_ITEM_REV_ID = sitm.new_item_revision_id)
6004: AND (sitm.CURRENT_ITEM_REVISION_ID<>sitm.NEW_ITEM_REVISION_ID)
6005: UNION ALL
6006: SELECT 1
6007: FROM ENG_REVISED_ITEMS sitm , bom_structures_b bsb
6008: WHERE sitm.revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id
6009: AND bsb.assembly_item_id = sitm.revised_item_id
6010: AND bsb.organization_id = sitm.organization_id
6011: AND EXISTS ( SELECT 1