DBA Data[Home] [Help]

APPS.CSD_WIP_JOB_PVT dependencies on CSD_REPAIR_ESTIMATE

Line 642: FROM csd_repair_estimate_lines_v crl, mtl_system_items_kfv msi

638: crl.unit_of_measure_code,
639: msi.revision_qty_control_code,
640: msi.new_revision_code,
641: SUM(crl.estimate_quantity) AS quantity
642: FROM csd_repair_estimate_lines_v crl, mtl_system_items_kfv msi
643: WHERE crl.repair_line_id = p_rep_line_id AND
644: crl.inventory_item_id = msi.inventory_item_id AND
645: msi.organization_id = cs_std.get_item_valdn_orgzn_id AND
646: billing_category = 'M' AND

Line 2114: FROM csd_repair_estimate cre,bom_operational_routings bor

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