DEVELOP A SQL * PLUS REPORT TO SHOW ALL JOURNALS WITH TAX REVENUE STATUS

DEVELOP A SQL * PLUS REPORT TO SHOW ALL JOURNALS WITH TAX REVENUE STATUS

DEVELOP A SQL * PLUS CODE AS FALLOWS

_____________________________________________________________________________________

clear columns

clear breaks

clear computes

column HID heading 'Header|ID' format '999999999999999'

prompt HID 'Header|ID'

column TC heading 'Tax|Status' format A6

column ID heading 'Tax|Code ID' format '999999'

column UPDATE_DATE heading 'Date'

break on HID skip 2 on report

compute sum label "Total Amount" of DEBIT CREDIT on HID

set heading on

set pagesize 23

set linesize 160

set newpage 1

set underline =

ttitle center 'Tax Journal Report' skip 1-

center -------------------- skip 1-

right 'Page No.:' format 99 sql.pno skip 1

btitle center '*** END OF REPORT***'

SELECT

GLJH.JE_HEADER_ID "HID",

GLJH.TAX_STATUS_CODE "TC",

GLJL.TAX_CODE_ID "ID",

TO_CHAR(GLJH.LAST_UPDATE_DATE,'DD-MON-YYYY') "UPDATE_DATE"

FROM GL_JE_HEADERS GLJH,

GL_JE_LINES GLJL,

GL_CODE_COMBINATIONS GLCC,

GL_JE_BATCHES GLJB

WHERE

GLJH.JE_HEADER_ID=GLJL.JE_HEADER_ID AND

GLJL.CODE_COMBINATION_ID=GLCC.CODE_COMBINATION_ID AND

GLJH.JE_BATCH_ID=GLJB.JE_BATCH_ID AND

GLJH.TAX_STATUS_CODE='R'--Revenue tax

order by GLJH.JE_HEADER_ID;

SAVE IT AS A XXTAX_RAM.SQL

OPEN SQL * PLUS ENTER USER NAME AND PASSWORD

APPS/APPS@VIS

Executable  method as SQL*plus

Request Group