Parameter Name |
SQL text |
Validation |
Ledger |
|
LOV |
Period |
|
LOV |
Show Company |
select distinct
lower(fsav.application_column_name)||',' text
from
fnd_segment_attribute_values fsav
where
:dummy=:dummy and
fsav.application_id=101 and
fsav.id_flex_code='GL#' and
fsav.segment_attribute_type='GL_BALANCING' and
fsav.attribute_value='Y' and
fsav.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:ledger,gl.name)='Y') |
select distinct
lower(fsav.application_column_name)||',' text
from
fnd_segment_attribute_values fsav
where
:dummy=:dummy and
fsav.application_id=101 and
fsav.id_flex_code='GL#' and
fsav.segment_attribute_type='GL_BALANCING' and
fsav.attribute_value='Y' and
fsav.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:ledger,gl.name)='Y')
|
LOV |
Show Account |
select distinct
lower(fsav.application_column_name)||',' text
from
fnd_segment_attribute_values fsav
where
:dummy=:dummy and
fsav.application_id=101 and
fsav.id_flex_code='GL#' and
fsav.segment_attribute_type='GL_ACCOUNT' and
fsav.attribute_value='Y' and
fsav.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:ledger,gl.name)='Y') |
select distinct
lower(fsav.application_column_name)||',' text
from
fnd_segment_attribute_values fsav
where
:dummy=:dummy and
fsav.application_id=101 and
fsav.id_flex_code='GL#' and
fsav.segment_attribute_type='GL_ACCOUNT' and
fsav.attribute_value='Y' and
fsav.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:ledger,gl.name)='Y')
|
LOV |
Show Cost Center |
select distinct
lower(fsav.application_column_name)||',' text
from
fnd_segment_attribute_values fsav
where
:dummy=:dummy and
fsav.application_id=101 and
fsav.id_flex_code='GL#' and
fsav.segment_attribute_type='FA_COST_CTR' and
fsav.attribute_value='Y' and
fsav.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:ledger,gl.name)='Y') |
select distinct
lower(fsav.application_column_name)||',' text
from
fnd_segment_attribute_values fsav
where
:dummy=:dummy and
fsav.application_id=101 and
fsav.id_flex_code='GL#' and
fsav.segment_attribute_type='FA_COST_CTR' and
fsav.attribute_value='Y' and
fsav.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:ledger,gl.name)='Y')
|
LOV |
Show Intercompany |
select distinct
lower(fsav.application_column_name)||',' text
from
fnd_segment_attribute_values fsav
where
:dummy=:dummy and
fsav.application_id=101 and
fsav.id_flex_code='GL#' and
fsav.segment_attribute_type='GL_INTERCOMPANY' and
fsav.attribute_value='Y' and
fsav.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:ledger,gl.name)='Y') |
select distinct
lower(fsav.application_column_name)||',' text
from
fnd_segment_attribute_values fsav
where
:dummy=:dummy and
fsav.application_id=101 and
fsav.id_flex_code='GL#' and
fsav.segment_attribute_type='GL_INTERCOMPANY' and
fsav.attribute_value='Y' and
fsav.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:ledger,gl.name)='Y')
|
LOV |
Show All Segments |
select
lower(fifsv.application_column_name)||',' text
from
fnd_id_flex_segments_vl fifsv
where
:dummy=:dummy and
fifsv.application_id=101 and
fifsv.id_flex_code='GL#' and
fifsv.id_flex_num=(select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:ledger,gl.name)='Y' and rownum=1)
order by
fifsv.segment_num |
select
lower(fifsv.application_column_name)||',' text
from
fnd_id_flex_segments_vl fifsv
where
:dummy=:dummy and
fifsv.application_id=101 and
fifsv.id_flex_code='GL#' and
fifsv.id_flex_num=(select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:ledger,gl.name)='Y' and rownum=1)
order by
fifsv.segment_num
|
LOV |
Summary Template |
gb.template_id=(select gstv.template_id from gl_summary_templates_v gstv where gstv.template_name=:summary_template and gstv.ledger_name=:ledger) |
gb.template_id=(select gstv.template_id from gl_summary_templates_v gstv where gstv.template_name=:summary_template and gstv.ledger_name=:ledger)
|
LOV |
Account Type |
gcc.account_type=xxen_util.lookup_code(:account_type,'ACCOUNT_TYPE',0) |
gcc.account_type=xxen_util.lookup_code(:account_type,'ACCOUNT_TYPE',0)
|
LOV |
GL_SEGMENT1 |
|
LOV |
GL_SEGMENT1 From |
gcc.segment1>=:segment1_from |
gcc.segment1>=:segment1_from
|
LOV |
GL_SEGMENT1 To |
gcc.segment1<=:segment1_to |
gcc.segment1<=:segment1_to
|
LOV |
GL_SEGMENT2 |
|
LOV |
GL_SEGMENT2 From |
gcc.segment2>=:segment2_from |
gcc.segment2>=:segment2_from
|
LOV |
GL_SEGMENT2 To |
gcc.segment2<=:segment2_to |
gcc.segment2<=:segment2_to
|
LOV |
GL_SEGMENT3 |
|
LOV |
GL_SEGMENT3 From |
gcc.segment3>=:segment3_from |
gcc.segment3>=:segment3_from
|
LOV |
GL_SEGMENT3 To |
gcc.segment3<=:segment3_to |
gcc.segment3<=:segment3_to
|
LOV |
GL_SEGMENT4 |
|
LOV |
GL_SEGMENT4 From |
gcc.segment4>=:segment4_from |
gcc.segment4>=:segment4_from
|
LOV |
GL_SEGMENT4 To |
gcc.segment4<=:segment4_to |
gcc.segment4<=:segment4_to
|
LOV |
GL_SEGMENT5 |
|
LOV |
GL_SEGMENT5 From |
gcc.segment5>=:segment5_from |
gcc.segment5>=:segment5_from
|
LOV |
GL_SEGMENT5 To |
gcc.segment5<=:segment5_to |
gcc.segment5<=:segment5_to
|
LOV |
GL_SEGMENT6 |
|
LOV |
GL_SEGMENT6 From |
gcc.segment6>=:segment6_from |
gcc.segment6>=:segment6_from
|
LOV |
GL_SEGMENT6 To |
gcc.segment6<=:segment6_to |
gcc.segment6<=:segment6_to
|
LOV |
GL_SEGMENT7 |
|
LOV |
GL_SEGMENT7 From |
gcc.segment7>=:segment7_from |
gcc.segment7>=:segment7_from
|
LOV |
GL_SEGMENT7 To |
gcc.segment7<=:segment7_to |
gcc.segment7<=:segment7_to
|
LOV |
GL_SEGMENT8 |
|
LOV |
GL_SEGMENT8 From |
gcc.segment8>=:segment8_from |
gcc.segment8>=:segment8_from
|
LOV |
GL_SEGMENT8 To |
gcc.segment8<=:segment8_to |
gcc.segment8<=:segment8_to
|
LOV |
GL_SEGMENT9 |
|
LOV |
GL_SEGMENT9 From |
gcc.segment9>=:segment9_from |
gcc.segment9>=:segment9_from
|
LOV |
GL_SEGMENT9 To |
gcc.segment9<=:segment9_to |
gcc.segment9<=:segment9_to
|
LOV |
GL_SEGMENT10 |
|
LOV |
GL_SEGMENT10 From |
gcc.segment10>=:segment10_from |
gcc.segment10>=:segment10_from
|
LOV |
GL_SEGMENT10 To |
gcc.segment10<=:segment10_to |
gcc.segment10<=:segment10_to
|
LOV |
Balance Type |
|
LOV |
Revaluation Currency |
|
LOV |
Revaluation Conversion Type |
|
LOV |