APPS.CSD_PROCESS_UTIL dependencies on CS_ESTIMATE_DETAILS

Line 4047: cs_estimate_details ced,

4043: sum(ced.after_warranty_cost)
4044: into l_amount
4045: from csd_repair_estimate cre,
4046: csd_repair_estimate_lines crel,
4047: cs_estimate_details ced,
4048: cs_txn_billing_types ctbt
4049: where cre.repair_estimate_id = crel.repair_estimate_id
4050: and crel.estimate_detail_id = ced.estimate_detail_id
4051: and ced.txn_billing_type_id = ctbt.txn_billing_type_id

Line 4062: cs_estimate_details ced,

4058: sum(ced.after_warranty_cost)
4059: into l_amount
4060: from csd_repair_estimate cre,
4061: csd_repair_estimate_lines crel,
4062: cs_estimate_details ced,
4063: cs_txn_billing_types ctbt
4064: where cre.repair_estimate_id = crel.repair_estimate_id
4065: and crel.estimate_detail_id = ced.estimate_detail_id
4066: and ced.txn_billing_type_id = ctbt.txn_billing_type_id

Line 4077: cs_estimate_details ced,

4073: sum(ced.after_warranty_cost)
4074: into l_amount
4075: from csd_repair_estimate cre,
4076: csd_repair_estimate_lines crel,
4077: cs_estimate_details ced,
4078: cs_txn_billing_types ctbt
4079: where cre.repair_estimate_id = crel.repair_estimate_id
4080: and crel.estimate_detail_id = ced.estimate_detail_id
4081: and ced.txn_billing_type_id = ctbt.txn_billing_type_id

Line 4092: cs_estimate_details ced

4088: sum(ced.after_warranty_cost)
4089: into l_amount
4090: from csd_repair_estimate cre,
4091: csd_repair_estimate_lines crel,
4092: cs_estimate_details ced
4093: where cre.repair_estimate_id = crel.repair_estimate_id
4094: and crel.estimate_detail_id = ced.estimate_detail_id
4095: and cre.repair_line_id = p_repair_line_id ;
4096:

Line 4408: cs_estimate_details c

4404: b.repair_line_id,
4405: c.quantity_required
4406: FROM csd_repairs a,
4407: csd_product_transactions b,
4408: cs_estimate_details c
4409: where a.repair_line_id = b.repair_line_id
4410: and b.estimate_detail_id = c.estimate_detail_id
4411: and b.product_transaction_id = p_prod_txn_id;
4412:

Line 4441: cs_estimate_details c

4437: l_repair_line_id,
4438: l_prod_txn_qty
4439: FROM csd_repairs a,
4440: csd_product_transactions b,
4441: cs_estimate_details c
4442: where a.repair_line_id = b.repair_line_id
4443: and b.estimate_detail_id = c.estimate_detail_id
4444: and b.product_transaction_id = p_prod_txn_id ;
4445:

Line 4556: cs_estimate_details b

4552: CURSOR qty_by_type IS
4553: SELECT
4554: abs(sum(b.quantity_required))
4555: FROM csd_product_transactions a,
4556: cs_estimate_details b
4557: where a.estimate_detail_id = b.estimate_detail_id
4558: and a.action_code = 'CUST_PROD'
4559: and a.prod_txn_status <> 'CANCELLED'
4560: and a.action_type = p_action_type

Line 6117: cs_estimate_details ced,

6113: begin
6114: Select max(ced.order_header_id)
6115: into l_add_to_order_id
6116: from csd_repairs dr,
6117: cs_estimate_details ced,
6118: oe_order_headers_all ooh,
6119: oe_order_types_v oot,
6120: cs_incidents_all_b sr -- swai: bug 5931926
6121: where dr.repair_line_id = p_repair_line_id

Line 6152: cs_estimate_details ced,

6148:
6149: Select max(ced.order_header_id)
6150: into l_add_to_order_id
6151: from csd_repairs dr,
6152: cs_estimate_details ced,
6153: oe_order_headers_all ooh,
6154: oe_order_types_v oot,
6155: cs_incidents_all_b sr -- swai: bug 5931926
6156: where dr.repair_line_id = p_repair_line_id