Category Archives: oe_transaction_types_tl

Query to get the OM Sales Order summary details

  SELECT h.transactional_curr_code Currency,          h.conversion_rate Conversion_rate,          h.conversion_type_code Conversion_Type_Code,          h.transactional_curr_code use_currency,          DECODE (SUBSTR (UPPER (:p_order_by), 1, 1), ‘S’, sr.name, NULL)             Sales_Person,          DECODE (SUBSTR (UPPER (:p_order_by), 1, 1), ‘O’, h.ordered_date, NULL)             dummy_order_date,          DECODE (SUBSTR … Continue reading

Posted in HZ_CUST_SITE_USES_ALL, oe_order_headers_all, oe_transaction_types_tl | Leave a comment