APPS.INV_RCV_INTEGRATION_APIS dependencies on RCV_TRANSACTIONS_INTERFACE

Line 518: FROM rcv_transactions_interface RTI

514: AND Ltrim(Rtrim(lot_number)) = Ltrim(Rtrim(p_lot_number))
515: AND ROWNUM = 1
516: AND EXISTS (
517: SELECT 1
518: FROM rcv_transactions_interface RTI
519: WHERE RTI.INTERFACE_TRANSACTION_ID = MTLI.product_transaction_id
520: AND RTI.item_id = p_inventory_item_id
521: AND RTI.to_organization_id = p_organization_id
522: );

Line 575: SELECT rcv_transactions_interface_s.NEXTVAL

571: END IF;
572:
573: --Generate production_transaction_id if the parameter is NULL
574: IF (p_product_transaction_id IS NULL) THEN
575: SELECT rcv_transactions_interface_s.NEXTVAL
576: INTO l_product_transaction_id
577: FROM sys.dual;
578: ELSE
579: l_product_transaction_id := p_product_transaction_id;

Line 1443: SELECT rcv_transactions_interface_s.NEXTVAL

1439: END IF;
1440:
1441: --Generate production_transaction_id if the parameter is NULL
1442: IF (p_product_transaction_id IS NULL AND p_product_code = 'RCV') THEN
1443: SELECT rcv_transactions_interface_s.NEXTVAL
1444: INTO l_product_transaction_id
1445: FROM sys.dual;
1446: ELSE
1447: l_product_transaction_id := p_product_transaction_id;

Line 2720: FROM rcv_transactions_interface

2716: -- get the org_id and item_id from rti to check if OPM transaction
2717: BEGIN
2718: SELECT DISTINCT(to_organization_id)
2719: INTO l_org_id
2720: FROM rcv_transactions_interface
2721: WHERE lpn_group_id = p_lpn_group_id;
2722: EXCEPTION
2723: WHEN OTHERS THEN
2724: NULL;

Line 2846: FROM rcv_transactions_interface

2842: SELECT 1
2843: INTO l_exist
2844: FROM dual
2845: WHERE exists (SELECT 1
2846: FROM rcv_transactions_interface
2847: WHERE group_id = p_group_id
2848: AND item_id is null
2849: AND item_description is null
2850: AND (lpn_id is not null

Line 2878: -- FROM rcv_transactions_interface

2874: */
2875: -- l_exist := 0;
2876: -- SELECT 1
2877: -- into l_exist
2878: -- FROM rcv_transactions_interface
2879: -- WHERE group_id = p_group_id ;
2880: -- print_debug('group_id =' || p_group_id, 4);
2881: -- print_debug('exist =' || l_exist, 4);
2882:

Line 2938: FROM rcv_transactions_interface rti

2934: , NVL(auto_transact_code, '@@@') auto_transact_code
2935: , transfer_lpn_id
2936: , transfer_license_plate_number
2937: , location_id
2938: FROM rcv_transactions_interface rti
2939: WHERE GROUP_ID = p_group_id
2940: AND interface_transaction_id = p_rti_id;
2941:
2942: CURSOR c_rti_sub_check_grp_id IS

Line 2951: FROM rcv_transactions_interface rti

2947: , NVL(auto_transact_code, '@@@') auto_transact_code
2948: , transfer_lpn_id
2949: , transfer_license_plate_number
2950: , location_id
2951: FROM rcv_transactions_interface rti
2952: WHERE GROUP_ID = p_group_id;
2953:
2954: CURSOR c_rti_sub_check_intf_id IS
2955: SELECT subinventory

Line 2963: FROM rcv_transactions_interface rti

2959: , NVL(auto_transact_code, '@@@') auto_transact_code
2960: , transfer_lpn_id
2961: , transfer_license_plate_number
2962: , location_id
2963: FROM rcv_transactions_interface rti
2964: WHERE interface_transaction_id = p_rti_id;
2965:
2966: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2967: BEGIN

Line 3254: FROM rcv_transactions_interface

3250:
3251: BEGIN
3252: SELECT to_organization_id
3253: INTO l_org_id
3254: FROM rcv_transactions_interface
3255: WHERE interface_transaction_id = p_rti_id;
3256: EXCEPTION
3257: WHEN OTHERS THEN
3258: NULL;