Xml Publisher Part 1

                                                  --Developed By Sainaatth--


XML Publisher Reports :
----------------------------
-- Is a Template based solustion for Oracle Reports
-- Template based Reporting Tool
-- This is an Independent (Not depend on any Code)
    Depency on .xml data file
-- template builder to add add-ins
we can generate the .xml data file using many methods.
1. Using .rdf
2. PLSQL Method
3. Data Templates / BI
4. HTML Commands
5. Note pad Methods
6. PDF Method

Process :
-----------
1. We have to generate the .xml data file
2. Use the file as input source to the LayOut
    (Layout will be designed in the MS Word -> .rtf)
3. Will see the Output in required format

Process : (Registration) (Using .rdf)
----------
1. We have to develope the .rdf by placing our code in Data Model
    (i.e., No need to design the Lay Out in .rdf)
2. Move the .rdf file in to server ($Custom_TOP/reports/US/)
3. Login to Applications
    Go to System Administrator to create Executable
    Create Concurrent Program by attaching the Executable
  ** Concurrent Program Output method should be XML
4. Add the Conc Program to the Request Group

Navigate the Responsibility, Submit the Request
Get the xml data file.

5. Design the Layout in MS Word by using the .xml data file as source
6. Save the File as .rtf (Rich Text Format)
7. Go to XML Publisher Administrator Responsibility to create Data Definition
    While creating Data Definition,
    we have to give Conc Program Short Name to the "Code" Field.
8. Create Template by giving the Data Definition Details
    and Attach the .rtf file

Diff. b/n .rdf and .rtf :
--------------------------
               RDF                                        RTF
               -----                                        -----
1. Layout Model is dependent on               |1. Layout Model is independent
    Data model Code                             |    (It will look for .xml data file)
2. We can see output in one                       |2. can see the output in different output
    format (by default)                             |    formats
    System parameters
3. we can not use SQL Functions               | 3. We can use SQL Functions at Source
    in rdf Lay out source field                                 field define level
    define level
4. Only one Layout will be there                | 4. we can define multiple .rtf files
                                                    (Multiple .rtf files can be attached
                                                          against to the Single Template)
                                                            (while submitting the conc prog
                                                                we have to select the .rtf file)
5. Not User Friendly                     | 5. User Friendly


AP Invoice Report Using .rdf Method :
--------------------------------------------
 
OU Name   Invoice Number   Invoice Type   Supplier Name  Supp Site  
Invoice Amount

Parameter :
--------------
* OU Name
Supplier Name

Query :
---------
SELECT HOU.NAME OU_NAME,
AIA.INVOICE_NUM,
AIA.INVOICE_TYPE_LOOKUP_CODE,
APS.VENDOR_NAME,
ASSA.VENDOR_SITE_CODE,
AIA.INVOICE_AMOUNT
FROM HR_OPERATING_UNITS HOU,
AP_INVOICES_ALL AIA,
AP_SUPPLIERS APS,
AP_SUPPLIER_SITES_ALL ASSA
WHERE 1=1
AND HOU.ORGANIZATION_ID = AIA.ORG_ID
AND AIA.VENDOR_ID = APS.VENDOR_ID
AND APS.VENDOR_ID = ASSA.VENDOR_ID
AND ASSA.VENDOR_SITE_ID = AIA.VENDOR_SITE_ID
AND ASSA.ORG_ID = HOU.ORGANIZATION_ID
AND ORGANIZATION_ID = :P_ORG_ID
AND AIA.VENDOR_ID = NVL(:P_VENDOR_ID, AIA.VENDOR_ID);