APPS.CSD_WIP_JOB_PVT dependencies on CSD_REPAIR_ESTIMATE

Line 637: FROM csd_repair_estimate_lines_v crl, mtl_system_items_kfv msi

633: crl.unit_of_measure_code,
634: msi.revision_qty_control_code,
635: msi.new_revision_code,
636: SUM(crl.estimate_quantity) AS quantity
637: FROM csd_repair_estimate_lines_v crl, mtl_system_items_kfv msi
638: WHERE crl.repair_line_id = p_rep_line_id AND
639: crl.inventory_item_id = msi.inventory_item_id AND
640: msi.organization_id = cs_std.get_item_valdn_orgzn_id AND
641: billing_category = 'M' AND

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