eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_SR_FUL_PKG dependencies on CS_SR_INCIDENTS_V

Line 131: -- Enhancement 2188129. Replacing view cs_new_incidents_v with cs_sr_incidents_v

127: product_name,product_description,summary
128: from cs_incidents_v
129: where incident_id = l_incident_id;
130:
131: -- Enhancement 2188129. Replacing view cs_new_incidents_v with cs_sr_incidents_v
132: -- Added by pnkalari on 02/07/2002.
133: -- Added cursors cs_owner_csr,cs_account_csr,cs_person_name_csr,cs_product_csr.
134: -- ===============================================================================================
135:

Line 161: CS_SR_INCIDENTS_V

157: incident_date,
158: date_closed,
159: SUMMARY
160: FROM
161: CS_SR_INCIDENTS_V
162: WHERE
163: incident_id = l_incident_id;
164:
165: CURSOR cs_owner_csr is

Line 166: SELECT a.resource_name from cs_sr_owners_v a, cs_sr_incidents_v b

162: WHERE
163: incident_id = l_incident_id;
164:
165: CURSOR cs_owner_csr is
166: SELECT a.resource_name from cs_sr_owners_v a, cs_sr_incidents_v b
167: where a.resource_id = b.incident_owner_id
168: and b.incident_id = l_incident_id;
169:
170: CURSOR cs_account_csr is

Line 171: SELECT a.account_number from jtf_cust_accounts_all_v a, cs_sr_incidents_v b

167: where a.resource_id = b.incident_owner_id
168: and b.incident_id = l_incident_id;
169:
170: CURSOR cs_account_csr is
171: SELECT a.account_number from jtf_cust_accounts_all_v a, cs_sr_incidents_v b
172: where b.account_id = a.cust_account_id
173: and b.incident_id = l_incident_id;
174:
175: CURSOR cs_person_name_csr is

Line 177: cs_sr_incidents_v c

173: and b.incident_id = l_incident_id;
174:
175: CURSOR cs_person_name_csr is
176: SELECT a.sub_first_name, a.sub_last_name from csc_hz_parties_self_v a, cs_hz_sr_contact_points b,
177: cs_sr_incidents_v c
178: where b.incident_id = c.incident_id
179: and b.party_id = a.party_id
180: and b.primary_flag = 'Y'
181: and c.incident_id = l_incident_id ;

Line 184: SELECT a.concatenated_segments, a.description from mtl_system_items_kfv a, cs_sr_incidents_v b

180: and b.primary_flag = 'Y'
181: and c.incident_id = l_incident_id ;
182:
183: CURSOR cs_product_csr is
184: SELECT a.concatenated_segments, a.description from mtl_system_items_kfv a, cs_sr_incidents_v b
185: where a.inventory_item_id = b.inventory_item_id
186: and a.organization_id = CS_STD.Get_Item_Valdn_Orgzn_Id
187: and b.incident_id = l_incident_id;
188:

Line 343: cs_sr_incidents_v incident

339: CURSOR cs_platform_csr is
340: select incident.platform_version,item.concatenated_segments platform
341: from mtl_system_items_vl item,
342: mtl_item_categories ic,
343: cs_sr_incidents_v incident
344: where item.organization_id = fnd_profile.value('CS_INV_VALIDATION_ORG')
345: and item.serv_req_enabled_code = 'E'
346: and item.organization_id = ic.organization_id
347: and item.inventory_item_id = ic.inventory_item_id