To find the Last Updated Rtf Template

-
To find the Last Updated Rtf Template

SELECT DISTINCT (xl.file_name) "File Name",
                xtb.template_code "Template Code",
                xtt.template_name "Template Name",
                xtb.template_type_code "Type",
                xtb.default_output_type "Default Output Type",
                xtt.last_update_date
  FROM apps.xdo_ds_definitions_vl xddv,
       apps.xdo_templates_b xtb,
       apps.xdo_templates_tl xtt,
       apps.xdo_lobs xl,
       apps.fnd_application_tl fat,
       apps.fnd_application fa
 WHERE     1 = 1
       AND xddv.application_short_name = fa.application_short_name
       AND fat.application_id = fa.application_id
       AND xtb.application_short_name = xddv.application_short_name
       AND xddv.data_source_code = xtb.data_source_code
       AND xtt.template_code = xtb.template_code
       AND xl.lob_code = xtb.template_code
       AND xl.xdo_file_type = xtb.template_type_code
       AND xl.file_name LIKE '%.rtf'
       AND TRUNC (xl.last_update_date) = TRUNC(SYSDATE)

Comments

Post a Comment

Popular posts from this blog

Deleting the Sourcing Rule Assignments API

-
Deleting the Sourcing Rule Assignments API DECLARE        l_return_status VARCHAR2(200);        l_msg_count  NUMBER;        l_msg_data VARCHAR2(2000);        l_assignment_set_rec mrp_src_assignment_pub.assignment_set_rec_type;        l_assignment_set_val_rec mrp_src_assignment_pub.assignment_set_val_rec_type;        l_assignment_tbl mrp_src_assignment_pub.assignment_tbl_type;        l_assignment_val_tbl mrp_src_assignment_pub.assignment_val_tbl_type;        o_assignment_set_rec mrp_src_assignment_pub.assignment_set_rec_type;        o_assignment_set_val_rec mrp_src_assignment_pub.assignment_set_val_rec_type;        o_assignment_tbl mrp_src_assignment_pub.assignment_tbl_type;        o_assignment_val_tbl mrp_src_assignment_pub.assignment_val_tbl_type; ...
Read more

BarCode with XML Publisher

-
Image
Barcode Steps Code 128 Barcode with XML Publisher Step:1 XML Tags and template Create or use existing oracle reports concurrent program. Change the output format under concurrent program definition to XML, run the concurrent program and get the XML tags. Map the RTF based on the XML tags generated. Step:2 Getting barcode fonts For barcode I have used Code 128 from IDAutomation (you can download from their site) After installing the font on local machine assign one of the IDAutomation font to the field in RTF template (for example an order number and font can be eg: IDAutomationSC128M) Step:3 Barcode font reading by handheld or scanner To make the barcode to be read by scanner, the encoder java code provided by vendor has to be compiled and convert it into a java class file. A.       Below is the class code save the code in a notepad and rename it as BarcodeUtil.java B.       Move the class file with EBSO fil...
Read more
-
 Active project Managers Query SELECT DISTINCT hou.name org_name,        ppa.name project_name,        ppa.segment1 project_number,        ppa.project_type,    pe.full_name Project_Manager,    amount_limit Purchase_Requisition_approval,    pe.email_address,        ppa.start_date,        to_char(ppa.completion_date,'DD-MON-YYYY')completion_date ,        ppa.closed_date,        ppa.enabled_flag   FROM apps.pa_project_parties ppp,    apps.pa_projects_all ppa,    apps.pa_project_role_types pprt,    apps.per_all_people_f pe,    apps.pa_project_assignments pa,    apps.fnd_user u,        apps.hr_operating_units hou,   (SELECT paf.person_id,   paf.assignment_type,       pcr.amount_limit   ...
Read more