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