Thursday, 4 May 2017

XML Tags

<?for-each:G_1?>

<?end for-each?> 

<?split-by-page-break:?>

<xsl:value-of select="position()"/>

 
<?xdoxslt:sysdate('DD-MON-YYYY HH24:MI')?>
 
<?format-number:field_name;'99G999G999G990D99'?>
 
<?xdoxslt:set_variable($_XDOCTX,'V_OP',CS_OP_VAL_NEW)?>
<?xdoxslt:set_variable($_XDOCTX,'V_CLOS',CS_CL_VAL_NEW)?>
<?xdoxslt:get_variable($_XDOCTX,'V_OP') + RECEIPT_VAL1 - xdoxslt:get_variable($_XDOCTX,'V_CLOS')?>
 
<?sort:current-group()/ITEM_NAME;'ascending';data-type='text'?> 
<?xdoxslt:ifelse ((APR) != 0, xdoxslt:div((APR1)*100,(APR)),0)?>
 
 


<?if: CF_ACC_CODE='Y'  ?> <?call-template: code_y_acc_y?> <?end if?>
<?if: CF_ACC_CODE='N' ?><?call-template: code_n_acc_n?> <?end if?>



<?template:code_n_acc_n?>
<?end template?>
 
<?template:code_y_acc_y?>
<?end template?>



How to HIDE the COLUMN from the RTF report in ORACLE?
ANS: I am HIDE the Open Value column in rtf.
Goto the Column Heading and the type the Code like:
In the if field we type the code like:
<?if@column:/items/@type="PRIVATE"?>
In the end if field we type the code like:
<?end if?>
Then go to the row of open value field.
In the if field we type the code like:
<?if@column:/items/@type="PRIVATE"?>
In the 20.00 field we type the code like:
<?if@column:/items/@type="PRIVATE"?>  <?CF_OPENING_VAL?>  <?end  if?> 
In the end if field we type the code like:
<?end if?>
Then go to the SUM total of the field and type the code like :
In the if field we type the code like:
<?if@column:/items/@type="PRIVATE"?>
In the end if field we type the code like:
<?end if?>

Thursday, 21 January 2016

How to find concurrent program or request will be Completed and Terminated?

SELECT r.request_id, u.user_name requestor, pt.user_concurrent_program_name,
       r.phase_code, r.status_code, r.priority_request_id, r.priority,
       r.request_date, r.requested_by, r.requested_start_date, r.hold_flag,
       r.has_sub_request, r.is_sub_request, r.update_protected,
       r.queue_method_code, r.responsibility_application_id,
       r.responsibility_id, r.save_output_flag, r.last_update_date,
       r.last_updated_by, r.last_update_login, r.printer, r.print_style,
       r.parent_request_id, r.controlling_manager, r.actual_start_date,
       r.actual_completion_date, r.completion_text, r.argument_text,
       r.implicit_code, r.request_type, r.program_application_id,
       r.concurrent_program_id, pb.concurrent_program_name program_short_name,
       pb.execution_method_code, pb.enabled_flag enabled,
       DECODE (r.description,
               NULL, pt.user_concurrent_program_name,
               r.description || ' (' || pt.user_concurrent_program_name || ')'
              ) program_name,
       pb.printer_name fcp_printer, pb.output_print_style fcp_print_style,
       pb.required_style fcp_required_style,
       s.user_printer_style_name user_print_style, r.description
  FROM applsys.fnd_concurrent_programs_tl pt,
       applsys.fnd_concurrent_programs pb,
       applsys.fnd_user u,
       applsys.fnd_printer_styles_tl s,
       applsys.fnd_concurrent_requests r
 WHERE pb.application_id = r.program_application_id
   AND pb.concurrent_program_id = r.concurrent_program_id
   AND pb.application_id = pt.application_id
   AND pb.concurrent_program_id = pt.concurrent_program_id
   AND pt.LANGUAGE = USERENV ('LANG')
   AND u.user_id = r.requested_by
   AND s.printer_style_name(+) = r.print_style
   AND s.LANGUAGE(+) = USERENV ('LANG')
   AND u.user_name = NVL(:p_requestor,u.user_name)
   AND phase_code = 'C' -- Completed
   AND status_code = 'C'
   UNION
SELECT r.request_id, u.user_name requestor, pt.user_concurrent_program_name,
       r.phase_code, r.status_code, r.priority_request_id, r.priority,
       r.request_date, r.requested_by, r.requested_start_date, r.hold_flag,
       r.has_sub_request, r.is_sub_request, r.update_protected,
       r.queue_method_code, r.responsibility_application_id,
       r.responsibility_id, r.save_output_flag, r.last_update_date,
       r.last_updated_by, r.last_update_login, r.printer, r.print_style,
       r.parent_request_id, r.controlling_manager, r.actual_start_date,
       r.actual_completion_date, r.completion_text, r.argument_text,
       r.implicit_code, r.request_type, r.program_application_id,
       r.concurrent_program_id, pb.concurrent_program_name program_short_name,
       pb.execution_method_code, pb.enabled_flag enabled,
       DECODE (r.description,
               NULL, pt.user_concurrent_program_name,
               r.description || ' (' || pt.user_concurrent_program_name || ')'
              ) program_name,
       pb.printer_name fcp_printer, pb.output_print_style fcp_print_style,
       pb.required_style fcp_required_style,
       s.user_printer_style_name user_print_style, r.description
  FROM applsys.fnd_concurrent_programs_tl pt,
       applsys.fnd_concurrent_programs pb,
       applsys.fnd_user u,
       applsys.fnd_printer_styles_tl s,
       applsys.fnd_concurrent_requests r
 WHERE pb.application_id = r.program_application_id
   AND pb.concurrent_program_id = r.concurrent_program_id
   AND pb.application_id = pt.application_id
   AND pb.concurrent_program_id = pt.concurrent_program_id
   AND pt.LANGUAGE = USERENV ('LANG')
   AND u.user_id = r.requested_by
   AND s.printer_style_name(+) = r.print_style
   AND s.LANGUAGE(+) = USERENV ('LANG')
   AND u.user_name = NVL(:p_requestor,u.user_name)
   AND status_code = 'X'