Oracle Applications - SQL Developer Report - APPLSYS - Get DFFs for an Oracle Application

gistfile1.txt

<?xml version="1.0" encoding="UTF-8" ?>
<displays>
<display id="a35c3c5e-0155-1000-8002-0a0a1932933b" type="" style="Table" enable="true">
	<name><![CDATA[GET_DFFs_FOR_ORACLE_APPLICATION]]></name>
	<description><![CDATA[This has binds on oracle app shortname and  dff name]]></description>
	<tooltip><![CDATA[]]></tooltip>
	<drillclass><![CDATA[null]]></drillclass>
	<CustomValues>
		<TYPE>horizontal</TYPE>
	</CustomValues>
	<query>
		<sql><![CDATA[SELECT fcu.*,

  fcv.*,

  ffvs.*

FROM applsys.fnd_descr_flex_contexts fcv

JOIN applsys.fnd_application_tl A

ON fcv.application_id = A.application_id

AND A.language        = 'US'

JOIN applsys.fnd_descr_flex_column_usages fcu

ON fcv.application_id                 = fcu.application_id

AND fcv.descriptive_flexfield_name    = fcu.descriptive_flexfield_name

AND fcv.descriptive_flex_context_code = fcu.descriptive_flex_context_code

JOIN applsys.fnd_descr_flex_col_usage_tl fcut

ON fcu.application_id                 = fcut.application_id

AND fcu.descriptive_flexfield_name    = fcut.descriptive_flexfield_name

AND fcu.descriptive_flex_context_code = fcut.descriptive_flex_context_code

AND fcu.application_column_name       = fcut.application_column_name

AND fcut.language                     = 'US'

LEFT OUTER JOIN applsys.fnd_flex_value_sets ffvs

ON ffvs.flex_value_set_id = fcu.flex_value_set_id

WHERE A.application_name LIKE :application_name

  ||'%'

AND fcu.descriptive_flexfield_name LIKE '%'

  || :dff_name_eg_OE_LINE_ATTRIBUTES

  || '%'

AND fcut.form_left_prompt LIKE '%'

  || :dff_form_left_prompt

  ||'%'

ORDER BY fcut.descriptive_flexfield_name,

  fcut.application_column_name]]></sql>
		<binds>
			<bind id="application_name">
				<prompt><![CDATA[application_name]]></prompt>
				<tooltip><![CDATA[application_name]]></tooltip>
				<value><![CDATA[NULL_VALUE]]></value>
				<bracket><![CDATA[null]]></bracket>
			</bind>
			<bind id="dff_name_eg_OE_LINE_ATTRIBUTES">
				<prompt><![CDATA[dff_name_eg_OE_LINE_ATTRIBUTES]]></prompt>
				<tooltip><![CDATA[dff_name_eg_OE_LINE_ATTRIBUTES]]></tooltip>
				<value><![CDATA[NULL_VALUE]]></value>
				<bracket><![CDATA[null]]></bracket>
			</bind>
			<bind id="dff_form_left_prompt">
				<prompt><![CDATA[dff_form_left_prompt]]></prompt>
				<tooltip><![CDATA[dff_form_left_prompt]]></tooltip>
				<value><![CDATA[NULL_VALUE]]></value>
				<bracket><![CDATA[null]]></bracket>
			</bind>
		</binds>
	</query>
		<pdf version="VERSION_1_7" compression="CONTENT">
			<docproperty title="" author="" subject="" keywords="" />
			<cell toppadding="2" bottompadding="2" leftpadding="2" rightpadding="2" horizontalalign="LEFT" verticalalign="TOP" wrap="true" />
			<column>
				<heading font="null" size="10" style="NORMAL" color="-16777216" rowshading="-1" labeling="FIRST_PAGE" />
				<footing font="null" size="10" style="NORMAL" color="-16777216" rowshading="-1" labeling="NONE" />
				<blob blob="NONE" zip="false" />
			</column>
			<table font="null" size="10" style="NORMAL" color="-16777216" userowshading="false" oddrowshading="-1" evenrowshading="-1" showborders="true" spacingbefore="12" spacingafter="12" horizontalalign="LEFT" />
			<header enable="false" generatedate="false">
				<data>
				null				</data>
			</header>
			<footer enable="false" generatedate="false">
				<data value="null" />
			</footer>
			<security enable="false" useopenpassword="false" openpassword="null" encryption="EXCLUDE_METADATA">
				<permission enable="false" permissionpassword="null" allowcopying="true" allowprinting="true" allowupdating="false" allowaccessdevices="false" />
			</security>
			<pagesetup papersize="LETTER" orientation="1" measurement="in" margintop="1.0" marginbottom="1.0" marginleft="1.0" marginright="1.0" />
		</pdf>
</display>
</displays>