FND Design Data [Home] [Help]

View: GL_USSGL_TRANSACTION_CODES_V

Product: PO - Purchasing
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.GL_USSGL_TRANSACTION_CODES_V
View Text

SELECT CHART_OF_ACCOUNTS_ID
, USSGL_TRANSACTION_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, DESCRIPTION
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTEXT
, ASSOC_INTEREST_USSGL_CODE
, ASSOC_DISCOUNT_USSGL_CODE
FROM GL_USSGL_TRANSACTION_CODES
WHERE SYSDATE BETWEEN NVL(START_DATE_ACTIVE
, SYSDATE)
AND NVL(END_DATE_ACTIVE
, SYSDATE)

Columns

Name
CHART_OF_ACCOUNTS_ID
USSGL_TRANSACTION_CODE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
START_DATE_ACTIVE
END_DATE_ACTIVE
DESCRIPTION
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CONTEXT
ASSOC_INTEREST_USSGL_CODE
ASSOC_DISCOUNT_USSGL_CODE