[Home] [Help]
510: AND Ltrim(Rtrim(lot_number)) = Ltrim(Rtrim(p_lot_number))
511: AND ROWNUM = 1
512: AND EXISTS (
513: SELECT 1
514: FROM rcv_transactions_interface RTI
515: WHERE RTI.INTERFACE_TRANSACTION_ID = MTLI.product_transaction_id
516: AND RTI.item_id = p_inventory_item_id
517: AND RTI.to_organization_id = p_organization_id
518: );
567: END IF;
568:
569: --Generate production_transaction_id if the parameter is NULL
570: IF (p_product_transaction_id IS NULL) THEN
571: SELECT rcv_transactions_interface_s.NEXTVAL
572: INTO l_product_transaction_id
573: FROM sys.dual;
574: ELSE
575: l_product_transaction_id := p_product_transaction_id;
1423: END IF;
1424:
1425: --Generate production_transaction_id if the parameter is NULL
1426: IF (p_product_transaction_id IS NULL AND p_product_code = 'RCV') THEN
1427: SELECT rcv_transactions_interface_s.NEXTVAL
1428: INTO l_product_transaction_id
1429: FROM sys.dual;
1430: ELSE
1431: l_product_transaction_id := p_product_transaction_id;
2687: -- get the org_id and item_id from rti to check if OPM transaction
2688: BEGIN
2689: SELECT DISTINCT(to_organization_id)
2690: INTO l_org_id
2691: FROM rcv_transactions_interface
2692: WHERE lpn_group_id = p_lpn_group_id;
2693: EXCEPTION
2694: WHEN OTHERS THEN
2695: NULL;
2813: SELECT 1
2814: INTO l_exist
2815: FROM dual
2816: WHERE exists (SELECT 1
2817: FROM rcv_transactions_interface
2818: WHERE group_id = p_group_id
2819: AND item_id is null
2820: AND item_description is null
2821: AND (lpn_id is not null
2845: */
2846: -- l_exist := 0;
2847: -- SELECT 1
2848: -- into l_exist
2849: -- FROM rcv_transactions_interface
2850: -- WHERE group_id = p_group_id ;
2851: -- print_debug('group_id =' || p_group_id, 4);
2852: -- print_debug('exist =' || l_exist, 4);
2853:
2905: , NVL(auto_transact_code, '@@@') auto_transact_code
2906: , transfer_lpn_id
2907: , transfer_license_plate_number
2908: , location_id
2909: FROM rcv_transactions_interface rti
2910: WHERE GROUP_ID = p_group_id
2911: AND interface_transaction_id = p_rti_id;
2912:
2913: CURSOR c_rti_sub_check_grp_id IS
2918: , NVL(auto_transact_code, '@@@') auto_transact_code
2919: , transfer_lpn_id
2920: , transfer_license_plate_number
2921: , location_id
2922: FROM rcv_transactions_interface rti
2923: WHERE GROUP_ID = p_group_id;
2924:
2925: CURSOR c_rti_sub_check_intf_id IS
2926: SELECT subinventory
2930: , NVL(auto_transact_code, '@@@') auto_transact_code
2931: , transfer_lpn_id
2932: , transfer_license_plate_number
2933: , location_id
2934: FROM rcv_transactions_interface rti
2935: WHERE interface_transaction_id = p_rti_id;
2936:
2937: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2938: BEGIN
3221:
3222: BEGIN
3223: SELECT to_organization_id
3224: INTO l_org_id
3225: FROM rcv_transactions_interface
3226: WHERE interface_transaction_id = p_rti_id;
3227: EXCEPTION
3228: WHEN OTHERS THEN
3229: NULL;
3297: SELECT DISTINCT DECODE (rt.transaction_type,'ACCEPT','INSPECT',
3298: 'REJECT','INSPECT',
3299: 'DELIVER', DECODE (mp.wms_enabled_flag,'Y','PUTAWAY','DELIVER'),
3300: transaction_type) transaction_type
3301: FROM rcv_transactions rt,
3302: mtl_parameters mp
3303: WHERE rt.group_id = p_group_id
3304: AND rt.organization_id = mp.organization_id;
3305:
3305:
3306: CURSOR c_pregen_cursor IS
3307: SELECT DISTINCT rt.transfer_lpn_id
3308: , rt.organization_id
3309: FROM rcv_transactions rt
3310: , mtl_parameters mp
3311: , mtl_system_items_kfv msi
3312: , rcv_supply rs
3313: WHERE mp.wms_enabled_flag = 'Y'