Recurring Jurnal Definition and Rules Information scripts

--Recurring Jurnal Definition and Rules Information  

SELECT glrb.NAME, glrb.description, glrb.attribute1,

glrl.recurring_header_id, glrl.recurring_line_num,

       glrl.code_combination_id, glrl.description,

       glrl.entered_dr,glrl.entered_cr,grcr.recurring_header_id,

       grcr.recurring_line_num, grcr.rule_num, grcr.OPERATOR,

       grcr.AMOUNT, grcr.segment1,grcr.segment2, grcr.segment3,

       grcr.segment4, grcr.segment5, grcr.segment6, grcr.ledger_currency,

       grcr.currency_type, grcr.actual_flag, grcr.amount_type

  FROM gl_recurring_batches glrb,

       gl_recurring_lines glrl,

       gl_recurring_line_calc_rules grcr

 WHERE glrb.RECURRING_BATCH_ID =  glrl.RECURRING_HEADER_ID

 AND glrl.RECURRING_HEADER_ID = grcr.RECURRING_HEADER_ID(+)

 AND glrl.RECURRING_LINE_NUM = grcr.RECURRING_LINE_NUM(+)

 ORDER BY glrl.RECURRING_LINE_NUM

--Recurring Jurnal Defination and Lines Informations 

SELECT glrb.NAME, glrb.description, glrb.attribute1,glrl.recurring_header_id, glrl.recurring_line_num,

       glrl.code_combination_id, glrl.description, glrl.entered_dr,

       glrl.entered_cr

  FROM gl_recurring_batches glrb,

       gl_recurring_lines glrl

  WHERE glrb.RECURRING_BATCH_ID =  glrl.RECURRING_HEADER_ID

--Recurring Jurnal Rule Calculations Details Informations 

SELECT grcr.recurring_header_id, grcr.recurring_line_num, grcr.rule_num, grcr.OPERATOR, grcr.AMOUNT, grcr.segment1,

       grcr.segment2, grcr.segment3, grcr.segment4, grcr.segment5, grcr.segment6, grcr.ledger_currency,

       grcr.currency_type, grcr.actual_flag, grcr.amount_type

  FROM gl_recurring_line_calc_rules grcr

SELECT * FROM  GL_RECURRING_LINE_CALC_RULES

--Recurring Jurnal Defination and Rules Informations  

SELECT glrb.NAME, glrb.description, glrb.attribute1,

glrl.recurring_header_id, glrl.recurring_line_num,

       glrl.code_combination_id, glrl.description,

       glrl.entered_dr,glrl.entered_cr,grcr.recurring_header_id,

       grcr.recurring_line_num, grcr.rule_num, grcr.OPERATOR,

       grcr.AMOUNT, grcr.segment1,grcr.segment2, grcr.segment3,

       grcr.segment4, grcr.segment5, grcr.segment6, grcr.ledger_currency,

       grcr.currency_type, grcr.actual_flag, grcr.amount_type

  FROM gl_recurring_batches glrb,

       gl_recurring_lines glrl,

       gl_recurring_line_calc_rules grcr

 WHERE glrb.RECURRING_BATCH_ID =  glrl.RECURRING_HEADER_ID

 AND glrl.RECURRING_HEADER_ID = grcr.RECURRING_HEADER_ID(+)

 AND glrl.RECURRING_LINE_NUM = grcr.RECURRING_LINE_NUM(+)

 order by glrl.RECURRING_LINE_NUM

--Recurring Jurnal Defination and Lines Informations 

SELECT glrb.NAME, glrb.description, glrb.attribute1,glrl.recurring_header_id, glrl.recurring_line_num,

       glrl.code_combination_id, glrl.description, glrl.entered_dr,

       glrl.entered_cr

  FROM gl_recurring_batches glrb,

       gl_recurring_lines glrl

  WHERE glrb.RECURRING_BATCH_ID =  glrl.RECURRING_HEADER_ID

--Recurring Jurnal Rule Calculations Details Informations 

SELECT grcr.recurring_header_id, grcr.recurring_line_num, grcr.rule_num, grcr.OPERATOR, grcr.AMOUNT, grcr.segment1,

       grcr.segment2, grcr.segment3, grcr.segment4, grcr.segment5, grcr.segment6, grcr.ledger_currency,

       grcr.currency_type, grcr.actual_flag, grcr.amount_type

  FROM gl_recurring_line_calc_rules grcr

SELECT * FROM  GL_RECURRING_LINE_CALC_RULES