APPS.INV_RCV_STD_INSPECT_APIS dependencies on RCV_TRANSACTIONS_INTERFACE

Line 1572: rcv_transactions_interface rti

1568: BEGIN
1569: SELECT SUM (NVL (mtli.primary_quantity, 0))
1570: INTO l_processed_lot_prim_qty
1571: FROM mtl_transaction_lots_interface mtli,
1572: rcv_transactions_interface rti
1573: WHERE mtli.product_code = 'RCV'
1574: AND mtli.product_transaction_id =
1575: rti.interface_transaction_id
1576: AND mtli.lot_number = l_lot_number

Line 2639: , rcv_transactions_interface rti

2635: BEGIN
2636: SELECT SUM(Nvl(mtli.primary_quantity,0))
2637: INTO l_processed_lot_prim_qty
2638: FROM mtl_transaction_lots_interface mtli
2639: , rcv_transactions_interface rti
2640: WHERE mtli.product_code = 'RCV'
2641: AND mtli.product_transaction_id = rti.interface_transaction_id
2642: AND mtli.lot_number = l_lot_number
2643: AND rti.parent_transaction_id = l_rcv_transaction_id

Line 5361: select rcv_transactions_interface_s.nextval

5357: ELSE
5358: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
5359: END IF;
5360:
5361: select rcv_transactions_interface_s.nextval
5362: into l_interface_transaction_id from dual;
5363:
5364:
5365: if l_inspection_code = 'ACCEPT' then

Line 5506: insert into RCV_TRANSACTIONS_INTERFACE

5502: ELSE
5503: l_transaction_date := Trunc(Sysdate);
5504: END IF;
5505:
5506: insert into RCV_TRANSACTIONS_INTERFACE
5507: (
5508: receipt_source_code,
5509: interface_transaction_id,
5510: group_id,

Line 5719: UPDATE rcv_transactions_interface

5715: INTO v_lcm_ship_line_id, v_unit_landed_cost
5716: FROM rcv_shipment_lines
5717: WHERE shipment_line_id = l_shipment_line_id;
5718:
5719: UPDATE rcv_transactions_interface
5720: SET lcm_shipment_line_id = v_lcm_ship_line_id,
5721: unit_landed_cost = v_unit_landed_cost
5722: WHERE interface_transaction_id = l_interface_transaction_id
5723: AND to_organization_id = l_organization_id;

Line 5899: FROM rcv_transactions_interface rti

5895: -- Bug 2377796
5896: -- LPN lables are not getting printed for rejected LPNS
5897: --SELECT MIN(rti.interface_transaction_id)
5898: SELECT rti.interface_transaction_id
5899: FROM rcv_transactions_interface rti
5900: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
5901: -- GROUP BY rti.lpn_id;
5902: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5903: BEGIN