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
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;
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: