General Ledger - EBS (MOSC)

MOSC Banner

Query For FSG Row Sets

I wrote this query to return the details of a row set. The first part of the query works great to get the account assignments and I added the union to get the headers. On some row sets it works but on most it returns at least two rows for every row in the row set. I would also like to add the rows with calculations. Any suggestions?

SELECT RRA.AXIS_SET_ID,RA.NAME,RRA.AXIS_SEQ,RRA.DESCRIPTION, RRA.LAST_UPDATED_BY,

 RRC.SIGN,

 rra.display_flag,

 RRC.SEGMENT1_LOW||'-'||RRC.SEGMENT2_LOW||'-'||RRC.SEGMENT3_LOW||'-'||RRC.SEGMENT4_LOW||'-'||RRC.SEGMENT5_LOW||'-'||RRC.SEGMENT6_LOW||'-'||RRC.SEGMENT7_LOW||'-'||RRC.SEGMENT8_LOW "LOW",

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center