FND Design Data [Home] [Help]

View: AR_INTEREST_BATCHES_V

Product: AR - Receivables
Description: Late Charge batch preview work bench
Implementation/DBA Data: ViewAPPS.AR_INTEREST_BATCHES_V
View Text

SELECT IB.INTEREST_BATCH_ID
, IB.BATCH_NAME
, IB.CALCULATE_INTEREST_TO_DATE
, IB.GL_DATE
, IB.LAST_UPDATED_BY
, IB.LAST_UPDATE_DATE
, IB.CREATION_DATE
, IB.LAST_UPDATE_LOGIN
, IB.CREATED_BY
, IB.TRANSFERRED_STATUS
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_PROCESS_STATUS'
, IB.TRANSFERRED_STATUS) TRANSFERRED_STATUS_M
, IB.ORG_ID
, AR_INTEREST_BATCHES_PKG.GET_BATCH_AMOUNT(IB.INTEREST_BATCH_ID) BATCH_AMOUNT
, IB.BATCH_STATUS
, IB.OBJECT_VERSION_NUMBER
FROM AR_INTEREST_BATCHES IB

Columns

Name
INTEREST_BATCH_ID
BATCH_NAME
CALCULATE_INTEREST_TO_DATE
GL_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
CREATION_DATE
LAST_UPDATE_LOGIN
CREATED_BY
TRANSFERRED_STATUS
TRANSFERRED_STATUS_M
ORG_ID
BATCH_AMOUNT
BATCH_STATUS
OBJECT_VERSION_NUMBER