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 4984: FROM rcv_transactions_interface rti

4980: /* SELECT MIN(rti.interface_transaction_id) */
4981: /* Group BY LPN_ID is changed for Express Receipts */
4982: /* Also duplicate print of LPN labels is avoided */
4983: SELECT MAX(rti.interface_transaction_id)
4984: FROM rcv_transactions_interface rti
4985: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4986: GROUP BY DECODE(p_source_type, 'ASNEXP', rti.interface_transaction_id, 'SHIPMENTEXP', rti.interface_transaction_id, NULL);
4987: -- GROUP BY rti.lpn_id;
4988:

Line 5264: FROM rcv_transactions_interface rti

5260: /* SELECT MIN(rti.interface_transaction_id) */
5261: /* Group BY LPN_ID is changed for Express Receipts */
5262: /* Also duplicate print of LPN labels is avoided */
5263: SELECT MAX(rti.interface_transaction_id)
5264: FROM rcv_transactions_interface rti
5265: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
5266: GROUP BY DECODE(p_source_type, 'ASNEXP', rti.interface_transaction_id, 'SHIPMENTEXP', rti.interface_transaction_id, NULL);
5267:
5268: -- GROUP BY rti.lpn_id;