DBA Data[Home] [Help]

APPS.BOM_BOM_COMPONENT_UTIL dependencies on BOM_OPERATIONAL_ROUTINGS

Line 2074: from bom_operational_routings

2070: WHERE
2071: bos.routing_sequence_id =
2072: (
2073: select common_routing_sequence_id
2074: from bom_operational_routings
2075: where assembly_item_id = p_assembly_item_id
2076: and organization_id = p_organization_id
2077: and nvl(alternate_routing_designator,
2078: nvl(p_alternate_bom_code, 'NONE')) =

Line 2086: from bom_operational_routings bor2

2082: and (alternate_routing_designator =
2083: p_alternate_bom_code
2084: or not exists
2085: (select null
2086: from bom_operational_routings bor2
2087: where bor2.assembly_item_id =
2088: p_assembly_item_id
2089: and bor2.organization_id = p_organization_id
2090: and bor2.alternate_routing_designator = p_alternate_bom_code