GL Chart of Accounts - Segment Values Listing
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Reports on segment values by segment.
Application: General Ledger
Source: Chart of Accounts - Segment Values Listing (XML)
Short Name: GLXRLSEG_XML
DB package: GL_GLXRLSEG_XMLP_PKG
Description: Reports on segment values by segment.
Application: General Ledger
Source: Chart of Accounts - Segment Values Listing (XML)
Short Name: GLXRLSEG_XML
DB package: GL_GLXRLSEG_XMLP_PKG
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
select vi.flex_value isval, vit.description isdsc, vd.flex_value dsval, vdt.description dsdsc, vd.start_date_active sdate, vd.end_date_active edate, l1.meaning eflag, l3.meaning pflag, l4.meaning bflag, l5.description atype from fnd_flex_values vi, fnd_flex_values_tl vit, fnd_flex_values vd, fnd_flex_values_tl vdt, gl_lookups l1, gl_lookups l3, gl_lookups l4, gl_lookups l5 where vi.flex_value_set_id = :PVSETID and vit.flex_value_id = vi.flex_value_id + 0 and vit.language = userenv('LANG') and vd.flex_value_set_id = :VSETID and vd.parent_flex_value_low = vi.flex_value and vd.enabled_flag = l1.lookup_code and vdt.flex_value_id = vd.flex_value_id + 0 and vdt.language = userenv('LANG') and l1.lookup_type = 'YES/NO' and substrb( fnd_global.newline||vd.compiled_value_attributes||fnd_global.newline, instrb( fnd_global.newline||vd.compiled_value_attributes||fnd_global.newline ,fnd_global.newline, 1, :POST_POSITION ) +1, 1 ) = l3.lookup_code and l3.lookup_type = 'YES/NO' and substrb( fnd_global.newline||vd.compiled_value_attributes||fnd_global.newline, instrb ( fnd_global.newline||vd.compiled_value_attributes||fnd_global.newline, fnd_global.newline,1, :BUDGET_POSITION )+1, 1 ) = l4.lookup_code and l4.lookup_type = 'YES/NO' and nvl(substrb( fnd_global.newline||vd.compiled_value_attributes||fnd_global.newline, instrb( fnd_global.newline||vd.compiled_value_attributes||fnd_global.newline, fnd_global.newline, 1, :POSITION ) +1, 1 ),'A') = l5.lookup_code(+) and l5.lookup_type(+) = 'ACCOUNT TYPE' order by vi.flex_value, vd.flex_value |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Segment Name |
|
LOV Oracle |