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.

[Home] [Help]

VIEW: GMF.CM_APCM_INT#

Source

View Text - Preformatted


select APINT_TRANS_ID APINT_TRANS_ID, PO_ID PO_ID, POLINE_ID POLINE_ID, LINE_TYPE LINE_TYPE, ITEM_ID ITEM_ID, ITEM_NO ITEM_NO, AQUI_COST_ID AQUI_COST_ID, AQUI_COST_CODE AQUI_COST_CODE, INVOICE_NO INVOICE_NO, INVOICE_TYPE INVOICE_TYPE, PREV_INVOICE_NO PREV_INVOICE_NO, INVOICE_QTY INVOICE_QTY, QUANTITY_UOM QUANTITY_UOM, INVOICE_AMOUNT INVOICE_AMOUNT, UNIT_PRICE UNIT_PRICE, INVOICE_BASE_AMOUNT INVOICE_BASE_AMOUNT, UNIT_BASE_PRICE UNIT_BASE_PRICE, BILLING_CURRENCY BILLING_CURRENCY, BASE_CURRENCY BASE_CURRENCY, EXCHANGE_RATE EXCHANGE_RATE, INVOICE_STATUS INVOICE_STATUS, PO_DATE PO_DATE, INVOICE_DATE INVOICE_DATE, GL_DATE GL_DATE, INTERFACE_DATE INTERFACE_DATE, AC_STATUS AC_STATUS, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, DELETE_MARK DELETE_MARK, TRANS_CNT TRANS_CNT, TEXT_CODE TEXT_CODE, INVALID_IND INVALID_IND, DIRECTION_IND DIRECTION_IND, INVOICE_LINE_NO INVOICE_LINE_NO from "GMF"."CM_APCM_INT"

View Text - HTML Formatted

SELECT APINT_TRANS_ID APINT_TRANS_ID
, PO_ID PO_ID
, POLINE_ID POLINE_ID
, LINE_TYPE LINE_TYPE
, ITEM_ID ITEM_ID
, ITEM_NO ITEM_NO
, AQUI_COST_ID AQUI_COST_ID
, AQUI_COST_CODE AQUI_COST_CODE
, INVOICE_NO INVOICE_NO
, INVOICE_TYPE INVOICE_TYPE
, PREV_INVOICE_NO PREV_INVOICE_NO
, INVOICE_QTY INVOICE_QTY
, QUANTITY_UOM QUANTITY_UOM
, INVOICE_AMOUNT INVOICE_AMOUNT
, UNIT_PRICE UNIT_PRICE
, INVOICE_BASE_AMOUNT INVOICE_BASE_AMOUNT
, UNIT_BASE_PRICE UNIT_BASE_PRICE
, BILLING_CURRENCY BILLING_CURRENCY
, BASE_CURRENCY BASE_CURRENCY
, EXCHANGE_RATE EXCHANGE_RATE
, INVOICE_STATUS INVOICE_STATUS
, PO_DATE PO_DATE
, INVOICE_DATE INVOICE_DATE
, GL_DATE GL_DATE
, INTERFACE_DATE INTERFACE_DATE
, AC_STATUS AC_STATUS
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, DELETE_MARK DELETE_MARK
, TRANS_CNT TRANS_CNT
, TEXT_CODE TEXT_CODE
, INVALID_IND INVALID_IND
, DIRECTION_IND DIRECTION_IND
, INVOICE_LINE_NO INVOICE_LINE_NO
FROM "GMF"."CM_APCM_INT"