DBA Data[Home] [Help]

APPS.CS_SR_COST_CP dependencies on CS_INCIDENTS_ALL_B

Line 1490: FROM cs_incidents_all_b cia

1486:
1487:
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'

Line 1887: , cs_incidents_all_b cia

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
1891: css.status = 'E'