APPS.CS_CHG_AUTO_SUB_CON_PKG dependencies on CS_INCIDENTS_ALL_B

Line 107: cs_incidents_all_b inc,

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;
111:

Line 132: FROM cs_incidents_all_b ciab,

128: nvl(trunc(ciab.incident_date),trunc(ciab.creation_date)) incident_date,
129: ciab.creation_date,
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

Line 156: cs_incidents_all_b inc

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;
160:

Line 305: FROM cs_incidents_all_b ciab,

301: ced.quantity_required,
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

Line 335: FROM cs_incidents_all_b ciab,

331: ced.quantity_required,
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

Line 376: FROM cs_incidents_all_b ciab,

372: ced.quantity_required,
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

Line 418: FROM cs_incidents_all_b ciab,

414: ced.quantity_required,
415: ced.selling_price,
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

Line 1410: from cs_incidents_all_b inc

1406: x_msg_data OUT NOCOPY VARCHAR2) IS
1407:
1408: CURSOR SR_VAL(p_incident_id number) IS
1409: select inc.customer_id,inc.account_id,inc.incident_number
1410: from cs_incidents_all_b inc
1411: where inc.incident_id = p_incident_id;
1412:
1413: l_account_id NUMBER;
1414: l_party_id NUMBER;