Common User Topics

×
Menu

Query Set SQL Syntax

 
As a user you must have access to the 'Profile System Values (FND_FNDPOMPV) function to use this functionality.
 
Standard SQL Syntax is used to create the bulk of the query.  Specific syntax unique to the Custom Query is used to create ‘User Filters’ and ‘Links’ between the Queries and the Query Sets.
 
1.  Select Syntax
select je_header_id
      ,je_source source
      ,period_name
      ,name
      ,currency_code
      ,RUNNING_TOTAL_DR
      ,RUNNING_TOTAL_CR
from gl_je_headers
where actual_flag='A'
and status='U'
and je_source in ('Spreadsheet','Manual')
 
The selected column or column alias will appear on the spreadsheet as a column header.
The _ character will be substituted with a space when displayed on the spreadsheet.
No spaces or special characters are allowed in the column heading so if you are using a function such as decode(), nvl(), sum() etc you MUST add a column alias.
 
2.  Adding Links between Parent and Child Queries
    The parent query must have the column that you want to join with:
 
JE_HEADER_ID
 
The child queries will join on this column.
 
Child queries must have the key column from the parent query in the select clause (it doesn’t have to be the exact name as it has to be when you use it later to create the joins): 
JE_HEADER_ID
CODE_COMBINATION_ID
 
Refer to section: