DBA Data[Home] [Help]

APPS.BOM_BOM_COMPONENT_UTIL dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1966: from bom_operational_routings

1962: WHERE
1963: bos.routing_sequence_id =
1964: (
1965: select common_routing_sequence_id
1966: from bom_operational_routings
1967: where assembly_item_id = p_assembly_item_id
1968: and organization_id = p_organization_id
1969: and nvl(alternate_routing_designator,
1970: nvl(p_alternate_bom_code, 'NONE')) =

Line 1978: from bom_operational_routings bor2

1974: and (alternate_routing_designator =
1975: p_alternate_bom_code
1976: or not exists
1977: (select null
1978: from bom_operational_routings bor2
1979: where bor2.assembly_item_id =
1980: p_assembly_item_id
1981: and bor2.organization_id = p_organization_id
1982: and bor2.alternate_routing_designator = p_alternate_bom_code