APPS.CSD_PROCESS_PVT dependencies on CS_ESTIMATE_DETAILS

Line 566: FROM cs_estimate_details

562: THEN
563: BEGIN
564: SELECT business_process_id
565: INTO l_Charges_Rec.business_process_id
566: FROM cs_estimate_details
567: WHERE estimate_detail_id =
568: l_Charges_Rec.estimate_detail_id;
569: EXCEPTION
570: WHEN NO_DATA_FOUND THEN

Line 869: cs_estimate_details ced,

865: wdd.requested_quantity,
866: mtl.serial_number_control_code
867: FROM csd_repairs cr,
868: mtl_system_items_b mtl,
869: cs_estimate_details ced,
870: wsh_delivery_details wdd,
871: --Changed to view from table, bug: 4341784
872: wsh_delivery_assignments_v wda
873: WHERE cr.repair_line_id = ced.original_source_id

Line 2322: FROM cs_estimate_details

2318: WHERE incident_id = p_incident_id;
2319:
2320: CURSOR estimate(p_rep_line_id IN NUMBER) IS
2321: SELECT estimate_detail_id, object_version_number
2322: FROM cs_estimate_details
2323: WHERE source_id = p_rep_line_id
2324: AND source_code = 'DR'
2325: AND interface_to_oe_flag = 'N'
2326: AND order_header_id IS NULL

Line 2337: FROM oe_order_lines_all a, cs_estimate_details b

2333: WHERE project_id = l_project_id and inventory_organization_id = l_p_ship_from_org_id;
2334:
2335: CURSOR order_line_cu(l_est_detail_id NUMBER) is
2336: SELECT b.order_line_id, a.ship_from_org_id
2337: FROM oe_order_lines_all a, cs_estimate_details b
2338: WHERE a.line_id = b.order_line_id
2339: AND b.estimate_detail_id = l_est_detail_id;
2340:
2341: -- swai: bug 6001057

Line 3260: FROM cs_estimate_details a

3256: BEGIN
3257: -- Get the order header id from the charge line
3258: SELECT a.order_header_id, a.order_line_id
3259: INTO l_order_header_id, l_order_line_id
3260: FROM cs_estimate_details a
3261: WHERE a.estimate_detail_id = x_estimate_detail_id
3262: AND a.order_header_id IS NOT NULL
3263: AND a.order_line_id IS NOT NULL;
3264:

Line 4075: FROM cs_estimate_details

4071: WHERE incident_id = p_incident_id;
4072:
4073: CURSOR estimate(p_rep_line_id IN NUMBER) IS
4074: SELECT estimate_detail_id, object_version_number
4075: FROM cs_estimate_details
4076: WHERE source_id = p_rep_line_id
4077: AND source_code = 'DR'
4078: AND interface_to_oe_flag = 'N'
4079: AND order_header_id IS NULL

Line 4591: FROM cs_estimate_details

4587:
4588:
4589: CURSOR estimate(p_rep_line_id IN NUMBER) IS
4590: SELECT estimate_detail_id, object_version_number
4591: FROM cs_estimate_details
4592: WHERE source_id = p_rep_line_id
4593: AND source_code = 'DR'
4594: AND interface_to_oe_flag = 'N'
4595: AND order_header_id IS NULL

Line 4972: FROM csd_product_transactions a, cs_estimate_details b

4968: -- only if it is not interfaced
4969: BEGIN
4970: SELECT a.estimate_detail_id
4971: INTO l_est_detail_id
4972: FROM csd_product_transactions a, cs_estimate_details b
4973: WHERE a.estimate_detail_id = b.estimate_detail_id
4974: AND a.product_transaction_id = p_product_txn_id
4975: AND b.order_header_id IS NULL;
4976:

Line 7994: UPDATE CS_ESTIMATE_DETAILS

7990: x_msg_count OUT NOCOPY NUMBER,
7991: x_msg_data OUT NOCOPY VARCHAR2) IS
7992: BEGIN
7993:
7994: UPDATE CS_ESTIMATE_DETAILS
7995: SET SOURCE_CODE = 'DR', SOURCE_ID = p_repair_line_id
7996: WHERE INCIDENT_ID = p_incident_id
7997: AND ESTIMATE_DETAIL_ID = p_estimate_detail_line_id;
7998:

Line 9007: FROM csd_product_Transactions cpt, cs_estimate_Details ced

9003: SELECT cpt.product_Transaction_Id,
9004: ced.Estimate_Detail_Id,
9005: ced.order_header_Id,
9006: ced.order_Line_Id
9007: FROM csd_product_Transactions cpt, cs_estimate_Details ced
9008: WHERE cpt.repair_line_id = p_Repair_Line_Id
9009: AND cpt.estimate_detail_id = ced.estimate_detail_id;
9010: BEGIN
9011: -- Standard call to check for call compatibility.