Sunday, April 24, 2016

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 






No comments:

Post a Comment

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...