APPS.RCV_RECEIPTS_QUERY_SV dependencies on RCV_TRANSACTIONS

Line 151: FROM rcv_transactions_interface

147: SELECT nvl(sum(primary_quantity),0),
148: decode(min(item_id),null,min(unit_of_measure),min(primary_unit_of_measure))
149: INTO x_cancel_qty,
150: primary_uom
151: FROM rcv_transactions_interface
152: WHERE transaction_status_code = 'PENDING'
153: AND transaction_type = 'CANCEL'
154: AND po_line_location_id = x_line_location_id;
155: if (x_cancel_qty = 0) then

Line 276: from rcv_transactions

272:
273: -- Handle the return to vendor here
274:
275: select sum(nvl(quantity,0)) into x_quantity_returned
276: from rcv_transactions
277: where rcv_transactions.shipment_line_id = x_shipment_line_id and
278: rcv_transactions.transaction_type = 'RETURN TO VENDOR';
279:
280: IF X_quantity_returned > 0 then

Line 277: where rcv_transactions.shipment_line_id = x_shipment_line_id and

273: -- Handle the return to vendor here
274:
275: select sum(nvl(quantity,0)) into x_quantity_returned
276: from rcv_transactions
277: where rcv_transactions.shipment_line_id = x_shipment_line_id and
278: rcv_transactions.transaction_type = 'RETURN TO VENDOR';
279:
280: IF X_quantity_returned > 0 then
281:

Line 278: rcv_transactions.transaction_type = 'RETURN TO VENDOR';

274:
275: select sum(nvl(quantity,0)) into x_quantity_returned
276: from rcv_transactions
277: where rcv_transactions.shipment_line_id = x_shipment_line_id and
278: rcv_transactions.transaction_type = 'RETURN TO VENDOR';
279:
280: IF X_quantity_returned > 0 then
281:
282: x_available_qty := X_available_qty - X_quantity_returned;

Line 394: /* -- moved to procedure RCV_TRANSACTIONS_SV.get_rma_dest_info()

390: --
391:
392: ELSIF (x_receipt_source_code = 'CUSTOMER') THEN
393:
394: /* -- moved to procedure RCV_TRANSACTIONS_SV.get_rma_dest_info()
395:
396: select displayed_field, lookup_code into x_destination_type_dsp, x_destination_type_code
397: from po_lookup_codes where
398: lookup_CODE = 'RECEIVING' and

Line 470: /* -- moved to procedure RCV_TRANSACTIONS_SV.get_rma_dest_info()

466:
467: /* Bug# 2864540 - Due to performance problems replaced the view
468: rcv_enter_receipts_rma_v with the underlying base table */
469:
470: /* -- moved to procedure RCV_TRANSACTIONS_SV.get_rma_dest_info()
471: SELECT conversion_rate, conversion_rate_date
472: INTO x_rate, x_rate_date
473: FROM oe_order_headers_all
474: WHERE header_id = x_oe_order_header_id; */

Line 480: RCV_TRANSACTIONS_SV.get_rma_dest_info(x_oe_order_header_id,

476: /* Bug 3378162 - For RMA, we need to default the subinventory and
477: * location from the backing OE line -pjiang*/
478: -- get default subinventory, location, location_id from OE
479: -- get the conversion rate and destination_type info
480: RCV_TRANSACTIONS_SV.get_rma_dest_info(x_oe_order_header_id,
481: x_oe_order_line_id,
482: x_item_id,
483: x_deliver_to_sub,
484: x_deliver_to_location_id,

Line 931: x_inv_destinations := rcv_transactions_sv.val_if_inventory_destination (

927: ** but the item is not under item rev control then the rev must be
928: ** disabled. If there are no inventory destinations then it does not
929: ** matter
930: */
931: x_inv_destinations := rcv_transactions_sv.val_if_inventory_destination (
932: x_line_location_id,
933: x_shipment_line_id);
934:
935:

Line 945: DFF. This procedure is called in the block level post-query of rcv_transactions block . */

941:
942: END post_query;
943:
944: /* Bug 2668645- Added the following procedure to get the default value for the
945: DFF. This procedure is called in the block level post-query of rcv_transactions block . */
946:
947: /* Bug 3775987. Removing the get_dff_default procedure as it is raising
948: * flex errors related to Receiving Transactions DFF and not allowing to
949: * create receipts.