DBA Data[Home] [Help]

APPS.CSD_COST_ANALYSIS_PVT dependencies on CS_ESTIMATE_DETAILS

Line 65: FROM CSD_REPAIR_ESTIMATE_LINES rel, CS_ESTIMATE_DETAILS ed,

61: CURSOR cur_getTotalCost(p_repair_estimate_id NUMBER)
62: IS
63: SELECT btc.billing_category,
64: sum(rel.item_Cost * ed.quantity_required) TotalCost -- sangita
65: FROM CSD_REPAIR_ESTIMATE_LINES rel, CS_ESTIMATE_DETAILS ed,
66: CS_BILLING_TYPE_CATEGORIES btc, CS_TXN_BILLING_TYPES btt
67: WHERE rel.repair_estimate_id = p_repair_estimate_id
68: AND rel.estimate_detail_id = ed.estimate_detail_id
69: AND ed.txn_billing_type_id = btt.txn_billing_type_id

Line 365: FROM CSD_REPAIR_ESTIMATE_LINES rel, CS_ESTIMATE_DETAILS ed,

361: CURSOR cur_getTotalCharges(p_repair_estimate_id NUMBER)
362: IS
363: SELECT btc.billing_category,
364: sum(nvl(ed.after_warranty_cost, 0)) TotalCharges
365: FROM CSD_REPAIR_ESTIMATE_LINES rel, CS_ESTIMATE_DETAILS ed,
366: CS_BILLING_TYPE_CATEGORIES btc, CS_TXN_BILLING_TYPES btt
367: WHERE rel.repair_estimate_id = p_repair_estimate_id
368: AND rel.estimate_detail_id = ed.estimate_detail_id
369: AND ed.txn_billing_type_id = btt.txn_billing_type_id