[Home] [Help]
167: AND order_quantity_uom = uom_code
168: AND si.inventory_item_id(+) = oel.inventory_item_id;
169:
170: CURSOR get_ship_order(
171: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE
172: ) IS
173: SELECT quantity_shipped quantity,
174: item_id,
175: unit_of_measure,
173: SELECT quantity_shipped quantity,
174: item_id,
175: unit_of_measure,
176: primary_unit_of_measure
177: FROM rcv_shipment_lines
178: WHERE shipment_line_id = p_shipment_line_id;
179:
180: /* Bug. 4693257.
181: * We need to get the quantity from po_distributions
231: the following cursors: get_rcv_req_row, get_rcv_oe_row,
232: get_rcv_ship_row, get_rcv_po_row are all the same query, but
233: with different driving where clauses. The cursor used is
234: determined by p_supply_demand_type_id. The cursors return all
235: the rows in RCV_SHIPMENT_LINES and all the receipts/+correction
236: to receipts/shipments in RCV_TRANSACTIONS_INTERFACE that apply
237: to the backing doc
238:
239: The parameters p_organization_id, p_item_id, p_revision,
303: rsl.item_id,
304: rsl.unit_of_measure,
305: rsl.primary_unit_of_measure,
306: rsl.to_organization_id
307: FROM rcv_shipment_lines rsl,
308: rcv_supply rs
309: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
310: AND ( p_organization_id IS NULL
311: OR p_organization_id = rsl.to_organization_id)
390: rsl.item_id,
391: rsl.unit_of_measure,
392: rsl.primary_unit_of_measure,
393: rsl.to_organization_id
394: FROM rcv_shipment_lines rsl,
395: rcv_supply rs
396: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
397: AND ( p_organization_id IS NULL
398: OR p_organization_id = rsl.to_organization_id)
427: * is SHIP since it actually gets the current shipped_qty
428: * for both ASN and Intrasit transactions.
429: */
430: CURSOR get_rcv_ship_row(
431: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE
432: ) IS
433: SELECT DECODE(rti.transaction_type,
434: --'SHIP', rti.quantity,
435: 'RECEIVE', rti.quantity,
488: rsl.item_id,
489: rsl.unit_of_measure,
490: rsl.primary_unit_of_measure,
491: rsl.to_organization_id
492: FROM rcv_shipment_lines rsl,
493: rcv_supply rs
494: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
495: AND ( p_organization_id IS NULL
496: OR p_organization_id = rsl.to_organization_id)
605: rsl.item_id,
606: rsl.unit_of_measure,
607: rsl.primary_unit_of_measure,
608: rsl.to_organization_id
609: FROM rcv_shipment_lines rsl,
610: rcv_supply rs
611: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
612: AND ( p_organization_id IS NULL
613: OR p_organization_id = rsl.to_organization_id)
750:
751: /*
752: The logic below first defaults x_rcv_order_quantity from the
753: backing docs. It then loops through all the rows in
754: rcv_transactions_interface (RTI) and rcv_shipment_lines (RSL).
755: If the row is in RSL then it increases the running value of
756: x_rcv_quantity by shipped_quantity for non-wms orgs and increases the value
757: of x_rcv_quantity by received_quantity for wms orgs. We know that RSL's
758: shipped_quantity and receipt_quantity are an accurate summation of all rcv_transaction
1030: AND header_id = p_supply_demand_header_id;
1031: ELSIF(p_supply_demand_type_id IN(26)) THEN --intransit
1032: SELECT 'Y'
1033: INTO x_valid_status
1034: FROM rcv_shipment_lines rsl,
1035: rcv_shipment_headers rsh
1036: WHERE shipment_line_status_code IN('EXPECTED', 'PARTIALLY RECEIVED')
1037: AND rsl.shipment_header_id = rsh.shipment_header_id
1038: AND ( p_organization_id IS NULL
1046: /* Bug#12320593 */
1047: IF (p_supply_demand_type_id IN(25)) THEN --asn
1048: SELECT 'Y'
1049: INTO x_valid_status
1050: FROM rcv_shipment_lines rsl,
1051: rcv_shipment_headers rsh
1052: WHERE shipment_line_status_code IN('EXPECTED', 'PARTIALLY RECEIVED')
1053: AND rsl.shipment_header_id = rsh.shipment_header_id
1054: AND rsl.shipment_line_id = p_supply_demand_line_detail