View: GLEX_VIEW

Product:	GMF - Process Manufacturing Financials
Description:	Glex view
Implementation/DBA Data:	APPS.GLEX_VIEW

View Text

SELECT S.DEBIT_CREDIT_SIGN
, SUM(S.AMOUNT_TRANS)
, SUM(S.AMOUNT_BASE)
, SUM(S.QUANTITY)
, S.CURRENCY_TRANS
, S.CURRENCY_BASE
, S.QUANTITY_UM
, S.DOC_TYPE
, R.TRANS_SOURCE_CODE
, V.SUB_EVENT_CODE
, S.EXCHANGE_RATE
, S.DOC_ID
, S.VOUCHER_ID
, S.ACCTG_UNIT_ID
, S.ACCT_ID
, S.LEDGER_CODE
, 0
, S.CO_CODE
, S.FISCAL_YEAR
, S.PERIOD
, 0
, 0
, S.SUB_EVENT_TYPE
, S.TRANS_SOURCE_TYPE
, S.GL_TRANS_DATE
, 0
, U.ACCTG_UNIT_NO||P.SEGMENT_DELIMITER||A.ACCT_NO
, U.ACCTG_UNIT_DESC||' '||A.ACCT_DESC
FROM GL_SUBR_LED S
, GL_SEVT_MST V
, GL_SRCE_MST R
, GL_ACCU_MST U
, GL_ACCT_MST A
, GL_PLCY_MST P
WHERE V.SUB_EVENT_TYPE = S.SUB_EVENT_TYPE AND R.TRANS_SOURCE_TYPE = S.TRANS_SOURCE_TYPE
AND S.ACCTG_UNIT_ID = U.ACCTG_UNIT_ID AND S.ACCT_ID = A.ACCT_ID AND A.CO_CODE = P.CO_CODE GROUP BY U.ACCTG_UNIT_NO
, A.ACCT_NO
, S.VOUCHER_ID
, S.ACCTG_UNIT_ID
, P.SEGMENT_DELIMITER
, S.ACCT_ID
, S.CURRENCY_BASE
, S.CURRENCY_TRANS
, S.QUANTITY_UM
, S.DEBIT_CREDIT_SIGN
, S.EXCHANGE_RATE
, S.DOC_TYPE
, V.SUB_EVENT_CODE
, S.SUB_EVENT_TYPE
, S.TRANS_SOURCE_TYPE
, R.TRANS_SOURCE_CODE
, S.DOC_ID
, S.LEDGER_CODE
, S.CO_CODE
, S.FISCAL_YEAR
, S.PERIOD
, S.GL_TRANS_DATE
, U.ACCTG_UNIT_DESC
, A.ACCT_DESC

Columns