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

Line 2257: hz_party_sites hps,

2253: p_instance_header_tbl(tab_row).current_loc_number,
2254: p_instance_header_tbl(tab_row).current_party_name,
2255: p_instance_header_tbl(tab_row).current_party_number
2256: FROM hz_locations hzl,
2257: hz_party_sites hps,
2258: hz_parties hzp
2259: WHERE hzl.location_id = hps.location_id(+) --(+)added for bug 5213645
2260: AND hps.party_id = hzp.party_id(+)
2261: AND hzl.location_id = p_instance_header_tbl(tab_row).location_id

Line 2296: hz_party_sites hps,

2292: p_instance_header_tbl(tab_row).install_loc_number,
2293: p_instance_header_tbl(tab_row).install_party_name,
2294: p_instance_header_tbl(tab_row).install_party_number
2295: FROM hz_locations hzl,
2296: hz_party_sites hps,
2297: hz_parties hzp
2298: WHERE hzl.location_id = hps.location_id(+) --(+)added for bug 5213645
2299: AND hps.party_id = hzp.party_id(+)
2300: AND hzl.location_id = p_instance_header_tbl(tab_row).install_location_id

Line 2358: IF p_instance_header_tbl(tab_row).location_type_code = 'HZ_PARTY_SITES' THEN

2354: NULL;
2355: END;
2356: END IF;
2357:
2358: IF p_instance_header_tbl(tab_row).location_type_code = 'HZ_PARTY_SITES' THEN
2359: BEGIN
2360: SELECT
2361: hzl.address1,
2362: hzl.address2,

Line 2384: hz_party_sites hps,

2380: p_instance_header_tbl(tab_row).current_loc_number,
2381: p_instance_header_tbl(tab_row).current_party_name,
2382: p_instance_header_tbl(tab_row).current_party_number
2383: FROM hz_locations hzl,
2384: hz_party_sites hps,
2385: hz_parties hzp
2386: WHERE hps.location_id = hzl.location_id
2387: AND hps.party_id = hzp.party_id
2388: AND hps.party_site_id = p_instance_header_tbl(tab_row).location_id;

Line 2396: IF p_instance_header_tbl(tab_row).install_location_type_code = 'HZ_PARTY_SITES' THEN

2392: NULL;
2393: END;
2394: END IF;
2395:
2396: IF p_instance_header_tbl(tab_row).install_location_type_code = 'HZ_PARTY_SITES' THEN
2397: BEGIN
2398: SELECT
2399: hzl.address1,
2400: hzl.address2,

Line 2422: hz_party_sites hps,

2418: p_instance_header_tbl(tab_row).install_loc_number,
2419: p_instance_header_tbl(tab_row).install_party_name,
2420: p_instance_header_tbl(tab_row).install_party_number
2421: FROM hz_locations hzl,
2422: hz_party_sites hps,
2423: hz_parties hzp
2424: WHERE hps.location_id = hzl.location_id
2425: AND hps.party_id = hzp.party_id
2426: AND hps.party_site_id = p_instance_header_tbl(tab_row).install_location_id;

Line 5922: IF p_instance_rec.install_location_type_code = 'HZ_PARTY_SITES' OR

5918: -- Start addition by sk on 02/06/02 for bug 2213922
5919: IF p_instance_rec.install_location_type_code IS NOT NULL AND
5920: p_instance_rec.install_location_type_code <> fnd_api.g_miss_char
5921: THEN
5922: IF p_instance_rec.install_location_type_code = 'HZ_PARTY_SITES' OR
5923: p_instance_rec.install_location_type_code = 'HZ_LOCATIONS' OR
5924: p_instance_rec.install_location_type_code = 'VENDOR_SITE' OR
5925: p_instance_rec.install_location_type_code = 'INTERNAL_SITE' OR --4926773
5926: p_instance_rec.install_location_type_code = 'HR_LOCATIONS'

Line 13406: END IF; --HZ_PARTY_SITES

13402: ELSIF l_curr_instance_rec.operational_status_code IS NULL OR
13403: (l_curr_instance_rec.operational_status_code NOT IN ('NOT_USED','INSTALLED','OUT_OF_SERVICE','IN_SERVICE'))
13404: THEN
13405: p_instance_rec.operational_status_code := 'NOT_USED';
13406: END IF; --HZ_PARTY_SITES
13407: ELSIF l_get_instance_rec.location_type_code ='HZ_PARTY_SITES'
13408: THEN
13409: IF (p_instance_rec.operational_status_code IS NOT NULL AND
13410: p_instance_rec.operational_status_code <> fnd_api.g_miss_char)

Line 13407: ELSIF l_get_instance_rec.location_type_code ='HZ_PARTY_SITES'

