General ledger report

SELECT

GJS.JE_SOURCE_NAME     "Source",

GJC.JE_CATEGORY_NAME  "Category",

GJB.NAME              "Batch Name",

GJH.NAME          "JE Name",

GJH.DATE_CREATED  "GL Date",

--ROWNUM            "Doc Seq No",

GJB.DESCRIPTION   "Short Descr Of Acc",

GJH.DESCRIPTION   "Full Details",

GJL.ACCOUNTED_DR  "Debit",

GJL.ACCOUNTED_CR  "Credit",

GJL.CODE_COMBINATION_ID "GL Code,Description"

FROM

GL_JE_HEADERS           GJH,

GL_JE_BATCHES             GJB,

GL_JE_LINES               GJL,

GL_PERIODS                GP,

GL_CODE_COMBINATIONS_KFV  GCK,

GL_JE_SOURCES             GJS,

GL_JE_CATEGORIES         GJC,

GL_SETS_OF_BOOKS GSB

WHERE

    GJH.JE_BATCH_ID=GJB.JE_BATCH_ID

AND GJH.JE_HEADER_ID=GJL.JE_HEADER_ID

AND GJL.PERIOD_NAME=GP.PERIOD_NAME

AND GJH.SET_OF_BOOKS_ID=GSB.SET_OF_BOOKS_ID

AND GJL.CODE_COMBINATION_ID=GCK.CODE_COMBINATION_ID

AND GSB.SET_OF_BOOKS_ID=GJL.SET_OF_BOOKS_ID

AND GJS.JE_SOURCE_NAME =GJH.JE_SOURCE

AND GJC.JE_CATEGORY_NAME=GJH.JE_CATEGORY

AND GCK.CHART_OF_ACCOUNTS_ID=GSB.CHART_OF_ACCOUNTS_ID

AND GSB.SET_OF_BOOKS_ID=NVL(:P_SETOF_ID,GSB.SET_OF_BOOKS_ID)

AND GP.PERIOD_NAME=NVL(:PERIOD_NAME,GP.PERIOD_NAME)

AND GCK.CONCATENATED_SEGMENTS BETWEEN

NVL(:P_FLEXFROM,GCK.CONCATENATED_SEGMENTS) AND NVL(:P_FLEXTO,GCK.CONCATENATED_SEGMENTS)

01.000.6130.2270.000

1001-6001-2000-2110-1001-6636-21130-333001