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.CUG_GENERIC_WF_PKG dependencies on HZ_LOCATIONS

Line 44: FROM HZ_LOCATIONS WHERE LOCATION_ID = l_install_site_use_id;

40: WHERE INCIDENT_ID = l_request_id;
41:
42: CURSOR l_IncidentAddress_csr IS
43: SELECT ADDRESS1, ADDRESS2, CITY, STATE, COUNTRY, POSTAL_CODE
44: FROM HZ_LOCATIONS WHERE LOCATION_ID = l_install_site_use_id;
45: l_IncidentAddress_rec l_IncidentAddress_csr%ROWTYPE;
46: */
47:
48: CURSOR l_ServiceRequest_csr IS

Line 567: HZ_LOCATIONS where LOCATION_ID = l_install_at_site_id;

563: -- Begin of changes by ANEEMUCH date 10-May-2002
564: /*
565: CURSOR l_IncidentAddress_csr IS
566: select ADDRESS1, ADDRESS2, CITY, STATE, POSTAL_CODE, COUNTRY FROM
567: HZ_LOCATIONS where LOCATION_ID = l_install_at_site_id;
568: l_IncidentAddress_rec l_IncidentAddress_csr%ROWTYPE;
569:
570: CURSOR l_IncidentId_csr IS
571: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER

Line 572: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS

568: l_IncidentAddress_rec l_IncidentAddress_csr%ROWTYPE;
569:
570: CURSOR l_IncidentId_csr IS
571: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
572: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS
573: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INSTALL_SITE_USE_ID AND
574: HZ_LOCATIONS.ADDRESS1 = l_IncidentAddress_rec.Address1 AND
575: nvl(HZ_LOCATIONS.ADDRESS2, 'Not Filled') = nvl(l_IncidentAddress_rec.Address2, 'Not Filled') AND
576: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_IncidentAddress_rec.City, 'Not Filled') AND

Line 573: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INSTALL_SITE_USE_ID AND

569:
570: CURSOR l_IncidentId_csr IS
571: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
572: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS
573: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INSTALL_SITE_USE_ID AND
574: HZ_LOCATIONS.ADDRESS1 = l_IncidentAddress_rec.Address1 AND
575: nvl(HZ_LOCATIONS.ADDRESS2, 'Not Filled') = nvl(l_IncidentAddress_rec.Address2, 'Not Filled') AND
576: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_IncidentAddress_rec.City, 'Not Filled') AND
577: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_IncidentAddress_rec.State, 'Not Filled') AND

Line 574: HZ_LOCATIONS.ADDRESS1 = l_IncidentAddress_rec.Address1 AND

570: CURSOR l_IncidentId_csr IS
571: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
572: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS
573: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INSTALL_SITE_USE_ID AND
574: HZ_LOCATIONS.ADDRESS1 = l_IncidentAddress_rec.Address1 AND
575: nvl(HZ_LOCATIONS.ADDRESS2, 'Not Filled') = nvl(l_IncidentAddress_rec.Address2, 'Not Filled') AND
576: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_IncidentAddress_rec.City, 'Not Filled') AND
577: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_IncidentAddress_rec.State, 'Not Filled') AND
578: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_IncidentAddress_rec.Postal_Code, 'Not Filled') AND

Line 575: nvl(HZ_LOCATIONS.ADDRESS2, 'Not Filled') = nvl(l_IncidentAddress_rec.Address2, 'Not Filled') AND

571: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
572: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS
573: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INSTALL_SITE_USE_ID AND
574: HZ_LOCATIONS.ADDRESS1 = l_IncidentAddress_rec.Address1 AND
575: nvl(HZ_LOCATIONS.ADDRESS2, 'Not Filled') = nvl(l_IncidentAddress_rec.Address2, 'Not Filled') AND
576: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_IncidentAddress_rec.City, 'Not Filled') AND
577: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_IncidentAddress_rec.State, 'Not Filled') AND
578: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_IncidentAddress_rec.Postal_Code, 'Not Filled') AND
579: -- HZ_LOCATIONS.COUNTRY = l_IncidentAddress_rec.Country AND

Line 576: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_IncidentAddress_rec.City, 'Not Filled') AND

572: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS
573: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INSTALL_SITE_USE_ID AND
574: HZ_LOCATIONS.ADDRESS1 = l_IncidentAddress_rec.Address1 AND
575: nvl(HZ_LOCATIONS.ADDRESS2, 'Not Filled') = nvl(l_IncidentAddress_rec.Address2, 'Not Filled') AND
576: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_IncidentAddress_rec.City, 'Not Filled') AND
577: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_IncidentAddress_rec.State, 'Not Filled') AND
578: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_IncidentAddress_rec.Postal_Code, 'Not Filled') AND
579: -- HZ_LOCATIONS.COUNTRY = l_IncidentAddress_rec.Country AND
580: CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND

Line 577: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_IncidentAddress_rec.State, 'Not Filled') AND

573: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INSTALL_SITE_USE_ID AND
574: HZ_LOCATIONS.ADDRESS1 = l_IncidentAddress_rec.Address1 AND
575: nvl(HZ_LOCATIONS.ADDRESS2, 'Not Filled') = nvl(l_IncidentAddress_rec.Address2, 'Not Filled') AND
576: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_IncidentAddress_rec.City, 'Not Filled') AND
577: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_IncidentAddress_rec.State, 'Not Filled') AND
578: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_IncidentAddress_rec.Postal_Code, 'Not Filled') AND
579: -- HZ_LOCATIONS.COUNTRY = l_IncidentAddress_rec.Country AND
580: CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
581: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND

Line 578: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_IncidentAddress_rec.Postal_Code, 'Not Filled') AND

574: HZ_LOCATIONS.ADDRESS1 = l_IncidentAddress_rec.Address1 AND
575: nvl(HZ_LOCATIONS.ADDRESS2, 'Not Filled') = nvl(l_IncidentAddress_rec.Address2, 'Not Filled') AND
576: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_IncidentAddress_rec.City, 'Not Filled') AND
577: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_IncidentAddress_rec.State, 'Not Filled') AND
578: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_IncidentAddress_rec.Postal_Code, 'Not Filled') AND
579: -- HZ_LOCATIONS.COUNTRY = l_IncidentAddress_rec.Country AND
580: CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
581: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
582: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id;

Line 579: -- HZ_LOCATIONS.COUNTRY = l_IncidentAddress_rec.Country AND

575: nvl(HZ_LOCATIONS.ADDRESS2, 'Not Filled') = nvl(l_IncidentAddress_rec.Address2, 'Not Filled') AND
576: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_IncidentAddress_rec.City, 'Not Filled') AND
577: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_IncidentAddress_rec.State, 'Not Filled') AND
578: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_IncidentAddress_rec.Postal_Code, 'Not Filled') AND
579: -- HZ_LOCATIONS.COUNTRY = l_IncidentAddress_rec.Country AND
580: CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
581: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
582: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id;
583: l_IncidentId_rec l_IncidentId_csr%ROWTYPE;

Line 601: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS

597: l_IncidentAddress_rec l_IncidentAddress_csr%ROWTYPE;
598:
599: CURSOR l_IncidentId_csr IS
600: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
601: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS
602: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID AND
603: nvl(HZ_LOCATIONS.ADDRESS1, 'Not Filled') = nvl(l_incident_address, 'Not Filled') AND
604: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_incident_city, 'Not Filled') AND
605: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_incident_state, 'Not Filled') AND

Line 602: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID AND

598:
599: CURSOR l_IncidentId_csr IS
600: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
601: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS
602: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID AND
603: nvl(HZ_LOCATIONS.ADDRESS1, 'Not Filled') = nvl(l_incident_address, 'Not Filled') AND
604: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_incident_city, 'Not Filled') AND
605: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_incident_state, 'Not Filled') AND
606: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_incident_postal_Code, 'Not Filled') AND

Line 603: nvl(HZ_LOCATIONS.ADDRESS1, 'Not Filled') = nvl(l_incident_address, 'Not Filled') AND

599: CURSOR l_IncidentId_csr IS
600: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
601: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS
602: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID AND
603: nvl(HZ_LOCATIONS.ADDRESS1, 'Not Filled') = nvl(l_incident_address, 'Not Filled') AND
604: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_incident_city, 'Not Filled') AND
605: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_incident_state, 'Not Filled') AND
606: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_incident_postal_Code, 'Not Filled') AND
607: nvl(HZ_LOCATIONS.COUNTRY, 'Not Filled') = nvl(l_incident_country, 'Not Filled') AND

Line 604: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_incident_city, 'Not Filled') AND

600: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
601: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS
602: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID AND
603: nvl(HZ_LOCATIONS.ADDRESS1, 'Not Filled') = nvl(l_incident_address, 'Not Filled') AND
604: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_incident_city, 'Not Filled') AND
605: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_incident_state, 'Not Filled') AND
606: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_incident_postal_Code, 'Not Filled') AND
607: nvl(HZ_LOCATIONS.COUNTRY, 'Not Filled') = nvl(l_incident_country, 'Not Filled') AND
608: CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND

Line 605: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_incident_state, 'Not Filled') AND

601: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS
602: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID AND
603: nvl(HZ_LOCATIONS.ADDRESS1, 'Not Filled') = nvl(l_incident_address, 'Not Filled') AND
604: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_incident_city, 'Not Filled') AND
605: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_incident_state, 'Not Filled') AND
606: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_incident_postal_Code, 'Not Filled') AND
607: nvl(HZ_LOCATIONS.COUNTRY, 'Not Filled') = nvl(l_incident_country, 'Not Filled') AND
608: CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
609: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND

Line 606: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_incident_postal_Code, 'Not Filled') AND

602: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID AND
603: nvl(HZ_LOCATIONS.ADDRESS1, 'Not Filled') = nvl(l_incident_address, 'Not Filled') AND
604: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_incident_city, 'Not Filled') AND
605: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_incident_state, 'Not Filled') AND
606: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_incident_postal_Code, 'Not Filled') AND
607: nvl(HZ_LOCATIONS.COUNTRY, 'Not Filled') = nvl(l_incident_country, 'Not Filled') AND
608: CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
609: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
610: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id

Line 607: nvl(HZ_LOCATIONS.COUNTRY, 'Not Filled') = nvl(l_incident_country, 'Not Filled') AND

603: nvl(HZ_LOCATIONS.ADDRESS1, 'Not Filled') = nvl(l_incident_address, 'Not Filled') AND
604: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_incident_city, 'Not Filled') AND
605: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_incident_state, 'Not Filled') AND
606: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_incident_postal_Code, 'Not Filled') AND
607: nvl(HZ_LOCATIONS.COUNTRY, 'Not Filled') = nvl(l_incident_country, 'Not Filled') AND
608: CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
609: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
610: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id
611: UNION