VIEW: APPS.JG_ZZ_AR_BALANCES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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