eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_PROCESS_UTIL dependencies on CS_ESTIMATE_DETAILS

Line 3816: cs_estimate_details ced,

3812: sum(ced.after_warranty_cost)
3813: into l_amount
3814: from csd_repair_estimate cre,
3815: csd_repair_estimate_lines crel,
3816: cs_estimate_details ced,
3817: cs_txn_billing_types ctbt
3818: where cre.repair_estimate_id = crel.repair_estimate_id
3819: and crel.estimate_detail_id = ced.estimate_detail_id
3820: and ced.txn_billing_type_id = ctbt.txn_billing_type_id

Line 3831: cs_estimate_details ced,

3827: sum(ced.after_warranty_cost)
3828: into l_amount
3829: from csd_repair_estimate cre,
3830: csd_repair_estimate_lines crel,
3831: cs_estimate_details ced,
3832: cs_txn_billing_types ctbt
3833: where cre.repair_estimate_id = crel.repair_estimate_id
3834: and crel.estimate_detail_id = ced.estimate_detail_id
3835: and ced.txn_billing_type_id = ctbt.txn_billing_type_id

Line 3846: cs_estimate_details ced,

3842: sum(ced.after_warranty_cost)
3843: into l_amount
3844: from csd_repair_estimate cre,
3845: csd_repair_estimate_lines crel,
3846: cs_estimate_details ced,
3847: cs_txn_billing_types ctbt
3848: where cre.repair_estimate_id = crel.repair_estimate_id
3849: and crel.estimate_detail_id = ced.estimate_detail_id
3850: and ced.txn_billing_type_id = ctbt.txn_billing_type_id

Line 3861: cs_estimate_details ced

3857: sum(ced.after_warranty_cost)
3858: into l_amount
3859: from csd_repair_estimate cre,
3860: csd_repair_estimate_lines crel,
3861: cs_estimate_details ced
3862: where cre.repair_estimate_id = crel.repair_estimate_id
3863: and crel.estimate_detail_id = ced.estimate_detail_id
3864: and cre.repair_line_id = p_repair_line_id ;
3865:

Line 4150: cs_estimate_details c

4146: b.repair_line_id,
4147: c.quantity_required
4148: FROM csd_repairs a,
4149: csd_product_transactions b,
4150: cs_estimate_details c
4151: where a.repair_line_id = b.repair_line_id
4152: and b.estimate_detail_id = c.estimate_detail_id
4153: and b.product_transaction_id = p_prod_txn_id;
4154:

Line 4183: cs_estimate_details c

4179: l_repair_line_id,
4180: l_prod_txn_qty
4181: FROM csd_repairs a,
4182: csd_product_transactions b,
4183: cs_estimate_details c
4184: where a.repair_line_id = b.repair_line_id
4185: and b.estimate_detail_id = c.estimate_detail_id
4186: and b.product_transaction_id = p_prod_txn_id ;
4187:

Line 4298: cs_estimate_details b

4294: CURSOR qty_by_type IS
4295: SELECT
4296: abs(sum(b.quantity_required))
4297: FROM csd_product_transactions a,
4298: cs_estimate_details b
4299: where a.estimate_detail_id = b.estimate_detail_id
4300: and a.action_code = 'CUST_PROD'
4301: and a.prod_txn_status <> 'CANCELLED'
4302: and a.action_type = p_action_type

Line 5775: cs_estimate_details ced,

5771: begin
5772: Select max(ced.order_header_id)
5773: into l_add_to_order_id
5774: from csd_repairs dr,
5775: cs_estimate_details ced,
5776: oe_order_headers_all ooh,
5777: oe_order_types_v oot,
5778: cs_incidents_all_b sr -- swai: bug 5931926
5779: where dr.repair_line_id = p_repair_line_id

Line 5810: cs_estimate_details ced,

5806:
5807: Select max(ced.order_header_id)
5808: into l_add_to_order_id
5809: from csd_repairs dr,
5810: cs_estimate_details ced,
5811: oe_order_headers_all ooh,
5812: oe_order_types_v oot,
5813: cs_incidents_all_b sr -- swai: bug 5931926
5814: where dr.repair_line_id = p_repair_line_id