DBA Data[Home] [Help]

APPS.INV_RCV_DIR_RCPT_APIS dependencies on RCV_TRANSACTIONS_INTERFACE

Line 626: rcv_transactions_interface_sv.convert_into_correct_qty(p_rcv_qty, p_rcv_uom, p_item_id, l_rcv_rcpt_rec.primary_uom);

622: l_rcv_transaction_rec.po_distribution_id := p_po_distribution_id;
623: l_rcv_transaction_rec.transaction_qty := p_rcv_qty;
624: l_rcv_transaction_rec.transaction_uom := p_rcv_uom;
625: l_rcv_transaction_rec.primary_quantity :=
626: rcv_transactions_interface_sv.convert_into_correct_qty(p_rcv_qty, p_rcv_uom, p_item_id, l_rcv_rcpt_rec.primary_uom);
627: l_rcv_transaction_rec.primary_uom := l_rcv_rcpt_rec.primary_uom;
628: l_total_primary_qty := l_total_primary_qty + l_rcv_transaction_rec.primary_quantity;
629: l_progress := '64';
630: -- update following fields for po_distribution related values

Line 4839: FROM rcv_transactions_interface rti

4835: /* SELECT MIN(rti.interface_transaction_id) */
4836: /* Group BY LPN_ID is changed for Express Receipts */
4837: /* Also duplicate print of LPN labels is avoided */
4838: SELECT MAX(rti.interface_transaction_id)
4839: FROM rcv_transactions_interface rti
4840: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4841: GROUP BY DECODE(p_source_type, 'ASNEXP', rti.interface_transaction_id, 'SHIPMENTEXP', rti.interface_transaction_id, NULL);
4842: -- GROUP BY rti.lpn_id;
4843:

Line 5119: FROM rcv_transactions_interface rti

5115: /* SELECT MIN(rti.interface_transaction_id) */
5116: /* Group BY LPN_ID is changed for Express Receipts */
5117: /* Also duplicate print of LPN labels is avoided */
5118: SELECT MAX(rti.interface_transaction_id)
5119: FROM rcv_transactions_interface rti
5120: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
5121: GROUP BY DECODE(p_source_type, 'ASNEXP', rti.interface_transaction_id, 'SHIPMENTEXP', rti.interface_transaction_id, NULL);
5122:
5123: -- GROUP BY rti.lpn_id;