[Home] [Help]
View: ITG_AMOUNT_TYPES_V
Product: | ITG - Internet Procurement Enterprise Connector |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT B.SET_OF_BOOKS_ID
, L.LOOKUP_CODE
, L.MEANING
, L.DESCRIPTION
FROM GL_LOOKUPS L
, GL_SETS_OF_BOOKS B
WHERE LOOKUP_TYPE IN ( 'PTD_YTD'
, DECODE( B.ENABLE_AVERAGE_BALANCES_FLAG
, 'Y'
, 'PATD_EOD'
, NULL ) )
Columns
Name |
SET_OF_BOOKS_ID |
LOOKUP_CODE |
MEANING |
DESCRIPTION |