Oracle Applications - SQL Developer Report - AR - Get customer master from party name for Oracle Applications

gistfile1.txt

<?xml version="1.0" encoding="UTF-8" ?>
<displays>
<display id="906666c0-014c-1000-8001-0a0a19141086" type="" style="Table" enable="true">
	<name><![CDATA[GET_CUSTOMER_INFO]]></name>
	<description><![CDATA[Simple query to find customer information quickly in SQL Develoer]]></description>
	<tooltip><![CDATA[]]></tooltip>
	<drillclass><![CDATA[null]]></drillclass>
	<CustomValues>
		<TYPE>horizontal</TYPE>
	</CustomValues>
	<query>
		<sql><![CDATA[SELECT hca.account_name,
  hca.account_number,
  hca.party_id
FROM ar.hz_parties hp
JOIN ar.hz_cust_accounts hca
ON hca.party_id = hp.party_id
WHERE hp.party_name LIKE '%'
  ||:party_name
  ||'%']]></sql>
		<binds>
			<bind id="party_name">
				<prompt><![CDATA[party_name]]></prompt>
				<tooltip><![CDATA[party_name]]></tooltip>
				<value><![CDATA[Brunner]]></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>