View: JG_ZZ_AP_BALANCES_V

Product:	JG - Regional Localizations
Description:	This view combines the JG_ZZ_AP_BALANCES table which holds the vendor sub-ledger balances to the last closed period with JG_ZZ_AP_TMP_BAL which holds the balances since that date. This view is used by the Vendor sub-ledger reports.
Implementation/DBA Data:	APPS.JG_ZZ_AP_BALANCES_V

View Text

SELECT SET_OF_BOOKS_ID
, CODE_COMBINATION_ID
, CURRENCY_CODE
, PERIOD_NAME
, VENDOR_ID
, VENDOR_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_AP_BALANCES UNION SELECT SET_OF_BOOKS_ID
, CODE_COMBINATION_ID
, CURRENCY_CODE
, PERIOD_NAME
, VENDOR_ID
, VENDOR_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_AP_TMP_BAL

Columns