DBA Data[Home] [Help]

APPS.WSH_SHIPMENT_REQUEST_PKG dependencies on HZ_PARTY_SITES

Line 803: hz_party_sites ps,

799: -- LSP PROJECT :
800: CURSOR c_get_ordertype_org (c_cust_acct_id NUMBER, c_party_site_id NUMBER) IS
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