eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: JL.JL_BR_GL_LEGAL_REP#

Source

View Text - Preformatted


select CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ACCOUNTING_BALANCING_SEGMENT ACCOUNTING_BALANCING_SEGMENT, APPLICATION_ID APPLICATION_ID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PRINTED_START_DATE PRINTED_START_DATE, PRINTED_END_DATE PRINTED_END_DATE, PRINTED_START_PERIOD PRINTED_START_PERIOD, PRINTED_END_PERIOD PRINTED_END_PERIOD, BOOK_NUMBER BOOK_NUMBER, DEFINITIVE DEFINITIVE, MAX_NUMBER_PAGES MAX_NUMBER_PAGES, DAILY_LEDGER_FLAG DAILY_LEDGER_FLAG, REGISTER_NUMBER REGISTER_NUMBER, REGISTER_SUBSIDIARY REGISTER_SUBSIDIARY, REGISTER_DIGIT REGISTER_DIGIT, NAME NAME, ADDRESS_LINE_1 ADDRESS_LINE_1, ADDRESS_LINE_2 ADDRESS_LINE_2, ADDRESS_LINE_3 ADDRESS_LINE_3, ACCOUNTANT_NAME ACCOUNTANT_NAME, ACCOUNTANT_NUMBER ACCOUNTANT_NUMBER, DAILY_INSCRIPTION_NUMBER DAILY_INSCRIPTION_NUMBER, DAILY_INSCRIPTION_DATE DAILY_INSCRIPTION_DATE, DAILY_ENTITY DAILY_ENTITY, DAILY_LOCATION DAILY_LOCATION, LEDGER_INSCRIPTION_NUMBER LEDGER_INSCRIPTION_NUMBER, LEDGER_INSCRIPTION_DATE LEDGER_INSCRIPTION_DATE, LEDGER_ENTITY LEDGER_ENTITY, LEDGER_LOCATION LEDGER_LOCATION, DIRECTOR_REGISTER_NUMBER DIRECTOR_REGISTER_NUMBER, DIRECTOR_REGISTER_DIGIT DIRECTOR_REGISTER_DIGIT, TRIAL_BALANCE_NUMBER_PAGES TRIAL_BALANCE_NUMBER_PAGES, DAILY_NUMBER_PAGES DAILY_NUMBER_PAGES, SEGMENT_LOW SEGMENT_LOW, SEGMENT_HIGH SEGMENT_HIGH, CITY CITY from "JL"."JL_BR_GL_LEGAL_REP"

View Text - HTML Formatted

SELECT CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ACCOUNTING_BALANCING_SEGMENT ACCOUNTING_BALANCING_SEGMENT
, APPLICATION_ID APPLICATION_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PRINTED_START_DATE PRINTED_START_DATE
, PRINTED_END_DATE PRINTED_END_DATE
, PRINTED_START_PERIOD PRINTED_START_PERIOD
, PRINTED_END_PERIOD PRINTED_END_PERIOD
, BOOK_NUMBER BOOK_NUMBER
, DEFINITIVE DEFINITIVE
, MAX_NUMBER_PAGES MAX_NUMBER_PAGES
, DAILY_LEDGER_FLAG DAILY_LEDGER_FLAG
, REGISTER_NUMBER REGISTER_NUMBER
, REGISTER_SUBSIDIARY REGISTER_SUBSIDIARY
, REGISTER_DIGIT REGISTER_DIGIT
, NAME NAME
, ADDRESS_LINE_1 ADDRESS_LINE_1
, ADDRESS_LINE_2 ADDRESS_LINE_2
, ADDRESS_LINE_3 ADDRESS_LINE_3
, ACCOUNTANT_NAME ACCOUNTANT_NAME
, ACCOUNTANT_NUMBER ACCOUNTANT_NUMBER
, DAILY_INSCRIPTION_NUMBER DAILY_INSCRIPTION_NUMBER
, DAILY_INSCRIPTION_DATE DAILY_INSCRIPTION_DATE
, DAILY_ENTITY DAILY_ENTITY
, DAILY_LOCATION DAILY_LOCATION
, LEDGER_INSCRIPTION_NUMBER LEDGER_INSCRIPTION_NUMBER
, LEDGER_INSCRIPTION_DATE LEDGER_INSCRIPTION_DATE
, LEDGER_ENTITY LEDGER_ENTITY
, LEDGER_LOCATION LEDGER_LOCATION
, DIRECTOR_REGISTER_NUMBER DIRECTOR_REGISTER_NUMBER
, DIRECTOR_REGISTER_DIGIT DIRECTOR_REGISTER_DIGIT
, TRIAL_BALANCE_NUMBER_PAGES TRIAL_BALANCE_NUMBER_PAGES
, DAILY_NUMBER_PAGES DAILY_NUMBER_PAGES
, SEGMENT_LOW SEGMENT_LOW
, SEGMENT_HIGH SEGMENT_HIGH
, CITY CITY
FROM "JL"."JL_BR_GL_LEGAL_REP"