VIEW: APPS.GLEX_VIEW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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