[Home] [Help]
View: JG_ZZ_AR_BALANCES_V
Product: | JG - Regional Localizations |
Description: | Sub-ledger balances for Receivables |
Implementation/DBA Data: |
APPS.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
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 |
Name |