GL FSG - Content Set Detail Listing

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Content Set Detail Listing
Application: General Ledger
Source: FSG - Content Set Detail Listing (XML)
Short Name: RGXCOND_XML
DB package: GL_RGXCOND_XMLP_PKG
Run GL FSG - Content Set Detail Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT DISTINCT OVERRIDE_SEQ SEQUENCE,
       &P_FLEXDATA_LOW  C_DATA_LOW,
       &P_FLEXDATA_HIGH C_DATA_HIGH,
       &P_FLEXDATA_TYPE C_DATA_TYPE,
       LK.MEANING SUMMARY,
       CONTENT_SET_ID,
	/*GL_RGXCOND_XMLP_PKG.c_flex_lowformula(:C_FLEX_LOW) C_FLEX_LOW,
	GL_RGXCOND_XMLP_PKG.c_flex_highformula(:C_FLEX_HIGH) C_FLEX_HIGH,
	GL_RGXCOND_XMLP_PKG.c_flex_typeformula(:C_FLEX_TYPE) C_FLEX_TYPE*/
	GL_RGXCOND_XMLP_PKG.c_flex_lowformula(&P_FLEXDATA_LOW) C_FLEX_LOW,
	GL_RGXCOND_XMLP_PKG.c_flex_highformula(&P_FLEXDATA_HIGH) C_FLEX_HIGH,
	GL_RGXCOND_XMLP_PKG.c_flex_typeformula(&P_FLEXDATA_TYPE) C_FLEX_TYPE
FROM RG_REPORT_CONTENT_OVERRIDES R,
     FND_LOOKUPS LK,
     GL_LEDGERS GLLED
WHERE
       LK.LOOKUP_TYPE(+)='YES_NO'
  AND  LK.LOOKUP_CODE(+) = NVL(RANGE_MODE, '1234567890123456789012345678901')
  and GLLED.LEDGER_ID(+) = R.LEDGER_ID
 and CONTENT_SET_ID=:CONTENT_SET_ID1
ORDER BY OVERRIDE_SEQ
Parameter Name SQL text Validation
Content Set Name 
 
 LOV Oracle
Download
Related Blitz Reports
GL FSG - Content Set Summary Listing GL FSG - Report Detail Listing GL FSG - Report Summary Listing GL FSG - Report Set Detail Listing GL FSG Reports GL FSG - Row Set Detail Listing GL FSG - Column Set Detail Listing CAC Internal Order Shipment Margin JA Third Party Detail Trial Balance with Contra Accounts
Blitz Report™

Blitz Report™ provides multiple benefits: