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_ORDER_FULFILL_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 8820: hz_cust_site_uses_all u

8816:
8817: SELECT party_site_id
8818: INTO l_cur_party_site_id
8819: FROM hz_cust_acct_sites_all c,
8820: hz_cust_site_uses_all u
8821: WHERE c.cust_acct_site_id = u.cust_acct_site_id
8822: AND u.site_use_id = px_default_info_rec.current_party_site_id;
8823: */
8824: l_p_tld_tbl(l_ind).location_type_code := 'HZ_PARTY_SITES';

Line 8855: hz_cust_site_uses_all u

8851:
8852: SELECT party_site_id
8853: INTO l_inst_party_site_id
8854: FROM hz_cust_acct_sites_all c,
8855: hz_cust_site_uses_all u
8856: WHERE c.cust_acct_site_id = u.cust_acct_site_id
8857: AND u.site_use_id = px_default_info_rec.install_party_site_id;
8858: */
8859: l_p_tld_tbl(l_ind).install_location_type_code := 'HZ_PARTY_SITES';

Line 9357: FROM hz_cust_site_uses_all HCSU,

9353: IF nvl(l_current_site_use_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
9354: BEGIN
9355: SELECT HCAS.party_site_id
9356: INTO l_party_site_id
9357: FROM hz_cust_site_uses_all HCSU,
9358: hz_cust_acct_sites_all HCAS
9359: WHERE HCSU.site_use_id = l_current_site_use_id
9360: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
9361: l_default_info_rec.current_party_site_id := l_party_site_id;

Line 9376: FROM hz_cust_site_uses_all HCSU,

9372: IF nvl(l_install_site_use_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
9373: BEGIN
9374: SELECT HCAS.party_site_id
9375: INTO l_party_site_id
9376: FROM hz_cust_site_uses_all HCSU,
9377: hz_cust_acct_sites_all HCAS
9378: WHERE HCSU.site_use_id = l_install_site_use_id
9379: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
9380: l_default_info_rec.install_party_site_id := l_party_site_id;

Line 10618: hz_cust_site_uses_all u

10614: BEGIN
10615: SELECT party_site_id
10616: INTO l_party_site_id
10617: FROM hz_cust_acct_sites_all c,
10618: hz_cust_site_uses_all u
10619: WHERE c.cust_acct_site_id = u.cust_acct_site_id
10620: AND u.site_use_id = x_order_shipment_tbl(i).ib_current_loc_id;
10621: EXCEPTION
10622: WHEN no_data_found THEN

Line 10644: hz_cust_site_uses_all u

10640: BEGIN
10641: SELECT party_site_id
10642: INTO l_install_party_site_id
10643: FROM hz_cust_acct_sites_all c,
10644: hz_cust_site_uses_all u
10645: WHERE c.cust_acct_site_id = u.cust_acct_site_id
10646: AND u.site_use_id = x_order_shipment_tbl(i).ib_install_loc_id;
10647: EXCEPTION
10648: WHEN no_data_found THEN