1 Reply Latest reply: Sep 5, 2012 3:51 PM by shreevat RSS

    link between contract and counters

    User223410
      Hi,

      Kindly let me know the SQL to find the link between a service contract and a counter that is attached to the line in the contract.

      Thanks and Regards
      Sathya
        • 1. Re: link between contract and counters
          shreevat
          Not sure if you got the answer for this. However, you need to get the usage subline in okc_k_lines_b (oklb) with lse_id 13 (and if any other usage subline ids defined in your system) and join to okc_k_items (oki) using oki.cle_id = oklb.id and oki.jot_object1_code = 'OKX_COUNTER'. oki1.object1_id1 would be your counter id.

          Thanks
          Shree