eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_DTS_INTEGRATION_PKG dependencies on OKE_CUST_SITE_USES_V

Line 742: from oke_cust_site_uses_v

738: CLOSE l_line_csr;
739:
740: -- get the right ship_to_location_id
741: select location_id into l_ship_rec.ship_to_location_id
742: from oke_cust_site_uses_v
743: where id1 = l_ship_to_location_id;
744:
745: -- get the customer_id from contract header party
746: -- currently use ship_to_location derive party_id from oke_cust_site_uses_v

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

742: from oke_cust_site_uses_v
743: where id1 = l_ship_to_location_id;
744:
745: -- get the customer_id from contract header party
746: -- currently use ship_to_location derive party_id from oke_cust_site_uses_v
747:
748: select cust_account_id into l_customer_id
749: from oke_cust_site_uses_v
750: where id1 = l_ship_to_location_id;

Line 749: from oke_cust_site_uses_v

745: -- get the customer_id from contract header party
746: -- currently use ship_to_location derive party_id from oke_cust_site_uses_v
747:
748: select cust_account_id into l_customer_id
749: from oke_cust_site_uses_v
750: where id1 = l_ship_to_location_id;
751:
752: -- Populate shipping terms for report purpose
753: