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_MST#

Source

View Text - Preformatted


select INVOICE_LINE_NO INVOICE_LINE_NO, PO_ID PO_ID, POLINE_ID POLINE_ID, LINE_TYPE LINE_TYPE, ITEM_ID ITEM_ID, AQUI_COST_ID AQUI_COST_ID, 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, DELETE_MARK DELETE_MARK, TRANS_CNT TRANS_CNT, TEXT_CODE TEXT_CODE, APINT_TRANS_ID APINT_TRANS_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID from "GMF"."CM_APCM_MST"

View Text - HTML Formatted

SELECT INVOICE_LINE_NO INVOICE_LINE_NO
, PO_ID PO_ID
, POLINE_ID POLINE_ID
, LINE_TYPE LINE_TYPE
, ITEM_ID ITEM_ID
, AQUI_COST_ID AQUI_COST_ID
, 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
, DELETE_MARK DELETE_MARK
, TRANS_CNT TRANS_CNT
, TEXT_CODE TEXT_CODE
, APINT_TRANS_ID APINT_TRANS_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
FROM "GMF"."CM_APCM_MST"