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.OKL_SERVICE_INTEGRATION_PVT dependencies on HZ_PARTY_SITES

Line 2311: FROM hz_party_sites hps,

2307: WHERE install_location_type_code = 'HZ_LOCATIONS'
2308: AND csi.owner_party_source_table = 'HZ_PARTIES'
2309: AND hl.location_id = csi.install_location_id
2310: AND NOT EXISTS (SELECT 1
2311: FROM hz_party_sites hps,
2312: hz_party_site_uses hpsu
2313: WHERE hps.location_id = hl.location_id
2314: AND hps.party_id = csi.owner_party_id
2315: AND hpsu.party_site_id = hps.party_site_id

Line 2321: CURSOR hz_party_site_csr (p_instance_id NUMBER) IS -- for location type = 'HZ_PARTY_SITES'

2317: AND NVL(hpsu.status,'X') = 'A'
2318: )
2319: AND csi.instance_id = p_instance_id;
2320:
2321: CURSOR hz_party_site_csr (p_instance_id NUMBER) IS -- for location type = 'HZ_PARTY_SITES'
2322: SELECT hps.location_id
2323: FROM csi_item_instances csi,
2324: hz_party_sites hps
2325: WHERE install_location_type_code = 'HZ_PARTY_SITES'

Line 2324: hz_party_sites hps

2320:
2321: CURSOR hz_party_site_csr (p_instance_id NUMBER) IS -- for location type = 'HZ_PARTY_SITES'
2322: SELECT hps.location_id
2323: FROM csi_item_instances csi,
2324: hz_party_sites hps
2325: WHERE install_location_type_code = 'HZ_PARTY_SITES'
2326: AND csi.owner_party_source_table = 'HZ_PARTIES'
2327: AND csi.install_location_id = hps.party_site_id
2328: AND csi.owner_party_id = hps.party_id

Line 2325: WHERE install_location_type_code = 'HZ_PARTY_SITES'

2321: CURSOR hz_party_site_csr (p_instance_id NUMBER) IS -- for location type = 'HZ_PARTY_SITES'
2322: SELECT hps.location_id
2323: FROM csi_item_instances csi,
2324: hz_party_sites hps
2325: WHERE install_location_type_code = 'HZ_PARTY_SITES'
2326: AND csi.owner_party_source_table = 'HZ_PARTIES'
2327: AND csi.install_location_id = hps.party_site_id
2328: AND csi.owner_party_id = hps.party_id
2329: AND NOT EXISTS (SELECT 1

Line 2393: ELSIF (l_location_type_code = 'HZ_PARTY_SITES') THEN

2389: END LOOP;
2390: RAISE instance_failed;
2391: END IF;
2392: CLOSE hz_loc_csr;
2393: ELSIF (l_location_type_code = 'HZ_PARTY_SITES') THEN
2394: OPEN hz_party_site_csr (p_instance_id);
2395: FETCH hz_party_site_csr INTO l_hz_loc_id;
2396: IF hz_party_site_csr%FOUND THEN
2397: -- Raise Error