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_LOCATIONS

Line 2231: IF p_instance_header_tbl(tab_row).location_type_code = 'HZ_LOCATIONS' THEN

2227: null;
2228: End;
2229: END IF;
2230: --
2231: IF p_instance_header_tbl(tab_row).location_type_code = 'HZ_LOCATIONS' THEN
2232: BEGIN
2233: SELECT
2234: hzl.address1,
2235: hzl.address2,

Line 2256: FROM hz_locations hzl,

2252: p_instance_header_tbl(tab_row).current_loc_country,
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(+)

Line 2270: IF p_instance_header_tbl(tab_row).install_location_type_code = 'HZ_LOCATIONS' THEN

2266: NULL;
2267: END;
2268: END IF;
2269:
2270: IF p_instance_header_tbl(tab_row).install_location_type_code = 'HZ_LOCATIONS' THEN
2271: BEGIN
2272: SELECT
2273: hzl.address1,
2274: hzl.address2,

Line 2295: FROM hz_locations hzl,

2291: p_instance_header_tbl(tab_row).install_loc_country,
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(+)

Line 2383: FROM hz_locations hzl,

2379: p_instance_header_tbl(tab_row).current_loc_country,
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

Line 2421: FROM hz_locations hzl,

2417: p_instance_header_tbl(tab_row).install_loc_country,
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

Line 5752: ELSIF p_instance_rec.location_type_code IN ('INVENTORY','HZ_LOCATIONS')

5748: ELSIF p_instance_rec.location_type_code IN ('PROJECT')
5749: AND p_instance_rec.operational_status_code ='IN_SERVICE'
5750: THEN
5751: p_instance_rec.operational_status_code := 'NOT_USED';
5752: ELSIF p_instance_rec.location_type_code IN ('INVENTORY','HZ_LOCATIONS')
5753: AND p_instance_rec.operational_status_code NOT IN ('NOT_USED','INSTALLED','OUT_OF_SERVICE','IN_SERVICE')
5754: THEN
5755: p_instance_rec.operational_status_code := 'NOT_USED';
5756: END IF;

Line 5766: ELSIF p_instance_rec.location_type_code IN ('INVENTORY','HZ_LOCATIONS')

5762: ELSIF p_instance_rec.location_type_code ='PROJECT'
5763: AND p_instance_rec.operational_status_code ='IN_SERVICE'
5764: THEN
5765: p_instance_rec.operational_status_code := 'NOT_USED';
5766: ELSIF p_instance_rec.location_type_code IN ('INVENTORY','HZ_LOCATIONS')
5767: AND p_instance_rec.operational_status_code NOT IN ('NOT_USED','INSTALLED','OUT_OF_SERVICE','IN_SERVICE')
5768: THEN
5769: p_instance_rec.operational_status_code := 'NOT_USED';
5770: END IF;

Line 5923: p_instance_rec.install_location_type_code = 'HZ_LOCATIONS' OR

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'
5927: THEN

Line 13394: ELSIF l_get_instance_rec.location_type_code ='HZ_LOCATIONS'

13390: (l_curr_instance_rec.operational_status_code NOT IN ('NOT_USED','OUT_OF_SERVICE'))
13391: THEN
13392: p_instance_rec.operational_status_code := 'NOT_USED';
13393: END IF;
13394: ELSIF l_get_instance_rec.location_type_code ='HZ_LOCATIONS'
13395: THEN
13396: IF (p_instance_rec.operational_status_code IS NOT NULL AND
13397: p_instance_rec.operational_status_code <> fnd_api.g_miss_char)
13398: AND p_instance_rec.operational_status_code NOT IN ('NOT_USED','INSTALLED','OUT_OF_SERVICE','IN_SERVICE')

Line 13537: ELSIF l_get_instance_rec.location_type_code ='HZ_LOCATIONS'

13533: (l_curr_instance_rec.operational_status_code NOT IN ('NOT_USED','OUT_OF_SERVICE'))
13534: THEN
13535: p_instance_rec.operational_status_code := 'NOT_USED';
13536: END IF;
13537: ELSIF l_get_instance_rec.location_type_code ='HZ_LOCATIONS'
13538: THEN
13539: IF (p_instance_rec.operational_status_code IS NOT NULL AND
13540: p_instance_rec.operational_status_code <> fnd_api.g_miss_char)
13541: AND p_instance_rec.operational_status_code NOT IN ('NOT_USED','INSTALLED','OUT_OF_SERVICE','IN_SERVICE')

Line 13946: ELSIF l_curr_instance_rec.location_type_code = 'HZ_LOCATIONS' AND

13942: (p_instance_rec.location_type_code <> l_curr_instance_rec.location_type_code) THEN
13943: p_instance_rec.last_pa_project_id := l_curr_instance_rec.pa_project_id;
13944: p_instance_rec.last_pa_task_id := l_curr_instance_rec.pa_project_task_id;
13945:
13946: ELSIF l_curr_instance_rec.location_type_code = 'HZ_LOCATIONS' AND
13947: (p_instance_rec.location_type_code <> l_curr_instance_rec.location_type_code) THEN
13948: IF ((l_curr_instance_rec.pa_project_id IS NOT NULL) AND
13949: (l_curr_instance_rec.pa_project_task_id IS NOT NULL)) THEN
13950: p_instance_rec.last_pa_project_id := l_curr_instance_rec.pa_project_id;

Line 14083: p_instance_rec.install_location_type_code = 'HZ_LOCATIONS' OR

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
14087: THEN