DBA Data[Home] [Help]

APPS.OKE_DTS_INTEGRATION_PKG dependencies on OKE_CUST_SITE_USES_V

Line 717: from oke_cust_site_uses_v

713: CLOSE l_line_csr;
714:
715: -- get the right ship_to_location_id
716: select location_id into l_ship_rec.ship_to_location_id
717: from oke_cust_site_uses_v
718: where id1 = l_ship_to_location_id;
719:
720: -- get the customer_id from contract header party
721: -- currently use ship_to_location derive party_id from oke_cust_site_uses_v

Line 721: -- currently use ship_to_location derive party_id from oke_cust_site_uses_v

717: from oke_cust_site_uses_v
718: where id1 = l_ship_to_location_id;
719:
720: -- get the customer_id from contract header party
721: -- currently use ship_to_location derive party_id from oke_cust_site_uses_v
722:
723: select cust_account_id into l_customer_id
724: from oke_cust_site_uses_v
725: where id1 = l_ship_to_location_id;

Line 724: from oke_cust_site_uses_v

720: -- get the customer_id from contract header party
721: -- currently use ship_to_location derive party_id from oke_cust_site_uses_v
722:
723: select cust_account_id into l_customer_id
724: from oke_cust_site_uses_v
725: where id1 = l_ship_to_location_id;
726:
727: -- Populate shipping terms for report purpose
728: