APPS.CSI_ORDER_SHIP_PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 618: FROM hz_cust_acct_sites_all c,

614: BEGIN
615:
616: SELECT party_site_id
617: INTO l_party_site_id
618: FROM hz_cust_acct_sites_all c,
619: hz_cust_site_uses_all u
620: WHERE c.cust_acct_site_id = u.cust_acct_site_id
621: AND u.site_use_id = l_order_line_rec.ib_current_loc_id;
622:

Line 642: FROM hz_cust_acct_sites_all c,

638: IF NVL(l_order_line_rec.ib_install_loc_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
639: BEGIN
640: SELECT party_site_id
641: INTO l_party_install_site_id
642: FROM hz_cust_acct_sites_all c,
643: hz_cust_site_uses_all u
644: WHERE c.cust_acct_site_id = u.cust_acct_site_id
645: AND u.site_use_id = l_order_line_rec.ib_install_loc_id;
646:

Line 4302: hz_cust_acct_sites_all HCAS

4298:
4299: SELECT HCAS.party_site_id
4300: INTO l_party_site_id
4301: FROM hz_cust_site_uses_all HCSU,
4302: hz_cust_acct_sites_all HCAS
4303: WHERE HCSU.site_use_id = l_order_line_rec.ship_to_org_id
4304: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
4305:
4306: EXCEPTION

Line 5585: FROM hz_cust_acct_sites_all c,

5581: BEGIN
5582:
5583: SELECT party_site_id
5584: INTO l_party_site_id
5585: FROM hz_cust_acct_sites_all c,
5586: hz_cust_site_uses_all u
5587: WHERE c.cust_acct_site_id = u.cust_acct_site_id
5588: AND u.site_use_id = p_order_line_rec.ib_current_loc_id; -- ship_to_org_id;
5589:

Line 5615: FROM hz_cust_acct_sites_all c,

5611: BEGIN
5612:
5613: SELECT party_site_id
5614: INTO l_install_party_site_id
5615: FROM hz_cust_acct_sites_all c,
5616: hz_cust_site_uses_all u
5617: WHERE c.cust_acct_site_id = u.cust_acct_site_id
5618: AND u.site_use_id = p_order_line_rec.ib_install_loc_id; -- ship_to_org_id;
5619:

Line 5999: hz_cust_acct_sites_all HCAS

5995: BEGIN
5996: SELECT HCAS.party_site_id
5997: INTO l_upd_party_site_id
5998: FROM hz_cust_site_uses_all HCSU,
5999: hz_cust_acct_sites_all HCAS
6000: WHERE HCSU.site_use_id = p_order_line_rec.ib_install_loc_id
6001: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
6002:
6003: EXCEPTION

Line 6812: hz_cust_acct_sites_all HCAS

6808: BEGIN
6809: SELECT HCAS.party_site_id
6810: INTO l_cre_party_site_id
6811: FROM hz_cust_site_uses_all HCSU,
6812: hz_cust_acct_sites_all HCAS
6813: WHERE HCSU.site_use_id = p_order_line_rec.ib_install_loc_id
6814: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
6815:
6816: EXCEPTION

Line 8346: FROM hz_cust_acct_sites_all c,

8342:
8343: BEGIN
8344: SELECT party_site_id
8345: INTO l_party_site_id
8346: FROM hz_cust_acct_sites_all c,
8347: hz_cust_site_uses_all u
8348: WHERE c.cust_acct_site_id = u.cust_acct_site_id
8349: AND u.site_use_id = x_order_shipment_tbl(i).ib_current_loc_id; -- ship_to_org_id;
8350: Exception

Line 8374: FROM hz_cust_acct_sites_all c,

8370: Then
8371: BEGIN
8372: SELECT party_site_id
8373: INTO l_install_party_site_id
8374: FROM hz_cust_acct_sites_all c,
8375: hz_cust_site_uses_all u
8376: WHERE c.cust_acct_site_id = u.cust_acct_site_id
8377: AND u.site_use_id = x_order_shipment_tbl(i).ib_install_loc_id; -- ship_to_org_id;
8378: Exception