APPS.PA_EXPENDITURE_INQUIRY SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 40

       select vend.vendor_id,
              cdl.system_reference2,
              vend.vendor_name,
              vend.segment1,
	      cdl.burden_sum_rejection_code
         from po_vendors vend,
              PA_COST_DIST_LINES_ALL_BAS cdl
        where cdl.expenditure_item_id = p_expenditure_item_id
          and cdl.line_num (+)        = 1
/* Added the getNumericString wrapper over systeem_reference1  for bug3158748 */
          and pa_utils4.getNumericString(cdl.system_reference1)  = vend.vendor_id (+) ;