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 5816: ELSIF p_instance_rec.location_type_code IN ('INVENTORY','HZ_LOCATIONS')

5812: ELSIF p_instance_rec.location_type_code IN ('PROJECT')
5813: AND p_instance_rec.operational_status_code ='IN_SERVICE'
5814: THEN
5815: p_instance_rec.operational_status_code := 'NOT_USED';
5816: ELSIF p_instance_rec.location_type_code IN ('INVENTORY','HZ_LOCATIONS')
5817: AND p_instance_rec.operational_status_code NOT IN ('NOT_USED','INSTALLED','OUT_OF_SERVICE','IN_SERVICE')
5818: THEN
5819: p_instance_rec.operational_status_code := 'NOT_USED';
5820: END IF;

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

5826: ELSIF p_instance_rec.location_type_code ='PROJECT'
5827: AND p_instance_rec.operational_status_code ='IN_SERVICE'
5828: THEN
5829: p_instance_rec.operational_status_code := 'NOT_USED';
5830: ELSIF p_instance_rec.location_type_code IN ('INVENTORY','HZ_LOCATIONS')
5831: AND p_instance_rec.operational_status_code NOT IN ('NOT_USED','INSTALLED','OUT_OF_SERVICE','IN_SERVICE')
5832: THEN
5833: p_instance_rec.operational_status_code := 'NOT_USED';
5834: END IF;

Line 5987: p_instance_rec.install_location_type_code = 'HZ_LOCATIONS' OR

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

Line 13777: ELSIF l_get_instance_rec.location_type_code ='HZ_LOCATIONS'

13773: (l_curr_instance_rec.operational_status_code NOT IN ('NOT_USED','OUT_OF_SERVICE'))
13774: THEN
13775: p_instance_rec.operational_status_code := 'NOT_USED';
13776: END IF;
13777: ELSIF l_get_instance_rec.location_type_code ='HZ_LOCATIONS'
13778: THEN
13779: IF (p_instance_rec.operational_status_code IS NOT NULL AND
13780: p_instance_rec.operational_status_code <> fnd_api.g_miss_char)
13781: AND p_instance_rec.operational_status_code NOT IN ('NOT_USED','INSTALLED','OUT_OF_SERVICE','IN_SERVICE')

Line 13920: ELSIF l_get_instance_rec.location_type_code ='HZ_LOCATIONS'

13916: (l_curr_instance_rec.operational_status_code NOT IN ('NOT_USED','OUT_OF_SERVICE'))
13917: THEN
13918: p_instance_rec.operational_status_code := 'NOT_USED';
13919: END IF;
13920: ELSIF l_get_instance_rec.location_type_code ='HZ_LOCATIONS'
13921: THEN
13922: IF (p_instance_rec.operational_status_code IS NOT NULL AND
13923: p_instance_rec.operational_status_code <> fnd_api.g_miss_char)
13924: AND p_instance_rec.operational_status_code NOT IN ('NOT_USED','INSTALLED','OUT_OF_SERVICE','IN_SERVICE')

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

14331: (p_instance_rec.location_type_code <> l_curr_instance_rec.location_type_code) THEN
14332: p_instance_rec.last_pa_project_id := l_curr_instance_rec.pa_project_id;
14333: p_instance_rec.last_pa_task_id := l_curr_instance_rec.pa_project_task_id;
14334:
14335: ELSIF l_curr_instance_rec.location_type_code = 'HZ_LOCATIONS' AND
14336: (p_instance_rec.location_type_code <> l_curr_instance_rec.location_type_code) THEN
14337: IF ((l_curr_instance_rec.pa_project_id IS NOT NULL) AND
14338: (l_curr_instance_rec.pa_project_task_id IS NOT NULL)) THEN
14339: p_instance_rec.last_pa_project_id := l_curr_instance_rec.pa_project_id;

Line 14477: p_instance_rec.install_location_type_code = 'HZ_LOCATIONS' OR

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