DBA Data[Home] [Help]

APPS.CS_SR_COST_CP dependencies on CS_ESTIMATE_DETAILS

Line 1492: ,cs_estimate_details ced

1488: CURSOR get_estimate_id IS
1489: SELECT ced.estimate_detail_id
1490: FROM cs_incidents_all_b cia
1491: ,cs_incident_statuses cis
1492: ,cs_estimate_details ced
1493: WHERE Nvl(cis.close_flag,'N') IN (decode( p_sr_status,'OPEN','N','CLOSED','Y' ,'ALL',Nvl(cis.close_flag,'N')))
1494: and cis.incident_subtype='INC'
1495: and cia.incident_status_id = cis.incident_status_id
1496: and cia.incident_id = ced.incident_id

Line 1886: , cs_estimate_Details ced

1882: -- , t.summary summary
1883:
1884: FROM
1885: cs_cost_staging css
1886: , cs_estimate_Details ced
1887: , cs_incidents_all_b cia
1888: -- , mtl_system_items_b i
1889: -- , hz_parties p
1890: WHERE