PO Standard Notes Listing

Description
Categories: BI Publisher, Procurement
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
To
 
LOV Oracle
Names From
 
LOV Oracle
To
 
LOV Oracle
Usages From
 
LOV Oracle
Report Title