[Home] [Help]
143: AND order_quantity_uom = uom_code
144: AND si.inventory_item_id(+) = oel.inventory_item_id;
145:
146: CURSOR get_ship_order(
147: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE
148: ) IS
149: SELECT quantity_shipped quantity,
150: item_id,
151: unit_of_measure,
149: SELECT quantity_shipped quantity,
150: item_id,
151: unit_of_measure,
152: primary_unit_of_measure
153: FROM rcv_shipment_lines
154: WHERE shipment_line_id = p_shipment_line_id;
155:
156: /* Bug. 4693257.
157: * We need to get the quantity from po_distributions
186: the following cursors: get_rcv_req_row, get_rcv_oe_row,
187: get_rcv_ship_row, get_rcv_po_row are all the same query, but
188: with different driving where clauses. The cursor used is
189: determined by p_supply_demand_type_id. The cursors return all
190: the rows in RCV_SHIPMENT_LINES and all the receipts/+correction
191: to receipts/shipments in RCV_TRANSACTIONS_INTERFACE that apply
192: to the backing doc
193:
194: The parameters p_organization_id, p_item_id, p_revision,
258: rsl.item_id,
259: rsl.unit_of_measure,
260: rsl.primary_unit_of_measure,
261: rsl.to_organization_id
262: FROM rcv_shipment_lines rsl,
263: rcv_supply rs
264: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
265: AND ( p_organization_id IS NULL
266: OR p_organization_id = rsl.to_organization_id)
345: rsl.item_id,
346: rsl.unit_of_measure,
347: rsl.primary_unit_of_measure,
348: rsl.to_organization_id
349: FROM rcv_shipment_lines rsl,
350: rcv_supply rs
351: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
352: AND ( p_organization_id IS NULL
353: OR p_organization_id = rsl.to_organization_id)
382: * is SHIP since it actually gets the current shipped_qty
383: * for both ASN and Intrasit transactions.
384: */
385: CURSOR get_rcv_ship_row(
386: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE
387: ) IS
388: SELECT DECODE(rti.transaction_type,
389: --'SHIP', rti.quantity,
390: 'RECEIVE', rti.quantity,
443: rsl.item_id,
444: rsl.unit_of_measure,
445: rsl.primary_unit_of_measure,
446: rsl.to_organization_id
447: FROM rcv_shipment_lines rsl,
448: rcv_supply rs
449: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
450: AND ( p_organization_id IS NULL
451: OR p_organization_id = rsl.to_organization_id)
560: rsl.item_id,
561: rsl.unit_of_measure,
562: rsl.primary_unit_of_measure,
563: rsl.to_organization_id
564: FROM rcv_shipment_lines rsl,
565: rcv_supply rs
566: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
567: AND ( p_organization_id IS NULL
568: OR p_organization_id = rsl.to_organization_id)
700:
701: /*
702: The logic below first defaults x_rcv_order_quantity from the
703: backing docs. It then loops through all the rows in
704: rcv_transactions_interface (RTI) and rcv_shipment_lines (RSL).
705: If the row is in RSL then it increases the running value of
706: x_rcv_quantity by shipped_quantity for non-wms orgs and increases the value
707: of x_rcv_quantity by received_quantity for wms orgs. We know that RSL's
708: shipped_quantity and receipt_quantity are an accurate summation of all rcv_transaction
936: AND header_id = p_supply_demand_header_id;
937: ELSIF(p_supply_demand_type_id IN(26)) THEN --intransit
938: SELECT 'Y'
939: INTO x_valid_status
940: FROM rcv_shipment_lines rsl,
941: rcv_shipment_headers rsh
942: WHERE shipment_line_status_code IN('EXPECTED', 'PARTIALLY RECEIVED')
943: AND rsl.shipment_header_id = rsh.shipment_header_id
944: AND ( p_organization_id IS NULL
972: --already passed the first check for asn's, now perform the second
973: IF (p_supply_demand_type_id IN(25)) THEN --asn
974: SELECT 'Y'
975: INTO x_valid_status
976: FROM rcv_shipment_lines rsl,
977: rcv_shipment_headers rsh
978: WHERE shipment_line_status_code IN('EXPECTED', 'PARTIALLY RECEIVED')
979: AND rsl.shipment_header_id = rsh.shipment_header_id
980: AND rsl.shipment_line_id = p_supply_demand_line_detail