FND Design Data [Home] [Help]

View: JG_ZZ_AR_BALANCES_V

Product: JG - Regional Localizations
Description: Sub-ledger balances for Receivables
Implementation/DBA Data: ViewAPPS.JG_ZZ_AR_BALANCES_V
View Text

SELECT SET_OF_BOOKS_ID
, CODE_COMBINATION_ID
, CURRENCY_CODE
, PERIOD_NAME
, CUSTOMER_ID
, CUSTOMER_SITE_ID
, BEGIN_BAL_ENTERED_DR
, BEGIN_BAL_ENTERED_CR
, BEGIN_BAL_ACCOUNTED_DR
, BEGIN_BAL_ACCOUNTED_CR
, PERIOD_NET_ENTERED_DR
, PERIOD_NET_ENTERED_CR
, PERIOD_NET_ACCOUNTED_DR
, PERIOD_NET_ACCOUNTED_CR
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, POSTED_TO_GL_FLAG
FROM JG_ZZ_AR_BALANCES UNION SELECT SET_OF_BOOKS_ID
, CODE_COMBINATION_ID
, CURRENCY_CODE
, PERIOD_NAME
, CUSTOMER_ID
, CUSTOMER_SITE_ID
, BEGIN_BAL_ENTERED_DR
, BEGIN_BAL_ENTERED_CR
, BEGIN_BAL_ACCOUNTED_DR
, BEGIN_BAL_ACCOUNTED_CR
, PERIOD_NET_ENTERED_DR
, PERIOD_NET_ENTERED_CR
, PERIOD_NET_ACCOUNTED_DR
, PERIOD_NET_ACCOUNTED_CR
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, POSTED_TO_GL_FLAG
FROM JG_ZZ_AR_TMP_BAL

Columns

Name
SET_OF_BOOKS_ID
CODE_COMBINATION_ID
CURRENCY_CODE
PERIOD_NAME
CUSTOMER_ID
CUSTOMER_SITE_ID
BEGIN_BAL_ENTERED_DR
BEGIN_BAL_ENTERED_CR
BEGIN_BAL_ACCOUNTED_DR
BEGIN_BAL_ACCOUNTED_CR
PERIOD_NET_ENTERED_DR
PERIOD_NET_ENTERED_CR
PERIOD_NET_ACCOUNTED_DR
PERIOD_NET_ACCOUNTED_CR
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
POSTED_TO_GL_FLAG