GML PO/Stock Return History
Description
Categories: BI Publisher
Imported from BI Publisher
Description: PO/Stock Return History Report of OPM PO
Application: Process Manufacturing Logistics
Source: PO/Stock Return History Report (XML)
Short Name: POR03USR_XML
DB package: GML_POR03USR_XMLP_PKG
Description: PO/Stock Return History Report of OPM PO
Application: Process Manufacturing Logistics
Source: PO/Stock Return History Report (XML)
Short Name: POR03USR_XML
DB package: GML_POR03USR_XMLP_PKG
Run
GML PO/Stock Return History and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT rh.orgn_code, rh.return_no, rh.return_date, vm.vendor_no, rh.shipper_code, rd.line_no, rd.item_id, LTRIM(RTRIM(rd.RMA)) RMA1, rd.return_code, reas.reason_desc1, rd.reorder_ind, rd.return_qty1, rd.return_qty2, rd.return_um1, rd.return_um2, rcvh.recv_no, rcvd.line_no recvline_no, rcvd.recv_qty1, rcvd.recv_qty2, rcvd.recv_um1, rcvd.recv_um2, ordh.po_no, ordd.line_no poline_no, ordd.order_qty1, ordd.order_qty2, ordd.order_um1, ordd.order_um2, tp.lot_id, tp.whse_code, tp.location, tp.trans_qty*(-1) trans_qty, tp.trans_qty2*(-1) trans_qty2, tp.trans_um, tp.trans_um2, im.item_no, rd.line_id, lm.lot_no, lm.sublot_no FROM po_rtrn_hdr rh, po_rtrn_dtl rd, ic_tran_pnd tp, ic_item_mst im, po_vend_mst vm, ic_lots_mst lm, po_recv_hdr rcvh, po_recv_dtl rcvd, po_ordr_hdr ordh, po_ordr_dtl ordd , sy_reas_cds reas WHERE rh.return_id = rd.return_id and lm.lot_id(+) = tp.lot_id and lm.item_id(+) = tp.item_id and rh.delete_mark = 0 and tp.doc_type = 'RTRN' and tp.delete_mark = 0 and rd.return_id = tp.doc_id and rd.line_id = tp.line_id and rd.item_id = im.item_id and rh.return_vendor_id = vm.vendor_id (+) and rcvd.line_id = rd.recvline_id and rcvh.recv_id = rd.recv_id and reas.reason_code(+) = rd.return_code and ordd.line_id(+) = rd.poline_id and ordh.po_id(+) = rd.po_id &PARAM_WHERE_CLAUSE ORDER BY rh.return_no,rd.line_no |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Include PO Returns |
|
LOV Oracle | |
Include Stock Returns |
|
LOV Oracle | |
From Return No |
|
LOV Oracle | |
To Return No |
|
LOV Oracle | |
From Vendor No |
|
LOV Oracle | |
To Vendor No |
|
LOV Oracle | |
From Return Date |
|
Date | |
To Return Date |
|
Date | |
From Return Reason |
|
LOV Oracle | |
To Return Reason |
|
LOV Oracle | |
From Item |
|
LOV Oracle | |
To Item |
|
LOV Oracle | |
From Lot No |
|
LOV Oracle | |
To Lot No |
|
LOV Oracle | |
From sublot No |
|
LOV Oracle | |
To Sublot No |
|
LOV Oracle | |
From Warehouse |
|
LOV Oracle | |
To Warehouse |
|
LOV Oracle |