DBA Data[Home] [Help]

APPS.WMS_RETURN_SV dependencies on RCV_SERIALS_SUPPLY

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

2041: , line_mark_id = NULL
2042: , cost_group_id = NULL
2043: WHERE serial_number = irec.serial_number
2044: AND inventory_item_id = irec.inventory_item_id
2045: AND exists (SELECT '1' FROM rcv_serials_supply rss
2046: WHERE rss.serial_num = serial_number
2047: AND rss.supply_type_code = 'RECEIVING');
2048: IF (l_debug = 1) THEN
2049: print_debug('TXN_COMPLETE: Deliver Transaction... updated serial... '||irec.serial_number);

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

2078: , line_mark_id = NULL
2079: , cost_group_id = NULL
2080: WHERE serial_number = irec.serial_number
2081: AND inventory_item_id = irec.inventory_item_id
2082: AND exists (SELECT '1' FROM rcv_serials_supply rss
2083: WHERE rss.serial_num = serial_number
2084: AND rss.supply_type_code = 'RECEIVING');
2085: IF (l_debug = 1) THEN
2086: print_debug('TXN_COMPLETE: Deliver Transaction... updated serial... '||irec.serial_number);