DBA Data[Home] [Help]

APPS.WMS_RETURN_SV dependencies on RCV_SERIALS_SUPPLY

Line 2026: AND exists (SELECT '1' FROM rcv_serials_supply rss

2022: , line_mark_id = NULL
2023: , cost_group_id = NULL
2024: WHERE serial_number = irec.serial_number
2025: AND inventory_item_id = irec.inventory_item_id
2026: AND exists (SELECT '1' FROM rcv_serials_supply rss
2027: WHERE rss.serial_num = serial_number
2028: AND rss.supply_type_code = 'RECEIVING');
2029: IF (l_debug = 1) THEN
2030: print_debug('TXN_COMPLETE: Deliver Transaction... updated serial... '||irec.serial_number);

Line 2063: AND exists (SELECT '1' FROM rcv_serials_supply rss

2059: , line_mark_id = NULL
2060: , cost_group_id = NULL
2061: WHERE serial_number = irec.serial_number
2062: AND inventory_item_id = irec.inventory_item_id
2063: AND exists (SELECT '1' FROM rcv_serials_supply rss
2064: WHERE rss.serial_num = serial_number
2065: AND rss.supply_type_code = 'RECEIVING');
2066: IF (l_debug = 1) THEN
2067: print_debug('TXN_COMPLETE: Deliver Transaction... updated serial... '||irec.serial_number);