[Home] [Help]
102: edt.quantity_required,
103: edt.selling_price,
104: nvl(edt.contract_discount_amount,0) contract_discount_amount,
105: edt.after_warranty_cost
106: FROM cs_estimate_details edt,
107: cs_incidents_all_b inc,
108: hz_parties hzp
109: WHERE edt.incident_id = inc.incident_id
110: AND edt.bill_to_party_id = hzp.party_id;
130: ced.currency_code,
131: sum(ced.after_warranty_cost) Total_Charges
132: FROM cs_incidents_all_b ciab,
133: cs_incident_types cit,
134: cs_estimate_details ced
135: WHERE ciab.incident_id = ced.incident_id
136: AND ciab.incident_type_id = cit.incident_type_id
137: AND ced.charge_line_type IN ('ACTUAL','IN_PROGRESS')
138: AND ced.incident_id = p_incident_id
151: edt.currency_code,
152: inc.incident_number,
153: inc.incident_date,
154: inc.incident_id
155: FROM cs_estimate_details edt,
156: cs_incidents_all_b inc
157: WHERE edt.incident_id = p_incident_id
158: AND inc.incident_id = edt.incident_id
159: GROUP BY currency_code,inc.incident_id,inc.incident_number,inc.incident_date;
185: -- Cursor for deriving no_charge_flag
186: CURSOR cs_charge_flags(p_estimate_detail_id number) IS
187: SELECT nvl(edt.no_charge_flag,'N') chg_no_charge_flag,
188: nvl(tt.no_charge_flag,'N') txn_no_charge_flag
189: FROM cs_estimate_details edt,
190: cs_transaction_types tt
191: WHERE edt.estimate_detail_id = p_estimate_detail_id
192: AND tt.transaction_type_id = edt.transaction_type_id;
193: --
302: ced.selling_price,
303: nvl(ced.contract_discount_amount,0) contract_discount_amount,
304: ced.after_warranty_cost
305: FROM cs_incidents_all_b ciab,
306: cs_estimate_details ced,
307: hz_parties hzp
308: WHERE ciab.incident_id = ced.incident_id
309: AND ced.bill_to_party_id = hzp.party_id
310: AND ced.line_submitted = 'N'
332: ced.selling_price,
333: nvl(ced.contract_discount_amount,0) contract_discount_amount,
334: ced.after_warranty_cost
335: FROM cs_incidents_all_b ciab,
336: cs_estimate_details ced,
337: hz_parties hzp
338: WHERE ciab.incident_id = ced.incident_id
339: AND ced.bill_to_party_id = hzp.party_id
340: AND ced.line_submitted = 'N'
373: ced.selling_price,
374: nvl(ced.contract_discount_amount,0) contract_discount_amount,
375: ced.after_warranty_cost
376: FROM cs_incidents_all_b ciab,
377: cs_estimate_details ced,
378: hz_parties hzp
379: WHERE ciab.incident_id = ced.incident_id
380: AND ced.bill_to_party_id = hzp.party_id
381: AND ced.line_submitted = 'N'
416: nvl(ced.contract_discount_amount,0) contract_discount_amount,
417: ced.after_warranty_cost
418: FROM cs_incidents_all_b ciab,
419: hz_parties hzp,
420: cs_estimate_details ced
421: WHERE ciab.incident_id = ced.incident_id
422: AND ced.bill_to_party_id = hzp.party_id
423: AND ciab.status_flag = 'C'
424: AND ced.line_submitted = 'N'
1285: -- Only actual charge lines are stamped with the restriction message
1286: -- Bug fix:3608980
1287: CURSOR Charge_Line_Count(p_incident_id NUMBER,p_currency_code VARCHAR2) IS
1288: SELECT estimate_detail_id
1289: FROM cs_estimate_details
1290: WHERE incident_id = p_incident_id
1291: AND charge_line_type = 'ACTUAL'
1292: AND source_code = 'SD'
1293: AND original_source_code = 'SR'
1318:
1319:
1320: IF p_restriction_type = 'LINE' THEN
1321:
1322: UPDATE CS_ESTIMATE_DETAILS
1323: SET submit_restriction_message = (submit_restriction_message || lx_msg_data),
1324: line_submitted = p_line_submitted
1325: WHERE Estimate_Detail_Id = p_estimate_detail_id
1326: AND incident_id = p_incident_id;
1336: INTO chglnctTAB(t);
1337: EXIT WHEN Charge_Line_Count%NOTFOUND;
1338:
1339:
1340: UPDATE CS_ESTIMATE_DETAILS
1341: SET submit_restriction_message = (submit_restriction_message || lx_msg_data),
1342: line_submitted = p_line_submitted
1343: WHERE incident_id = p_incident_id
1344: AND estimate_detail_id = chglnctTAB(t).estimate_detail_id;
1358: FETCH Charge_Line_Count
1359: INTO chglnctTAB(t);
1360: EXIT WHEN Charge_Line_Count%NOTFOUND;
1361:
1362: UPDATE CS_ESTIMATE_DETAILS
1363: SET submit_restriction_message = NULL,
1364: line_submitted = p_line_submitted
1365: WHERE incident_id = p_incident_id
1366: AND estimate_detail_id = chglnctTAB(t).estimate_detail_id; -- For bug 5697830