13403: (l_curr_instance_rec.operational_status_code NOT IN ('NOT_USED','INSTALLED','OUT_OF_SERVICE','IN_SERVICE'))
13404: THEN
13405: p_instance_rec.operational_status_code := 'NOT_USED';
13406: END IF; --HZ_PARTY_SITES
13407: ELSIF l_get_instance_rec.location_type_code ='HZ_PARTY_SITES'
13408: THEN
13409: IF (p_instance_rec.operational_status_code IS NOT NULL AND
13410: p_instance_rec.operational_status_code <> fnd_api.g_miss_char)
13411: AND p_instance_rec.operational_status_code NOT IN ('NOT_USED','INSTALLED','OUT_OF_SERVICE','IN_SERVICE')

Line 13518: ELSIF l_get_instance_rec.location_type_code ='HZ_PARTY_SITES'

13514: (l_curr_instance_rec.operational_status_code NOT IN ('NOT_USED','OUT_OF_SERVICE','INSTALLED'))
13515: THEN
13516: p_instance_rec.operational_status_code := 'NOT_USED';
13517: END IF;
13518: ELSIF l_get_instance_rec.location_type_code ='HZ_PARTY_SITES'
13519: THEN
13520: IF (p_instance_rec.operational_status_code IS NOT NULL AND
13521: p_instance_rec.operational_status_code <> fnd_api.g_miss_char)
13522: AND p_instance_rec.operational_status_code NOT IN ('INSTALLED','OUT_OF_SERVICE','IN_SERVICE')

Line 14082: IF p_instance_rec.install_location_type_code = 'HZ_PARTY_SITES' OR

14078: -- Start addition by sk on 02/06/02 for bug 2213922
14079: IF p_instance_rec.install_location_type_code IS NOT NULL AND
14080: p_instance_rec.install_location_type_code <> fnd_api.g_miss_char
14081: THEN
14082: IF p_instance_rec.install_location_type_code = 'HZ_PARTY_SITES' OR
14083: p_instance_rec.install_location_type_code = 'HZ_LOCATIONS' OR
14084: p_instance_rec.install_location_type_code = 'VENDOR_SITE' OR
14085: p_instance_rec.install_location_type_code = 'INTERNAL_SITE' OR
14086: p_instance_rec.install_location_type_code = 'HR_LOCATIONS' --4926773

Line 31060: OR (nvl(l_old_ins_header_rec.location_type_code,'$$$$') <> 'HZ_PARTY_SITES')

31056: l_new_ins_header_rec.inv_locator_name := NULL;
31057: END IF;
31058:
31059: IF (l_old_ins_header_rec.current_loc_number= fnd_api.g_miss_char)
31060: OR (nvl(l_old_ins_header_rec.location_type_code,'$$$$') <> 'HZ_PARTY_SITES')
31061: THEN
31062: l_old_ins_header_rec.current_loc_number := NULL;
31063: END IF;
31064:

Line 31066: OR (nvl(l_new_ins_header_rec.location_type_code, '$$$$') <> 'HZ_PARTY_SITES')

31062: l_old_ins_header_rec.current_loc_number := NULL;
31063: END IF;
31064:
31065: IF (l_new_ins_header_rec.current_loc_number= fnd_api.g_miss_char)
31066: OR (nvl(l_new_ins_header_rec.location_type_code, '$$$$') <> 'HZ_PARTY_SITES')
31067: THEN
31068: l_new_ins_header_rec.current_loc_number := NULL;
31069: END IF;
31070:

Line 31072: OR (nvl(l_old_ins_header_rec.install_location_type_code, '$$$$') <> 'HZ_PARTY_SITES')

31068: l_new_ins_header_rec.current_loc_number := NULL;
31069: END IF;
31070:
31071: IF (l_old_ins_header_rec.install_loc_number= fnd_api.g_miss_char)
31072: OR (nvl(l_old_ins_header_rec.install_location_type_code, '$$$$') <> 'HZ_PARTY_SITES')
31073: THEN
31074: l_old_ins_header_rec.install_loc_number := NULL;
31075: END IF;
31076:

Line 31078: OR (nvl(l_new_ins_header_rec.install_location_type_code, '$$$$') <> 'HZ_PARTY_SITES')

31074: l_old_ins_header_rec.install_loc_number := NULL;
31075: END IF;
31076:
31077: IF (l_new_ins_header_rec.install_loc_number= fnd_api.g_miss_char)
31078: OR (nvl(l_new_ins_header_rec.install_location_type_code, '$$$$') <> 'HZ_PARTY_SITES')
31079: THEN
31080: l_new_ins_header_rec.install_loc_number := NULL;
31081: END IF;
31082: -- End of Addition for tar 14834588.600