APPS.CS_CHG_AUTO_SUB_CON_PKG dependencies on CS_INCIDENTS_ALL_B

Line 109: cs_incidents_all_b inc,

105: edt.selling_price,
106: nvl(edt.contract_discount_amount,0) contract_discount_amount,
107: edt.after_warranty_cost
108: FROM cs_estimate_details edt,
109: cs_incidents_all_b inc,
110: hz_parties hzp
111: WHERE edt.incident_id = inc.incident_id
112: AND edt.bill_to_party_id = hzp.party_id;
113:

Line 134: FROM cs_incidents_all_b ciab,

130: nvl(trunc(ciab.incident_date),trunc(ciab.creation_date)) incident_date,
131: ciab.creation_date,
132: ced.currency_code,
133: sum(ced.after_warranty_cost) Total_Charges
134: FROM cs_incidents_all_b ciab,
135: cs_incident_types cit,
136: cs_estimate_details ced
137: WHERE ciab.incident_id = ced.incident_id
138: AND ciab.incident_type_id = cit.incident_type_id

Line 158: cs_incidents_all_b inc

154: inc.incident_number,
155: inc.incident_date,
156: inc.incident_id
157: FROM cs_estimate_details edt,
158: cs_incidents_all_b inc
159: WHERE edt.incident_id = p_incident_id
160: AND inc.incident_id = edt.incident_id
161: GROUP BY currency_code,inc.incident_id,inc.incident_number,inc.incident_date;
162:

Line 307: FROM cs_incidents_all_b ciab,

303: ced.quantity_required,
304: ced.selling_price,
305: nvl(ced.contract_discount_amount,0) contract_discount_amount,
306: ced.after_warranty_cost
307: FROM cs_incidents_all_b ciab,
308: cs_estimate_details ced,
309: hz_parties hzp
310: WHERE ciab.incident_id = ced.incident_id
311: AND ced.bill_to_party_id = hzp.party_id

Line 338: FROM cs_incidents_all_b ciab,

334: ced.quantity_required,
335: ced.selling_price,
336: nvl(ced.contract_discount_amount,0) contract_discount_amount,
337: ced.after_warranty_cost
338: FROM cs_incidents_all_b ciab,
339: cs_estimate_details ced,
340: hz_parties hzp
341: WHERE ciab.incident_id = ced.incident_id
342: AND ced.bill_to_party_id = hzp.party_id

Line 380: FROM cs_incidents_all_b ciab,

376: ced.quantity_required,
377: ced.selling_price,
378: nvl(ced.contract_discount_amount,0) contract_discount_amount,
379: ced.after_warranty_cost
380: FROM cs_incidents_all_b ciab,
381: cs_estimate_details ced,
382: hz_parties hzp
383: WHERE ciab.incident_id = ced.incident_id
384: AND ced.bill_to_party_id = hzp.party_id

Line 423: FROM cs_incidents_all_b ciab,

419: ced.quantity_required,
420: ced.selling_price,
421: nvl(ced.contract_discount_amount,0) contract_discount_amount,
422: ced.after_warranty_cost
423: FROM cs_incidents_all_b ciab,
424: hz_parties hzp,
425: cs_estimate_details ced
426: WHERE ciab.incident_id = ced.incident_id
427: AND ced.bill_to_party_id = hzp.party_id

Line 1429: from cs_incidents_all_b inc

1425: x_msg_data OUT NOCOPY VARCHAR2) IS
1426:
1427: CURSOR SR_VAL(p_incident_id number) IS
1428: select inc.customer_id,inc.account_id,inc.incident_number
1429: from cs_incidents_all_b inc
1430: where inc.incident_id = p_incident_id;
1431:
1432: l_account_id NUMBER;
1433: l_party_id NUMBER;