BIP Joining GL with PJF_PROJECTS_ALL_B
I'm trying to join PJF_PROJECTS_ALL_B with this query so that I can add segment1 from the table to this GL report. Does anyone have any insight for easiest way to achieve this?
SELECT
gjb.created_by,
gjb.last_updated_by,
gjb.creation_date,
gjb.name Journal_Batch,
gjb.description Journal_Batch_Description,
gjb.status Posting_Status,
gjh.period_name,
gjh.je_category,
gjt.description Journal_Cat_Desc,
gjs.user_je_source_name,
gjs.description Journal_Source_Desc,
gcc.concatenated_segments,
SUM(gjl.accounted_dr) Accounted_Debit,
SUM(gjl.accounted_cr) Accounted_Credit,
SUM(gjl.entered_dr) Entered_Debit,