90: rcv.oe_order_line_id oe_order_line_id,
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
105: tran.line_id oe_order_line_id,
106: tran.line_id,
107: tran.orgn_code,
108: tran.whse_code
109: FROM ic_tran_pnd tran
110: WHERE doc_type = 'OMSO'
111: AND completed_ind = 1
112: AND gl_posted_ind = 1
113: GROUP BY doc_type, line_id, line_id, orgn_code, whse_code) tran,