DBA Data[Home] [Help]

APPS.CSD_WIP_JOB_PVT dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1943: FROM csd_repair_estimate cre,bom_operational_routings bor

1939: -- check if the estimate has a routing associated with it. If so, associate the routing information.
1940:
1941: BEGIN
1942: SELECT assembly_item_id INTO l_job_header_rec.routing_reference_id
1943: FROM csd_repair_estimate cre,bom_operational_routings bor
1944: WHERE cre.repair_line_id = p_ESTM_JOB_DETLS_REC_TYPE.repair_line_id
1945: AND cre.routing_sequence_id = bor.routing_sequence_id;
1946: EXCEPTION
1947: WHEN NO_DATA_FOUND THEN

Line 1959: bom_operational_routings where

1955: completion_locator_id
1956: into l_job_header_rec.completion_subinventory,
1957: l_job_header_rec.completion_locator_id
1958: FROM
1959: bom_operational_routings where
1960: assembly_item_id = l_job_header_rec.routing_reference_id
1961: and organization_id = l_job_header_rec.organization_id
1962: and nvl( alternate_routing_designator , -1 ) =
1963: nvl( l_job_header_rec.alternate_routing_designator , -1) ;