questions, questions

Hello,

I have my data query as shown below (R12.1.3 DEV/TEST instance):

- <dataQuery>

- <sqlStatement name="Q_PARAM">

- <![CDATA[ SELECT to_char(:P_AS_OF_DATE,'YYYY-MM-DD') AS_OF_DATE ,:P_VENDOR_NO VENDOR_NO ,:P_CCID CCID ,:P_ORDER_BY ORDER_BY ,:P_SORT_ORDER SORT_ORDER ,:P_WHERE WHERE_CLAUSE FROM dual  ]]>

  </sqlStatement>

- <sqlStatement name="Q_SELECT">

- <![CDATA[ select r12_atb.invoice_id, substr(po.segment1,1,10) vendor_no, substr(po.vendor_name,1,30) vendor_name, decode(po.payment_priority,50,'MERCHANDISE','EXPENSE') vendor_category, substr(upper(po.vendor_type_lookup_code),1,20) vendor_type_lookup_code, decode(pov.vendor_site_code,'FACTOR',decode(substr(pov.address_line1,1,2),'OR',substr(pov.address_line1,3),pov.address_line1),pov.vendor_site_code) vendor_site_code, substr(ai.invoice_num,1,20) invoice_num, ai.invoice_date, '25-FEB-2012' due_date,