APPS.INV_RCV_STD_INSPECT_APIS dependencies on RCV_TRANSACTIONS_INTERFACE

Line 749: , rcv_transactions_interface rti

745: BEGIN
746: SELECT SUM(Nvl(mtli.primary_quantity,0))
747: INTO l_processed_lot_prim_qty
748: FROM mtl_transaction_lots_interface mtli
749: , rcv_transactions_interface rti
750: WHERE mtli.product_code = 'RCV'
751: AND mtli.product_transaction_id = rti.interface_transaction_id
752: AND mtli.lot_number = l_lot_number
753: AND rti.parent_transaction_id = l_rcv_transaction_id

Line 3461: select rcv_transactions_interface_s.nextval

3457: ELSE
3458: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
3459: END IF;
3460:
3461: select rcv_transactions_interface_s.nextval
3462: into l_interface_transaction_id from dual;
3463:
3464:
3465: if l_inspection_code = 'ACCEPT' then

Line 3606: insert into RCV_TRANSACTIONS_INTERFACE

3602: ELSE
3603: l_transaction_date := Trunc(Sysdate);
3604: END IF;
3605:
3606: insert into RCV_TRANSACTIONS_INTERFACE
3607: (
3608: receipt_source_code,
3609: interface_transaction_id,
3610: group_id,

Line 3819: UPDATE rcv_transactions_interface

3815: INTO v_lcm_ship_line_id, v_unit_landed_cost
3816: FROM rcv_shipment_lines
3817: WHERE shipment_line_id = l_shipment_line_id;
3818:
3819: UPDATE rcv_transactions_interface
3820: SET lcm_shipment_line_id = v_lcm_ship_line_id,
3821: unit_landed_cost = v_unit_landed_cost
3822: WHERE interface_transaction_id = l_interface_transaction_id
3823: AND to_organization_id = l_organization_id;

Line 3999: FROM rcv_transactions_interface rti

3995: -- Bug 2377796
3996: -- LPN lables are not getting printed for rejected LPNS
3997: --SELECT MIN(rti.interface_transaction_id)
3998: SELECT rti.interface_transaction_id
3999: FROM rcv_transactions_interface rti
4000: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
4001: -- GROUP BY rti.lpn_id;
4002: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4003: BEGIN