APPS.CSD_COST_ANALYSIS_PVT dependencies on CSD_REPAIR_ESTIMATE_LINES

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 78: FROM CSD_REPAIR_ESTIMATE_LINES rel

74:
75: CURSOR cur_getNullCostRows(p_repair_estimate_id NUMBER)
76: IS
77: SELECT count(rel.estimate_detail_id)
78: FROM CSD_REPAIR_ESTIMATE_LINES rel
79: WHERE rel.repair_estimate_id = p_repair_estimate_id
80: AND rel.item_cost IS NULL
81: AND rownum = 1;
82:

Line 88: FROM CSD_REPAIR_ESTIMATE_LINES

84:
85: CURSOR cur_getEstLineCount(p_repair_Estimate_id NUMBER)
86: IS
87: SELECT count(repair_estimate_line_id)
88: FROM CSD_REPAIR_ESTIMATE_LINES
89: WHERE repair_estimate_id = p_repair_estimate_id
90: ANd rownum=1;
91: l_api_name CONSTANT VARCHAR2(30) := 'Get_TotalEstCosts';
92: l_api_version CONSTANT NUMBER := 1.0;

Line 357: FROM CSD_REPAIR_ESTIMATE_LINES

353: --Cursor to get teh line count for an estimate header.
354: CURSOR cur_getEstLineCount(p_repair_Estimate_id NUMBER)
355: IS
356: SELECT count(repair_estimate_line_id)
357: FROM CSD_REPAIR_ESTIMATE_LINES
358: WHERE repair_estimate_id = p_repair_estimate_id;
359:
360: --Cursor to get the charges, group by MLE.
361: CURSOR cur_getTotalCharges(p_repair_estimate_id NUMBER)

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

Line 820: /* inventory item in the charges curency. CSD_REPAIR_ESTIMATE_LINES */

816: /* procedure name: Get_InvItemCost */
817:
818: /* description : procedure used get item cost for an */
819:
820: /* inventory item in the charges curency. CSD_REPAIR_ESTIMATE_LINES */
821: /* table will be populated with the converted item_cost. */
822:
823: /* */
824: