Project Transaction Interface in oracle apps

SELECT ptia.project_number

     , ptia.cdl_system_reference1

     , ptia.creation_date

     , ptia.task_number

     , ptia.expenditure_type

     , pet.expenditure_category

     , ptia.attribute1

     , ptia.attribute2

     , ptia.expenditure_ending_date

     , ptia.expenditure_item_date

     , ptia.system_linkage

     , ptia.quantity

     , ptia.denom_raw_cost

     , ptia.orig_transaction_reference

     , ptia.transaction_source

     , ptia.batch_name

     , ptia.expenditure_comment

     , fnm.message_text rejection_reason

  FROM pa.pa_transaction_interface_all ptia

     , pa.pa_expenditure_types pet

     , applsys.fnd_new_messages fnm

 WHERE ptia.expenditure_type = pet.expenditure_type(+)

   AND ptia.transaction_rejection_code = fnm.message_name(+)

   AND ptia.creation_date >= '27-NOV-2012';