eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: GMI.IN_STAT_DTL#

Source

View Text - Preformatted


select STAT_ID STAT_ID, STATLINE_ID STATLINE_ID, TRANS_ID TRANS_ID, PND_TRANS_ID PND_TRANS_ID, CMP_TRANS_ID CMP_TRANS_ID, LINE_ID LINE_ID, PORECV_LINE_ID PORECV_LINE_ID, OPORDR_LINE_ID OPORDR_LINE_ID, ICADJS_LINE_ID ICADJS_LINE_ID, ITEM_ID ITEM_ID, LOT_ID LOT_ID, COMMODITY_CODE COMMODITY_CODE, STAT_QTY STAT_QTY, STAT_UM STAT_UM, STAT_VALUE STAT_VALUE, CURRENCY_CODE CURRENCY_CODE, TRANS_DATE TRANS_DATE, STAT_SUPP_QTY STAT_SUPP_QTY, STAT_SUPP_UM STAT_SUPP_UM, FROM_COUNTRY FROM_COUNTRY, TO_COUNTRY TO_COUNTRY, CTRY_OF_ORIGIN CTRY_OF_ORIGIN, FROM_REGION_CODE FROM_REGION_CODE, TO_REGION_CODE TO_REGION_CODE, TRANS_NATURE TRANS_NATURE, EC_DELIVERY_CODE EC_DELIVERY_CODE, MOT_CODE MOT_CODE, VAT_REGN VAT_REGN, BRANCH_NO BRANCH_NO, PORT_CODE PORT_CODE, ORIGINATION_IND ORIGINATION_IND, 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, DELETE_MARK DELETE_MARK, TEXT_CODE TEXT_CODE from "GMI"."IN_STAT_DTL"

View Text - HTML Formatted

SELECT STAT_ID STAT_ID
, STATLINE_ID STATLINE_ID
, TRANS_ID TRANS_ID
, PND_TRANS_ID PND_TRANS_ID
, CMP_TRANS_ID CMP_TRANS_ID
, LINE_ID LINE_ID
, PORECV_LINE_ID PORECV_LINE_ID
, OPORDR_LINE_ID OPORDR_LINE_ID
, ICADJS_LINE_ID ICADJS_LINE_ID
, ITEM_ID ITEM_ID
, LOT_ID LOT_ID
, COMMODITY_CODE COMMODITY_CODE
, STAT_QTY STAT_QTY
, STAT_UM STAT_UM
, STAT_VALUE STAT_VALUE
, CURRENCY_CODE CURRENCY_CODE
, TRANS_DATE TRANS_DATE
, STAT_SUPP_QTY STAT_SUPP_QTY
, STAT_SUPP_UM STAT_SUPP_UM
, FROM_COUNTRY FROM_COUNTRY
, TO_COUNTRY TO_COUNTRY
, CTRY_OF_ORIGIN CTRY_OF_ORIGIN
, FROM_REGION_CODE FROM_REGION_CODE
, TO_REGION_CODE TO_REGION_CODE
, TRANS_NATURE TRANS_NATURE
, EC_DELIVERY_CODE EC_DELIVERY_CODE
, MOT_CODE MOT_CODE
, VAT_REGN VAT_REGN
, BRANCH_NO BRANCH_NO
, PORT_CODE PORT_CODE
, ORIGINATION_IND ORIGINATION_IND
, 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
, DELETE_MARK DELETE_MARK
, TEXT_CODE TEXT_CODE
FROM "GMI"."IN_STAT_DTL"