PO Standard Notes Listing

➜ Back to Library
Description
Categories: BI Publisher
Application: Purchasing
Source: Standard Notes Listing (XML)
Short Name: POXNOTES_XML
DB package: PO_POXNOTES_XMLP_PKG 
SELECT   DISTINCT    fdvl.category_description	Usage 
,		fdvl.description		Name 
,		fdvl.START_DATE_ACTIVE	Start_date 
,		fdvl.END_DATE_ACTIVE	End_date 
--,		fdvl.media_id		Media_id
,		fdvl.media_id		Media_id_1
,		fdvl.datatype_id		Datatype_id
FROM	fnd_documents_vl fdvl 
WHERE	fdvl.category_application_id = 201
AND           (fdvl.datatype_id = 1 or fdvl.datatype_id = 2)
AND	 fdvl.usage_type = 'S' 
AND    	 fdvl.category_description        >= decode(:P_usage_from,'',
                                       			 fdvl.category_description,:P_usage_from)
AND      	 fdvl.category_description        <= decode(:P_usage_to,'',
                                       			 fdvl.category_description,:P_usage_to)
AND     	 fdvl.description     	              >= decode(:P_title_from,'',
                                       			 fdvl.description,:P_title_from)
AND    	 fdvl.description    	              <= decode(:P_title_to,'',
                                      			 fdvl.description,:P_title_to)
ORDER BY   fdvl.category_description, fdvl.description
Parameter Name SQL text Validation
Report Title 
 
 Char
Usages From 
 
 LOV Oracle
To 
 
 LOV Oracle
To 
 
 LOV Oracle
Names From 
 
 LOV Oracle
Download
Related Blitz Reports
GL Journals (Drilldown) FND Help Documents and Targets GL Journals (Drilldown) 11g XXGL Journals WIP MES Job Traveler Data Template AP Invoices and Lines PO Approved Supplier List AP Invoices and Lines 11i AP Preliminary Payment Register 11i AR Customer Upload
Blitz Report™

Blitz Report™ provides multiple benefits: