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_DUP_CHK_PVT dependencies on CSI_ITEM_INSTANCES

Line 918: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst

914:
915:
916: Cursor l_dup_sr_InstSerNum_csr is
917: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
918: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst
919: where sr.incident_id = sr_link.subject_id(+) and
920: sr_link.subject_type(+) = 'SR' and
921: sr_link.link_type(+) = 'DUP' and
922: sr_link.end_date_active(+) is null and

Line 933: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst

929: l_dup_sr_InstSerNum_rec l_dup_sr_InstSerNum_csr%rowtype;
930:
931: Cursor l_dup_sr_InstSerNumUpd_csr is
932: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
933: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst
934: where sr.incident_id = sr_link.subject_id(+) and
935: sr_link.subject_type(+) = 'SR' and
936: sr_link.link_type(+) = 'DUP' and
937: sr_link.end_date_active(+) is null and

Line 1328: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst

1324: l_dup_sr_custprodsrupd_rec l_dup_sr_custprodsrUpd_csr%rowtype;
1325:
1326: Cursor l_dup_sr_CustProdInsSer_csr is
1327: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1328: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst
1329: where sr.incident_id = sr_link.subject_id(+) and
1330: sr_link.subject_type(+) = 'SR' and
1331: sr_link.link_type(+) = 'DUP' and
1332: sr_link.end_date_active(+) is null and

Line 1345: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst

1341: l_dup_sr_CustProdInsSer_rec l_dup_sr_CustProdInsSer_csr%rowtype;
1342:
1343: Cursor l_dup_sr_CustProdInsSerUpd_csr is
1344: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1345: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst
1346: where sr.incident_id = sr_link.subject_id(+) and
1347: sr_link.subject_type(+) = 'SR' and
1348: sr_link.link_type(+) = 'DUP' and
1349: sr_link.end_date_active(+) is null and