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: GL_JE_BATCHES_AP_V

Product:	AP - Payables
Description:	(Release 10SC Only)
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT GLB.JE_BATCH_ID JE_BATCH_ID
, GLB.NAME GL_BATCH_NAME
, DECODE(GLB.SET_OF_BOOKS_ID
, SP.SET_OF_BOOKS_ID
, SP.ACCOUNTING_METHOD_OPTION
, SP.SECONDARY_ACCOUNTING_METHOD) ACCOUNTING_METHOD
FROM GL_JE_BATCHES GLB
, GL_JE_HEADERS GLH
, AP_SYSTEM_PARAMETERS SP
WHERE GLB.ACTUAL_FLAG = 'A'
AND GLB.JE_BATCH_ID = GLH.JE_BATCH_ID
AND GLB.SET_OF_BOOKS_ID = DECODE(SP.SECONDARY_ACCOUNTING_METHOD
, DECODE(GLH.JE_CATEGORY
, 'PAYMENTS'
, 'CASH'
, 'PURCHASE INVOICES'
, 'ACCRUAL'
, 'DUMMY')
, SP.SECONDARY_SET_OF_BOOKS_ID
, DECODE(SP.ACCOUNTING_METHOD_OPTION
, DECODE(GLH.JE_CATEGORY
, 'PAYMENTS'
, 'CASH'
, 'PURCHASE INVOICES'
, 'ACCRUAL'
, 'DUMMY')
, SP.SET_OF_BOOKS_ID
, NULL)) GROUP BY GLB.JE_BATCH_ID
, GLB.NAME
, DECODE(GLB.SET_OF_BOOKS_ID
, SP.SET_OF_BOOKS_ID
, SP.ACCOUNTING_METHOD_OPTION
, SP.SECONDARY_ACCOUNTING_METHOD)

Columns

Name
JE_BATCH_ID
GL_BATCH_NAME
ACCOUNTING_METHOD