Product: | AX - Global Accounting Engine |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT A.APPLICATION_ID
, A.SET_OF_BOOKS_ID
, A.THIRD_PARTY_ID
, A.SUB_ID
, A.CODE_COMBINATION_ID
, A.PERIOD_NAME
, '_KF:SQLGL:GL#:GCC'
, A.ACCOUNT_SEGMENT
, A.BALANCE_SEGMENT
, (END_BALANCE_DR - PERIOD_NET_DR - END_BALANCE_CR + PERIOD_NET_CR)
, (END_BALANCE_DR - PERIOD_NET_DR)
, (END_BALANCE_CR - PERIOD_NET_CR)
, (PERIOD_NET_DR - PERIOD_NET_CR)
, PERIOD_NET_DR
, PERIOD_NET_CR
, (END_BALANCE_DR - END_BALANCE_CR)
, END_BALANCE_DR
, END_BALANCE_CR
, PS.EFFECTIVE_PERIOD_NUM
, A.HISTORIC_BALANCE
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
FROM AX_BALANCES A
, GL_PERIOD_STATUSES PS
, GL_CODE_COMBINATIONS GCC
WHERE PS.PERIOD_NAME = A.PERIOD_NAME
AND PS.APPLICATION_ID = A.APPLICATION_ID
AND PS.SET_OF_BOOKS_ID = A.SET_OF_BOOKS_ID
AND A.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID WITH READ ONLY