PO Standard Notes Listing
Description
Categories: BI Publisher
Application: Purchasing
Source: Standard Notes Listing (XML)
Short Name: POXNOTES_XML
DB package: PO_POXNOTES_XMLP_PKG
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 |