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: INV.MTL_CONSUMPTION_TRANSACTIONS#

Source

View Text - Preformatted


select TRANSACTION_ID TRANSACTION_ID, CONSUMPTION_RELEASE_ID CONSUMPTION_RELEASE_ID, CONSUMPTION_PO_HEADER_ID CONSUMPTION_PO_HEADER_ID, CONSUMPTION_PROCESSED_FLAG CONSUMPTION_PROCESSED_FLAG, REQUEST_ID REQUEST_ID, CREATED_BY CREATED_BY, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, CREATION_DATE CREATION_DATE, PROGRAM_ID PROGRAM_ID, LAST_UPDATED_BY LAST_UPDATED_BY, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, NET_QTY NET_QTY, BATCH_ID BATCH_ID, RATE RATE, RATE_TYPE RATE_TYPE, TAX_CODE_ID TAX_CODE_ID, TAX_RATE TAX_RATE, ERROR_CODE ERROR_CODE, RECOVERABLE_TAX RECOVERABLE_TAX, NON_RECOVERABLE_TAX NON_RECOVERABLE_TAX, TAX_RECOVERY_RATE TAX_RECOVERY_RATE, PARENT_TRANSACTION_ID PARENT_TRANSACTION_ID, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID, VARIANCE_ACCOUNT_ID VARIANCE_ACCOUNT_ID, GLOBAL_AGREEMENT_FLAG GLOBAL_AGREEMENT_FLAG, NEED_BY_DATE NEED_BY_DATE, ERROR_EXPLANATION ERROR_EXPLANATION, SECONDARY_NET_QTY SECONDARY_NET_QTY, BLANKET_PRICE BLANKET_PRICE, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, INTERFACE_DISTRIBUTION_REF INTERFACE_DISTRIBUTION_REF, TRANSACTION_SOURCE_ID TRANSACTION_SOURCE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID, ORGANIZATION_ID ORGANIZATION_ID, OWNING_ORGANIZATION_ID OWNING_ORGANIZATION_ID, TRANSACTION_DATE TRANSACTION_DATE, PO_LINE_ID PO_LINE_ID from "INV"."MTL_CONSUMPTION_TRANSACTIONS"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, CONSUMPTION_RELEASE_ID CONSUMPTION_RELEASE_ID
, CONSUMPTION_PO_HEADER_ID CONSUMPTION_PO_HEADER_ID
, CONSUMPTION_PROCESSED_FLAG CONSUMPTION_PROCESSED_FLAG
, REQUEST_ID REQUEST_ID
, CREATED_BY CREATED_BY
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CREATION_DATE CREATION_DATE
, PROGRAM_ID PROGRAM_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, NET_QTY NET_QTY
, BATCH_ID BATCH_ID
, RATE RATE
, RATE_TYPE RATE_TYPE
, TAX_CODE_ID TAX_CODE_ID
, TAX_RATE TAX_RATE
, ERROR_CODE ERROR_CODE
, RECOVERABLE_TAX RECOVERABLE_TAX
, NON_RECOVERABLE_TAX NON_RECOVERABLE_TAX
, TAX_RECOVERY_RATE TAX_RECOVERY_RATE
, PARENT_TRANSACTION_ID PARENT_TRANSACTION_ID
, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID
, VARIANCE_ACCOUNT_ID VARIANCE_ACCOUNT_ID
, GLOBAL_AGREEMENT_FLAG GLOBAL_AGREEMENT_FLAG
, NEED_BY_DATE NEED_BY_DATE
, ERROR_EXPLANATION ERROR_EXPLANATION
, SECONDARY_NET_QTY SECONDARY_NET_QTY
, BLANKET_PRICE BLANKET_PRICE
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, INTERFACE_DISTRIBUTION_REF INTERFACE_DISTRIBUTION_REF
, TRANSACTION_SOURCE_ID TRANSACTION_SOURCE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID
, ORGANIZATION_ID ORGANIZATION_ID
, OWNING_ORGANIZATION_ID OWNING_ORGANIZATION_ID
, TRANSACTION_DATE TRANSACTION_DATE
, PO_LINE_ID PO_LINE_ID
FROM "INV"."MTL_CONSUMPTION_TRANSACTIONS"