How to pull a Cashier Session from TGACREV for balancing purposes

Problem Description : 

How to pull a sql and put in excel for the BO for balancing TGACREV by a session ID

 Resolution : 

Here is the sql used to pull the list from TGACREV into a sql. You must have the session id and not session number.

(SELECT student.id(TBRACCD.TBRACCD_PIDM, 'ND'),

 TBRACCD.TBRACCD_TRAN_NUMBER,

 TBRACCD.TBRACCD_USER,

 TRUNC (TBRACCD.TBRACCD_ENTRY_DATE),

 TBRACCD.TBRACCD_DETAIL_CODE,

 TBRACCD.TBRACCD_AMOUNT,

 TBRACCD.TBRACCD_EFFECTIVE_DATE,

 TBRACCD.TBRACCD_RECEIPT_NUMBER,

 TBRACCD.TBRACCD_DESC,

 TBRACCD.TBRACCD_SRCE_CODE,

 TBRACCD.TBRACCD_ACCT_FEED_IND,

 TO_CHAR (TBRACCD.TBRACCD_ENTRY_DATE, 'HH24:MI:SS'),

 TBRACCD_CURR_CODE,

 TBRACCD_FOREIGN_AMOUNT,

 ''

 FROM TBRACCD, TBRCOLR

 WHERE TBRACCD.TBRACCD_USER = TBRCOLR.TBRCOLR_SESSION_USER

 AND TBRACCD.TBRACCD_SESSION_NUMBER =

 TBRCOLR.TBRCOLR_SESSION_NUMBER

 AND NVL (TBRACCD.TBRACCD_CSHR_END_DATE,

 TBRCOLR.TBRCOLR_SESS_END_DATE) =

 TBRCOLR.TBRCOLR_SESS_END_DATE

 AND TBRCOLR.TBRCOLR_SESSIONID = '1884594'

 Revision Date : 1/4/2012