Saturday, January 19, 2019

OKC_K_HEADERS_ALL_B.STS_CODE in OLFM

OKC_K_HEADERS_ALL_B.STS_CODE = OKC_STATUSES_B.CODE

SELECT b.code, tl.meaning, b.ste_code
  FROM okc_statuses_b b
      ,okc_statuses_tl tl
 WHERE b.code = tl.code


No comments:

Post a Comment

Query To Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...