[Home] [Help]
2110: -- check if the estimate has a routing associated with it. If so, associate the routing information.
2111:
2112: BEGIN
2113: SELECT assembly_item_id INTO l_job_header_rec.routing_reference_id
2114: FROM csd_repair_estimate cre,bom_operational_routings bor
2115: WHERE cre.repair_line_id = p_ESTM_JOB_DETLS_REC_TYPE.repair_line_id
2116: AND cre.routing_sequence_id = bor.routing_sequence_id;
2117: EXCEPTION
2118: WHEN NO_DATA_FOUND THEN
2126: completion_locator_id
2127: into l_job_header_rec.completion_subinventory,
2128: l_job_header_rec.completion_locator_id
2129: FROM
2130: bom_operational_routings where
2131: assembly_item_id = l_job_header_rec.routing_reference_id
2132: and organization_id = l_job_header_rec.organization_id
2133: and nvl( alternate_routing_designator , -1 ) =
2134: nvl( l_job_header_rec.alternate_routing_designator , -1) ;
2660: l_completion_subinvs,
2661: l_completion_locs
2662: FROM csd_sc_work_entities cscwe,
2663: bom_bill_of_materials bom ,
2664: bom_operational_routings bor
2665: WHERE cscwe.service_code_id = p_service_code_id
2666: AND cscwe.work_entity_type_code = 'BOM'
2667: AND cscwe.work_entity_id3 = p_inventory_org_id
2668: AND cscwe.work_entity_id1 = bom.bill_sequence_id (+)