91: tran.line_id,
92: tran.orgn_code,
93: tran.whse_code
94: FROM ic_tran_pnd tran,
95: rcv_transactions rcv
96: WHERE doc_type = 'PORC'
97: AND completed_ind = 1
98: AND gl_posted_ind = 1
99: AND tran.line_id = rcv.transaction_id