GL FSG - Row Order Detail Listing

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Row Order Detail Listing
Application: General Ledger
Source: FSG - Row Order Detail Listing (XML)
Short Name: RGXRORDD_XML
DB package: GL_RGXRORDD_XMLP_PKG
SELECT rss.row_order_id row_order_id1,
--SELECT rss.row_order_id,
       fs.segment_name segment,
       rss.segment_sequence,
       lk1.meaning seg_order_by,
       lk2.meaning segment_display_type,
       rss.segment_width width
FROM
       rg_row_segment_sequences rss,
       fnd_id_flex_segments fs,
       rg_lookups lk1,
       rg_lookups lk2
WHERE  lk1.lookup_type = decode(rss.application_column_name, 'LEDGER_SEGMENT', 'LEDGER_ORDERING_TYPE', 'ORDERING_TYPE')
  AND  lk1.lookup_code = rss.seg_order_type
  AND  lk2.lookup_type = decode(rss.application_column_name, 'LEDGER_SEGMENT', 'LEDGER_SEG_DISPLAY_TYPE', 'SEG_DISPLAY_TYPE')
  AND  lk2.lookup_code = rss.seg_display_type
  AND  nvl(rss.structure_id, nvl(:C_STRUCTURE_ID,101))=
           nvl(:C_STRUCTURE_ID, nvl(structure_id,101))
  AND  fs.application_id = 101
  AND  fs.id_flex_code = :C_ID_FLEX_CODE
  AND  fs.id_flex_num = rss.structure_id
  AND  fs.application_column_name = rss.application_column_name
 and rss.row_order_id=:row_order_id
ORDER BY rss.segment_sequence
Parameter NameSQL textValidation
Row Order Name
 
LOV Oracle
Download
Related Blitz Reports
GL FSG Row Orders GL FSG Rowset and column set GL FSG - Report Detail Listing GL FSG - Report Summary Listing GL FSG Reports GL FSG - Report Set Detail Listing GL Oracle FSG Converter Test: GL Oracle FSG Converter 11g GL Oracle FSG Converter 11g
Blitz Report™