Validate Freight Terms

         SELECT lookup_code freight_terms_code
           FROM apps.oe_lookups
          WHERE     lookup_type = 'FREIGHT_TERMS'
                AND UPPER (lookup_code) = UPPER (p_freight_term)
             OR     UPPER (meaning) = UPPER (p_freight_term)
                AND enabled_flag = 'Y'
                AND TRUNC (SYSDATE) BETWEEN NVL (start_date_active,TRUNC (gd_sysdate))
                      AND NVL (end_date_active,TRUNC (gd_sysdate));