DBA Data[Home] [Help]

APPS.RCV_RECEIPTS_QUERY_SV dependencies on RCV_TRANSACTIONS_SV

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

369: --
370:
371: ELSIF (x_receipt_source_code = 'CUSTOMER') THEN
372:
373: /* -- moved to procedure RCV_TRANSACTIONS_SV.get_rma_dest_info()
374:
375: select displayed_field, lookup_code into x_destination_type_dsp, x_destination_type_code
376: from po_lookup_codes where
377: lookup_CODE = 'RECEIVING' and

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

445:
446: /* Bug# 2864540 - Due to performance problems replaced the view
447: rcv_enter_receipts_rma_v with the underlying base table */
448:
449: /* -- moved to procedure RCV_TRANSACTIONS_SV.get_rma_dest_info()
450: SELECT conversion_rate, conversion_rate_date
451: INTO x_rate, x_rate_date
452: FROM oe_order_headers_all
453: WHERE header_id = x_oe_order_header_id; */

Line 459: RCV_TRANSACTIONS_SV.get_rma_dest_info(x_oe_order_header_id,

455: /* Bug 3378162 - For RMA, we need to default the subinventory and
456: * location from the backing OE line -pjiang*/
457: -- get default subinventory, location, location_id from OE
458: -- get the conversion rate and destination_type info
459: RCV_TRANSACTIONS_SV.get_rma_dest_info(x_oe_order_header_id,
460: x_oe_order_line_id,
461: x_item_id,
462: x_deliver_to_sub,
463: x_deliver_to_location_id,

Line 929: x_inv_destinations := rcv_transactions_sv.val_if_inventory_destination (

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