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: IGI.IGI_MPP_AP_INVOICE_DISTS_DET#

Source

View Text - Preformatted


select MPP_DIST_LINE_NUMBER MPP_DIST_LINE_NUMBER, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER, INVOICE_ID INVOICE_ID, LAST_UPDATED_BY LAST_UPDATED_BY, CODE_COMBINATION_ID CODE_COMBINATION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, PERIOD_NAME PERIOD_NAME, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, DESCRIPTION DESCRIPTION, AMOUNT AMOUNT, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EXPENSE_RECOGNIZED_FLAG EXPENSE_RECOGNIZED_FLAG, GL_POSTED_DATE GL_POSTED_DATE, GL_POSTED_FLAG GL_POSTED_FLAG, JE_BATCH_ID JE_BATCH_ID from "IGI"."IGI_MPP_AP_INVOICE_DISTS_DET"

View Text - HTML Formatted

SELECT MPP_DIST_LINE_NUMBER MPP_DIST_LINE_NUMBER
, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER
, INVOICE_ID INVOICE_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, PERIOD_NAME PERIOD_NAME
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, DESCRIPTION DESCRIPTION
, AMOUNT AMOUNT
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, EXPENSE_RECOGNIZED_FLAG EXPENSE_RECOGNIZED_FLAG
, GL_POSTED_DATE GL_POSTED_DATE
, GL_POSTED_FLAG GL_POSTED_FLAG
, JE_BATCH_ID JE_BATCH_ID
FROM "IGI"."IGI_MPP_AP_INVOICE_DISTS_DET"