Product: | AR - Receivables |
---|---|
Description: | Late Charge batch preview work bench |
Implementation/DBA Data: | APPS.AR_INTEREST_BATCHES_V |
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