280: tran.line_id,
281: tran.orgn_code,
282: tran.whse_code
283: from ic_tran_pnd tran,
284: rcv_transactions rcv
285: where doc_type = 'PORC'
286: and completed_ind = 1
287: and gl_posted_ind = 0
288: and tran.line_id = rcv.transaction_id
294: tran.line_id,
295: tran.orgn_code,
296: tran.whse_code
297: from ic_tran_cmp tran,
298: rcv_transactions rcv
299: where doc_type = 'PORC'
300: and gl_posted_ind = 0
301: and tran.line_id = rcv.transaction_id
302: and rcv.oe_order_line_id is NOT NULL
418: tran.line_id,
419: tran.orgn_code,
420: tran.whse_code
421: from ic_tran_pnd tran,
422: rcv_transactions rcv
423: where doc_type = 'PORC'
424: and completed_ind = 1
425: and gl_posted_ind = 1
426: and tran.line_id = rcv.transaction_id
432: tran.line_id,
433: tran.orgn_code,
434: tran.whse_code
435: from ic_tran_cmp tran,
436: rcv_transactions rcv
437: where doc_type = 'PORC'
438: and gl_posted_ind = 1
439: and tran.line_id = rcv.transaction_id
440: and rcv.oe_order_line_id is NOT NULL
841: tran.line_id,
842: tran.orgn_code,
843: tran.whse_code
844: from ic_tran_pnd tran,
845: rcv_transactions rcv
846: where doc_type = 'PORC'
847: and completed_ind = 1
848: and gl_posted_ind = 0
849: and tran.line_id = rcv.transaction_id
856: tran.line_id,
857: tran.orgn_code,
858: tran.whse_code
859: from ic_tran_cmp tran,
860: rcv_transactions rcv
861: where doc_type = 'PORC'
862: and gl_posted_ind = 0
863: and tran.line_id = rcv.transaction_id
864: and rcv.oe_order_line_id is NOT NULL
1016: tran.line_id,
1017: tran.orgn_code,
1018: tran.whse_code
1019: from ic_tran_pnd tran,
1020: rcv_transactions rcv
1021: where doc_type = 'PORC'
1022: and completed_ind = 1
1023: and gl_posted_ind = 1
1024: and tran.line_id = rcv.transaction_id
1031: tran.line_id,
1032: tran.orgn_code,
1033: tran.whse_code
1034: from ic_tran_cmp tran,
1035: rcv_transactions rcv
1036: where doc_type = 'PORC'
1037: and gl_posted_ind = 1
1038: and tran.line_id = rcv.transaction_id
1039: and rcv.oe_order_line_id is NOT NULL