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 5986: IF p_instance_rec.install_location_type_code = 'HZ_PARTY_SITES' OR

5982: -- Start addition by sk on 02/06/02 for bug 2213922
5983: IF p_instance_rec.install_location_type_code IS NOT NULL AND
5984: p_instance_rec.install_location_type_code <> fnd_api.g_miss_char
5985: THEN
5986: IF p_instance_rec.install_location_type_code = 'HZ_PARTY_SITES' OR
5987: p_instance_rec.install_location_type_code = 'HZ_LOCATIONS' OR
5988: p_instance_rec.install_location_type_code = 'VENDOR_SITE' OR
5989: p_instance_rec.install_location_type_code = 'INTERNAL_SITE' OR --4926773
5990: p_instance_rec.install_location_type_code = 'HR_LOCATIONS'

Line 13789: END IF; --HZ_PARTY_SITES

13785: ELSIF l_curr_instance_rec.operational_status_code IS NULL OR
13786: (l_curr_instance_rec.operational_status_code NOT IN ('NOT_USED','INSTALLED','OUT_OF_SERVICE','IN_SERVICE'))
13787: THEN
13788: p_instance_rec.operational_status_code := 'NOT_USED';
13789: END IF; --HZ_PARTY_SITES
13790: ELSIF l_get_instance_rec.location_type_code ='HZ_PARTY_SITES'
13791: THEN
13792: IF (p_instance_rec.operational_status_code IS NOT NULL AND
13793: p_instance_rec.operational_status_code <> fnd_api.g_miss_char)

Line 13790: ELSIF l_get_instance_rec.location_type_code ='HZ_PARTY_SITES'

13786: (l_curr_instance_rec.operational_status_code NOT IN ('NOT_USED','INSTALLED','OUT_OF_SERVICE','IN_SERVICE'))
13787: THEN
13788: p_instance_rec.operational_status_code := 'NOT_USED';
13789: END IF; --HZ_PARTY_SITES
13790: ELSIF l_get_instance_rec.location_type_code ='HZ_PARTY_SITES'
13791: THEN
13792: IF (p_instance_rec.operational_status_code IS NOT NULL AND
13793: p_instance_rec.operational_status_code <> fnd_api.g_miss_char)
13794: AND p_instance_rec.operational_status_code NOT IN ('NOT_USED','INSTALLED','OUT_OF_SERVICE','IN_SERVICE')

Line 13901: ELSIF l_get_instance_rec.location_type_code ='HZ_PARTY_SITES'

13897: (l_curr_instance_rec.operational_status_code NOT IN ('NOT_USED','OUT_OF_SERVICE','INSTALLED'))
13898: THEN
13899: p_instance_rec.operational_status_code := 'NOT_USED';
13900: END IF;
13901: ELSIF l_get_instance_rec.location_type_code ='HZ_PARTY_SITES'
13902: THEN
13903: IF (p_instance_rec.operational_status_code IS NOT NULL AND
13904: p_instance_rec.operational_status_code <> fnd_api.g_miss_char)
13905: AND p_instance_rec.operational_status_code NOT IN ('INSTALLED','OUT_OF_SERVICE','IN_SERVICE')

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

14472: -- Start addition by sk on 02/06/02 for bug 2213922
14473: IF p_instance_rec.install_location_type_code IS NOT NULL AND
14474: p_instance_rec.install_location_type_code <> fnd_api.g_miss_char
14475: THEN
14476: IF p_instance_rec.install_location_type_code = 'HZ_PARTY_SITES' OR
14477: p_instance_rec.install_location_type_code = 'HZ_LOCATIONS' OR
14478: p_instance_rec.install_location_type_code = 'VENDOR_SITE' OR
14479: p_instance_rec.install_location_type_code = 'INTERNAL_SITE' OR
14480: p_instance_rec.install_location_type_code = 'HR_LOCATIONS' --4926773

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

31658: l_new_ins_header_rec.inv_locator_name := NULL;
31659: END IF;
31660:
31661: IF (l_old_ins_header_rec.current_loc_number= fnd_api.g_miss_char)
31662: OR (nvl(l_old_ins_header_rec.location_type_code,'$$$$') <> 'HZ_PARTY_SITES')
31663: THEN
31664: l_old_ins_header_rec.current_loc_number := NULL;
31665: END IF;
31666:

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

31664: l_old_ins_header_rec.current_loc_number := NULL;
31665: END IF;
31666:
31667: IF (l_new_ins_header_rec.current_loc_number= fnd_api.g_miss_char)
31668: OR (nvl(l_new_ins_header_rec.location_type_code, '$$$$') <> 'HZ_PARTY_SITES')
31669: THEN
31670: l_new_ins_header_rec.current_loc_number := NULL;
31671: END IF;
31672:

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

31670: l_new_ins_header_rec.current_loc_number := NULL;
31671: END IF;
31672:
31673: IF (l_old_ins_header_rec.install_loc_number= fnd_api.g_miss_char)
31674: OR (nvl(l_old_ins_header_rec.install_location_type_code, '$$$$') <> 'HZ_PARTY_SITES')
31675: THEN
31676: l_old_ins_header_rec.install_loc_number := NULL;
31677: END IF;
31678:

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

31676: l_old_ins_header_rec.install_loc_number := NULL;
31677: END IF;
31678:
31679: IF (l_new_ins_header_rec.install_loc_number= fnd_api.g_miss_char)
31680: OR (nvl(l_new_ins_header_rec.install_location_type_code, '$$$$') <> 'HZ_PARTY_SITES')
31681: THEN
31682: l_new_ins_header_rec.install_loc_number := NULL;
31683: END IF;
31684: -- End of Addition for tar 14834588.600