DBA Data[Home] [Help]

APPS.RCV_SHIPMENT_LINES_PKG dependencies on RCV_TRANSACTIONS

Line 825: FROM rcv_transactions_interface

821: INTO l_trx_quantity,
822: l_trx_amount,
823: l_requested_amount,
824: l_material_stored_amount
825: FROM rcv_transactions_interface
826: WHERE interface_transaction_id = p_interface_transaction_id
827: AND shipment_line_id = p_shipment_line_id;
828:
829:

Line 887: FROM rcv_transactions

883: x_primary_uom VARCHAR2(26);
884:
885: CURSOR get_dist_line IS
886: SELECT transaction_id,Nvl(quantity,0)
887: FROM rcv_transactions
888: WHERE shipment_header_id = p_shipment_header_id
889: AND po_line_location_id = p_po_line_location_id
890: AND transaction_type = p_parent_transaction_type;
891:

Line 960: FROM rcv_transactions

956:
957:
958: CURSOR get_dist_line IS
959: SELECT transaction_id,Nvl(amount,0)
960: FROM rcv_transactions
961: WHERE shipment_header_id = p_shipment_header_id
962: AND po_line_location_id = p_po_line_location_id
963: AND transaction_type = p_parent_transaction_type;
964: