APPS.CSI_ORDER_SHIP_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 4222: FROM hz_cust_site_uses_all HCSU,

4218: BEGIN
4219:
4220: SELECT HCAS.party_site_id
4221: INTO l_party_site_id
4222: FROM hz_cust_site_uses_all HCSU,
4223: hz_cust_acct_sites_all HCAS
4224: WHERE HCSU.site_use_id = l_order_line_rec.ship_to_org_id
4225: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
4226:

Line 5362: hz_cust_site_uses_all u

5358:
5359: SELECT party_site_id
5360: INTO l_party_site_id
5361: FROM hz_cust_acct_sites_all c,
5362: hz_cust_site_uses_all u
5363: WHERE c.cust_acct_site_id = u.cust_acct_site_id
5364: AND u.site_use_id = p_order_line_rec.ib_current_loc_id; -- ship_to_org_id;
5365:
5366: EXCEPTION

Line 5390: hz_cust_site_uses_all u

5386:
5387: SELECT party_site_id
5388: INTO l_install_party_site_id
5389: FROM hz_cust_acct_sites_all c,
5390: hz_cust_site_uses_all u
5391: WHERE c.cust_acct_site_id = u.cust_acct_site_id
5392: AND u.site_use_id = p_order_line_rec.ib_install_loc_id; -- ship_to_org_id;
5393:
5394: EXCEPTION

Line 5741: FROM hz_cust_site_uses_all HCSU,

5737: THEN
5738: BEGIN
5739: SELECT HCAS.party_site_id
5740: INTO l_upd_party_site_id
5741: FROM hz_cust_site_uses_all HCSU,
5742: hz_cust_acct_sites_all HCAS
5743: WHERE HCSU.site_use_id = p_order_line_rec.ib_install_loc_id
5744: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
5745:

Line 6549: FROM hz_cust_site_uses_all HCSU,

6545: THEN
6546: BEGIN
6547: SELECT HCAS.party_site_id
6548: INTO l_cre_party_site_id
6549: FROM hz_cust_site_uses_all HCSU,
6550: hz_cust_acct_sites_all HCAS
6551: WHERE HCSU.site_use_id = p_order_line_rec.ib_install_loc_id
6552: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
6553:

Line 8028: hz_cust_site_uses_all u

8024: BEGIN
8025: SELECT party_site_id
8026: INTO l_party_site_id
8027: FROM hz_cust_acct_sites_all c,
8028: hz_cust_site_uses_all u
8029: WHERE c.cust_acct_site_id = u.cust_acct_site_id
8030: AND u.site_use_id = x_order_shipment_tbl(i).ib_current_loc_id; -- ship_to_org_id;
8031: Exception
8032: When no_data_found then

Line 8056: hz_cust_site_uses_all u

8052: BEGIN
8053: SELECT party_site_id
8054: INTO l_install_party_site_id
8055: FROM hz_cust_acct_sites_all c,
8056: hz_cust_site_uses_all u
8057: WHERE c.cust_acct_site_id = u.cust_acct_site_id
8058: AND u.site_use_id = x_order_shipment_tbl(i).ib_install_loc_id; -- ship_to_org_id;
8059: Exception
8060: When no_data_found then