DBA Data[Home] [Help]

APPS.WSH_SHIPMENT_REQUEST_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 805: hz_cust_site_uses_all su

801: SELECT su.org_id,su.order_type_id
802: FROM
803: hz_party_sites ps,
804: hz_cust_acct_sites_all ca,
805: hz_cust_site_uses_all su
806: WHERE ps.party_site_id = c_party_site_id
807: AND su.cust_acct_site_id = ca.cust_acct_site_id
808: AND ca.party_site_id = ps.party_site_id
809: AND ca.cust_account_id = c_cust_acct_id;

Line 6260: FROM hz_cust_site_uses_all

6256: IF l_ship_to_org_id is not null THEN -- {
6257: BEGIN
6258: SELECT cust_acct_site_id
6259: INTO l_address_id
6260: FROM hz_cust_site_uses_all
6261: WHERE org_id = p_del_interface_rec.org_id
6262: AND site_use_id = l_ship_to_org_id;
6263:
6264: p_del_interface_rec.ship_to_address_id := l_ship_to_org_id;