[Home] [Help]
View: POR_USSGL_TC_LOV_V
Product: | ICX - Oracle iProcurement |
Description: | View on which List of Values for United States Standard General Ledger is based |
Implementation/DBA Data: |
APPS.POR_USSGL_TC_LOV_V
|
View Text
SELECT TC.USSGL_TRANSACTION_CODE
, TC.CHART_OF_ACCOUNTS_ID
, TC.DESCRIPTION
FROM GL_USSGL_TRANSACTION_CODES TC
, GL_SETS_OF_BOOKS SB
, FINANCIALS_SYSTEM_PARAMETERS FP
WHERE TC.CHART_OF_ACCOUNTS_ID = SB.CHART_OF_ACCOUNTS_ID
AND SYSDATE BETWEEN NVL(TC.START_DATE_ACTIVE
, SYSDATE-1)
AND NVL(TC.END_DATE_ACTIVE
, SYSDATE+1)
AND SB.SET_OF_BOOKS_ID = FP.SET_OF_BOOKS_ID
Columns
Name |
USSGL_TRANSACTION_CODE |
CHART_OF_ACCOUNTS_ID |
DESCRIPTION |