JA India - Receiving Accounts - draft

Select  J.Organization_code,
            J.receipt_num,
            J.transaction_type,
            J.Transaction_id,
            J.acct_type,
            decode(J.acct_nature,'MODVAT','CENVAT','CENVAT','CENVAT Adjustment',acct_nature) acct_nature,
            nvl(J.Entered_cr,0) Entered_cr,
            nvl(J.Entered_dr,0) Entered_dr, 
            J.Period_name,
            J.Creation_date,
            J.Currency_code,
            nvl(J.Currency_Conversion_rate,1)   Currency_Conversion_rate,
            S.line_num,
            S.Item_Description,
            G.Concatenated_Segments,
            T.Unit_of_measure UOM,
            T.Quantity
FROM  JAI_RCV_JOURNAL_ENTRIES J,
            RCV_TRANSACTIONS T,
            RCV_SHIPMENT_LINES S,
            GL_CODE_COMBINATIONS_KFV G,
            rcv_parameters rp
 where J.Organization_code =    
            nvl(:p_Organization_code, J.Organization_Code)
     and  J.receipt_num = nvl(:p_receipt_num, J.receipt_num)
     and S.Line_num = nvl(:p_Line_num, S.Line_num)
     and  ( J.Acct_nature = 
            nvl(:p_Acct_nature, J.Acct_nature)
            or J.Acct_nature = nvl(:P_cenvat, :P_Acct_nature)
            or J.Acct_nature = nvl(:P_expense, :P_Acct_nature)  )             
     and J.Transaction_type = 
            nvl(:p_Transaction_type, J.Transaction_type)
     and Trunc(J.Transaction_date)  >=                                                   nvl(:p_Transaction_date_from, J.Transaction_date)
     and Trunc(J.Transaction_date) <=  
             nvl(:p_Transaction_date_to, J.Transaction_date)
     and J.Shipment_line_id = S.Shipment_line_id
     and J.Code_Combination_id = G.Code_Combination_id
     and J.Transaction_id = T.Transaction_id
     and rp.organization_id = T.organization_id
     and J.Acct_nature not like 'Deliver%' 
     and J.Acct_nature not like  'Average%'
   order by j.organization_code,
                decode(rp.manual_receipt_num_type,
                'NUMERIC',
                J.receipt_num,
                j.receipt_num),
                line_num,
                decode(j.transaction_type, 'RECEIVE', 1,
                             'DELIVER', 2,
                             'RETURN TO RECEIVING', 3,
                             'RETURN TO VENDOR', 4),
                j.transaction_date,
				J.acct_type