Oracle Applications - SQL Developer Report - DBA - Get Edition Based Objects

gistfile1.txt

<?xml version="1.0" encoding="UTF-8" ?>
<displays>
<display id="04eedfd8-0155-1000-8001-0a019623a7fb" type="" style="Table" enable="true">
	<name><![CDATA[GET_EDITION_BASED_REVISION_OBJECTS]]></name>
	<description><![CDATA[Simple query to look at objects associated with editioning]]></description>
	<tooltip><![CDATA[]]></tooltip>
	<drillclass><![CDATA[null]]></drillclass>
	<CustomValues>
		<TYPE>horizontal</TYPE>
	</CustomValues>
	<query>
		<sql><![CDATA[--edition based versioning oracle

WITH obj_set AS

  (SELECT :object_name object_name FROM dual

  )

SELECT ao.owner,

  ao.object_name,

  ao.object_type

FROM all_objects ao

JOIN obj_set os

ON ao.object_name IN (os.object_name, SUBSTR(os.object_name, 1,29)

  ||'#')]]></sql>
		<binds>
			<bind id="object_name">
				<prompt><![CDATA[object_name]]></prompt>
				<tooltip><![CDATA[object_name]]></tooltip>
				<value><![CDATA[XXCMFG_INV_SYSTEM_ITEMS_MV]]></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>