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 |
