DBA Data[Home] [Help]

APPS.GML_RCV_DIR_RCPT_APIS dependencies on RCV_TRANSACTIONS_INTERFACE

Line 439: l_rcv_transaction_rec.primary_quantity := rcv_transactions_interface_sv.convert_into_correct_qty(p_rcv_qty,

435: l_rcv_transaction_rec.po_distribution_id := p_po_distribution_id;
436:
437: l_rcv_transaction_rec.transaction_qty := p_rcv_qty;
438: l_rcv_transaction_rec.transaction_uom := p_rcv_uom;
439: l_rcv_transaction_rec.primary_quantity := rcv_transactions_interface_sv.convert_into_correct_qty(p_rcv_qty,
440: p_rcv_uom,
441: p_item_id,
442: l_rcv_rcpt_rec.primary_uom);
443: l_rcv_transaction_rec.primary_uom := l_rcv_rcpt_rec.primary_uom;

Line 3202: FROM rcv_transactions_interface rti

3198: /* SELECT MIN(rti.interface_transaction_id) */
3199: /* Group BY LPN_ID is changed for Express Receipts */
3200: /* Also duplicate print of LPN labels is avoided */
3201: SELECT MAX(rti.interface_transaction_id)
3202: FROM rcv_transactions_interface rti
3203: WHERE rti.group_id = INV_rcv_common_apis.g_rcv_global_var.interface_group_id
3204: GROUP BY decode(p_source_type, 'ASNEXP',rti.interface_transaction_id,'SHIPMENTEXP',rti.interface_transaction_id,null) ;
3205: -- GROUP BY rti.lpn_id;
3206: BEGIN

Line 3380: FROM rcv_transactions_interface rti

3376: /* Group BY LPN_ID is changed for Express Receipts */
3377: /* Also duplicate print of LPN labels is avoided */
3378:
3379: SELECT MAX(rti.interface_transaction_id)
3380: FROM rcv_transactions_interface rti
3381: WHERE rti.group_id = INV_rcv_common_apis.g_rcv_global_var.interface_group_id
3382: GROUP BY decode(p_source_type, 'ASNEXP',rti.interface_transaction_id,'SHIPMENTEXP',rti.interface_transaction_id,null) ;
3383: -- GROUP BY rti.lpn_id;
3384: BEGIN