VIEW: GML.PO_RECV_HST#

Source

View Text - Preformatted

select PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, RECV_ID RECV_ID, RECV_LINE_ID RECV_LINE_ID, RECV_SEQ_NO RECV_SEQ_NO, EXCHANGE_RATE EXCHANGE_RATE, MUL_DIV_SIGN MUL_DIV_SIGN, NET_QTY NET_QTY, PRICE_UM PRICE_UM, NET_PRICE NET_PRICE, TO_WHSE TO_WHSE, GL_POSTED_IND GL_POSTED_IND, PO_ID PO_ID, PO_LINE_ID PO_LINE_ID, SUB_EVENT_TYPE SUB_EVENT_TYPE, RECV_DATE RECV_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TRANS_CNT TRANS_CNT, TEXT_CODE TEXT_CODE, DELETE_MARK DELETE_MARK from "GML"."PO_RECV_HST"

View Text - HTML Formatted

SELECT PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, RECV_ID RECV_ID
, RECV_LINE_ID RECV_LINE_ID
, RECV_SEQ_NO RECV_SEQ_NO
, EXCHANGE_RATE EXCHANGE_RATE
, MUL_DIV_SIGN MUL_DIV_SIGN
, NET_QTY NET_QTY
, PRICE_UM PRICE_UM
, NET_PRICE NET_PRICE
, TO_WHSE TO_WHSE
, GL_POSTED_IND GL_POSTED_IND
, PO_ID PO_ID
, PO_LINE_ID PO_LINE_ID
, SUB_EVENT_TYPE SUB_EVENT_TYPE
, RECV_DATE RECV_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TRANS_CNT TRANS_CNT
, TEXT_CODE TEXT_CODE
, DELETE_MARK DELETE_MARK
FROM "GML"."PO_RECV_HST"