BIP Joining GL with PJF_PROJECTS_ALL_B — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!